1 / 46

Pennsylvania Banner Users Group 2008 Fall Conference

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

sol
Download Presentation

Pennsylvania Banner Users Group 2008 Fall Conference

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Pennsylvania Banner Users Group 2008 Fall Conference Messiah College & Imaging The saga continues . . .

  2. 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

  3. Introduction • Our History • General overview with a few tech tidbits thrown in • Tips, tricks and a few “bloopers” • Questions

  4. 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

  5. How did it happen? • Go – Live • SQL + Oracle = “Oh my” • Consultant?? • Training – In about an hour • (scanning, indexing, retrieval)

  6. What does it look like? • 2 data sources • 38 applications • 35 in Oracle • 18 Baseline Applications

  7. 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

  8. 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

  9. What does it look like? SQL DB Banner Oracle DB Application Generator Disk Xtender XSAdmin License Server SCSI WebX Reports Manager User Workstation (AX, SX, App Gen)

  10. XSAdmin – The Motor

  11. XSAdmin – The Motor • 2 data sources • 38 applications • 35 in Oracle • 18 Baseline Applications

  12. XSAdmin – The Motor

  13. XSAdmin – The Motor

  14. XSAdmin – The Motor

  15. XSAdmin - The Motor

  16. 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

  17. Database – The Fuel AE_CFG – System configuration AE_LOGIN – Usernames & passwords AE_PERMS – User permissions H#_# - Document level security

  18. Extended Drive – The Battery

  19. Extended Drive – The Battery

  20. License Server – The Wiring

  21. Disk Xtender – The Doors

  22. Scan Xtender – The Windows

  23. Application Generator – The Mechanic

  24. Application Generator – The Mechanic

  25. Application Generator – The Mechanic

  26. Application Generator – The Mechanic

  27. Application Generator – The Mechanic

  28. ErmX (Reports Manager) - Auto Pilot

  29. Show me Banner – The Exterior

  30. 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

  31. 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:DC8B09C43D11F543495D3F34463A60A580E866756DA24C731A5663978E78484B43BE6EC8372A826DC8BDAF6B9EA2BA1E095D75E2A7B57692EF49BEE971AEE03E6154EB7D9038A5E79A273811CAADF31980B2B5D326573B74Info Item 3

  32. 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:DC8B09C43D11F543495D3F34463A60A580E866756DA24C731A5663978E78484B43BE6EC8372A826DC8BDAF6B9EA2BA1E095D75E2A7B57692EF49BEE971AEE03E6154EB7D9038A5E79A273811CAADF31980B2B5D326573B74Info Item 3

  33. 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:DC8B09C43D11F543495D3F34463A60A580E866756DA24C731A5663978E78484B43BE6EC8372A826DC8BDAF6B9EA2BA1E095D75E2A7B57692EF49BEE971AEE03E6154EB7D9038A5E79A273811CAADF31980B2B5D326573B74Info Item 3

  34. 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:DC8B09C43D11F543495D3F34463A60A580E866756DA24C731A5663978E78484B43BE6EC8372A826DC8BDAF6B9EA2BA1E095D75E2A7B57692EF49BEE971AEE03E6154EB7D9038A5E79A273811CAADF31980B2B5D326573B74Info Item 3 SavedQuery=B-G-ID, B-H-APPL, B-H-EMPL & B-H-ID

  35. 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:DC8B09C43D11F543495D3F34463A60A580E866756DA24C731A5663978E78484B43BE6EC8372A826DC8BDAF6B9EA2BA1E095D75E2A7B57692EF49BEE971AEE03E6154EB7D9038A5E79A273811CAADF31980B2B5D326573B74Info Item 3

  36. 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:DC8B09C43D11F543495D3F34463A60A580E866756DA24C731A5663978E78484B43BE6EC8372A826DC8BDAF6B9EA2BA1E095D75E2A7B57692EF49BEE971AEE03E6154EB7D9038A5E79A273811CAADF31980B2B5D326573B74Info Item 3

  37. Show me Banner

  38. Tips, Tricks, and “Bloopers” • Tip – When in doubt iisreset

  39. 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

  40. Tricks • It works

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

  42. Bloopers • Software Requirements • Windows, Adobe, Java • Hardware Requirements • Test Environment

  43. Open to the Floor • Questions • Comments Dorie Minich dminich@messiah.edu

More Related