Pennsylvania Banner Users Group 2008 Fall Conference - PowerPoint

Document Sample
Pennsylvania Banner Users Group 2008 Fall Conference - PowerPoint Powered By Docstoc
					Pennsylvania Banner Users Group
2008 Fall Conference


    Messiah College & Imaging
     The saga continues . . .
General Announcements:


 Please turn off all cell phones/pagers
 If you must leave the session early, please
  do so as discreetly as possible
 Please avoid side conversations during the
  session
 Questions will be answered …..


      Thank you for your cooperation
Introduction


 Our History
 General overview with a few tech tidbits
  thrown in
 Tips, tricks and a few “bloopers”
 Questions
Our History


 Went live with imaging system 1998
     OTG 4.3
     SQL Database
     1 application
 Banner client since 2005
     Oracle 10g
     All 5 modules
 Windows/Novell Network site
How did it happen?


 Go – Live


 SQL + Oracle = “Oh my”


 Consultant??


 Training – In about an hour
     (scanning, indexing, retrieval)
What does it look like?


 2 data sources
         38 applications
           35 in Oracle
           18 Baseline Applications
What does it look like?
 Components & Versions
     BDMS 7.2
     License Server 5.4
     Application Xtender 5.2 & 5.4 (Document
      Manager)
     Scan Xtender 5.2 & 5.4 (Image Capture)
     Reports Manager 5.4
     Disk Xtender 2000
     DX License Server 6.2
     Web Xtender 5.4
     XS Admin 5.4
What does it look like?


        Storage – Extended drive on the SAN
          200GB SCSI drive currently ¾ full
          Server and SAN are connected via a 1 GB
           Ethernet network using the iSCSI protocol
What does it look like?

                               SQL
                  Oracle       DB
 Application       DB                     Disk
 Generator                               Xtender

                           Banner


 License                   XSAdmin
 Server                                        SCSI



                              User
        Reports            Workstation      WebX
        Manager             (AX, SX,
                            App Gen)
XSAdmin – The Motor
XSAdmin – The Motor


 2 data sources
         38 applications
           35 in Oracle
           18 Baseline Applications
XSAdmin – The Motor
XSAdmin – The Motor
XSAdmin – The Motor
XSAdmin - The Motor
Database – The Fuel


 AE_APPS – Main table
 AE_PATHS – Storage mapping
 AE_DEFS – field definitions for each
    application
   AE_DT### - Index data
   AE_DL### - Page pointers
   AE_RF### - Key reference file data
   UL#_# - User defined lists
Database – The Fuel


 AE_CFG – System configuration
 AE_LOGIN – Usernames & passwords
 AE_PERMS – User permissions
 H#_# - Document level security
Extended Drive – The Battery
Extended Drive – The Battery
License Server – The Wiring
Disk Xtender – The Doors
Scan Xtender – The Windows
Application Generator – The Mechanic
Application Generator – The Mechanic
Application Generator – The Mechanic
Application Generator – The Mechanic
Application Generator – The Mechanic
ErmX (Reports Manager) - Auto Pilot
Show me Banner – The Exterior
Show me Banner


 Imaging Access Points
        Banner Xtender Solutions – Will pull
      document or query based on rules defined in
      EXABCXT
        BXS Add Document – Will populate
      indexes based upon the record you are
      viewing
     Tools Menu – Banner XtenderSolutions
Show me Banner


 So how do the two systems “talk”?
 Query Strings
     http://scooter.messiah.edu/WX/isubmitquery.aspx?DSN=BANR&AppName=B-H-
      ID&SavedQuery=B-G-ID%2C%20B-H-APPL%2C%20B-H-EMPL%20%26%20B-H-
      ID&QueryType=1&UpdateAvlFieldsOnly=true&ID=00433351&Credentials=28:DC8B09C4
      3D11F543495D3F34463A60A580E866756DA24C731A5663978E78484B43BE6EC8372
      A826DC8BDAF6B9EA2BA1E095D75E2A7B57692EF49BEE971AEE03E6154EB7D9038
      A5E79A273811CAADF31980B2B5D326573B74Info Item 3
Show me Banner


 So how do the two systems “talk”?
 Query Strings
     http://scooter.messiah.edu/WX/isubmitquery.aspx?DSN=BANR&AppName=B-H-
      ID&SavedQuery=B-G-ID%2C%20B-H-APPL%2C%20B-H-EMPL%20%26%20B-H-
      ID&QueryType=1&UpdateAvlFieldsOnly=true&ID=00433351&Credentials=28:DC8B09C4
      3D11F543495D3F34463A60A580E866756DA24C731A5663978E78484B43BE6EC8372
      A826DC8BDAF6B9EA2BA1E095D75E2A7B57692EF49BEE971AEE03E6154EB7D9038
      A5E79A273811CAADF31980B2B5D326573B74Info Item 3
Show me Banner


 So how do the two systems “talk”?
 Query Strings
     http://scooter.messiah.edu/WX/isubmitquery.aspx?DSN=BANR&AppName=B-H-
      ID&SavedQuery=B-G-ID%2C%20B-H-APPL%2C%20B-H-EMPL%20%26%20B-H-
      ID&QueryType=1&UpdateAvlFieldsOnly=true&ID=00433351&Credentials=28:DC8B09C4
      3D11F543495D3F34463A60A580E866756DA24C731A5663978E78484B43BE6EC8372
      A826DC8BDAF6B9EA2BA1E095D75E2A7B57692EF49BEE971AEE03E6154EB7D9038
      A5E79A273811CAADF31980B2B5D326573B74Info Item 3
Show me Banner


 So how do the two systems “talk”?
 Query Strings
     http://scooter.messiah.edu/WX/isubmitquery.aspx?DSN=BANR&AppName=B-H-
      ID&SavedQuery=B-G-ID%2C%20B-H-APPL%2C%20B-H-EMPL%20%26%20B-H-
      ID&QueryType=1&UpdateAvlFieldsOnly=true&ID=00433351&Credentials=28:DC8B09C4
      3D11F543495D3F34463A60A580E866756DA24C731A5663978E78484B43BE6EC8372
      A826DC8BDAF6B9EA2BA1E095D75E2A7B57692EF49BEE971AEE03E6154EB7D9038
      A5E79A273811CAADF31980B2B5D326573B74Info Item 3

     SavedQuery=B-G-ID, B-H-APPL, B-H-EMPL & B-H-ID
Show me Banner


 So how do the two systems “talk”?
 Query Strings
     http://scooter.messiah.edu/WX/isubmitquery.aspx?DSN=BANR&AppName=B-H-
      ID&SavedQuery=B-G-ID%2C%20B-H-APPL%2C%20B-H-EMPL%20%26%20B-H-
      ID&QueryType=1&UpdateAvlFieldsOnly=true&ID=00433351&Credentials=28:DC8B09C4
      3D11F543495D3F34463A60A580E866756DA24C731A5663978E78484B43BE6EC8372
      A826DC8BDAF6B9EA2BA1E095D75E2A7B57692EF49BEE971AEE03E6154EB7D9038
      A5E79A273811CAADF31980B2B5D326573B74Info Item 3
Show me Banner


 So how do the two systems “talk”?
 Query Strings
     http://scooter.messiah.edu/WX/isubmitquery.aspx?DSN=BANR&AppName=B-H-
      ID&SavedQuery=B-G-ID%2C%20B-H-APPL%2C%20B-H-EMPL%20%26%20B-H-
      ID&QueryType=1&UpdateAvlFieldsOnly=true&ID=00433351&Credentials=28:DC8B09C
      43D11F543495D3F34463A60A580E866756DA24C731A5663978E78484B43BE6EC837
      2A826DC8BDAF6B9EA2BA1E095D75E2A7B57692EF49BEE971AEE03E6154EB7D90
      38A5E79A273811CAADF31980B2B5D326573B74Info Item 3
Show me Banner
Tips, Tricks, and “Bloopers”




 Tip – When in doubt iisreset
Tips


 Run re-baseline scripts
 Don’t update Adobe
 Have all the documentation at your finger
  tips
 Have servers at your disposal
 Don’t be afraid
 Plan, Plan, Make the users think
Tricks

 It works
Tricks

 Changes to the baseline applications can
    be made
   A / 1024 = X, X / 1024 = Y, X - (1024 * Y) = Z
 EXRBCXT – Context Rules Report
Bloopers


 Software Requirements
     Windows, Adobe, Java
 Hardware Requirements
 Test Environment
Open to the Floor
 Questions
 Comments



                   Dorie Minich
              dminich@messiah.edu

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:13
posted:5/24/2012
language:
pages:46