1 / 25

Importing XML Transcripts into Banner

Importing XML Transcripts into Banner. CISOA / 3CBG Conference • 2014 . Overview . . . Overview:. Importing and Loading ASSIST Data into Banner. -------------------------. Two Technologies: Banner Setup and Processes XML – XSL Translation Data Source: eTranscriptCA

gaye
Download Presentation

Importing XML Transcripts into Banner

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. Importing XML Transcripts into Banner CISOA / 3CBG Conference • 2014

  2. Overview . . .

  3. Overview: Importing and Loading ASSIST Data into Banner ------------------------- Two Technologies: Banner Setup and Processes XML – XSL Translation Data Source: eTranscriptCA California Transcript Exchange

  4. Loading ASSIST DATA

  5. Loading ASSIST Catalog Data into Banner* Files : • UC Transferable to Community Colleges • CSU Transferable to Community Colleges • IGETC Applicable Community Colleges • CSU-GE Breadth Certification • CSU and UC (UC all) * Not articulation data

  6. Oracle Database Functionality Processes: Create local table:SZRARTC Load tables using SQLLOADER Scripts to modify each file Load attributes - use SQLLOADER 20+ SQL scripts run to load data

  7. Problems With ASSIST Data Gotcha’s Many, many duplicate rows Gaps in data attributes deactivated for one or more terms Translate incoming term codes No Begin-End term codes Only begin term codes Tables loaded: SHBTATC, SHRTCAT

  8. SHTATC Transfer Institution Catalog The result: Course catalog data from ASSIST is loaded into Banner

  9. Close-up Look at the Data Term: 20005 Level: 01 Subject: ACCTG Course: 20 Status: active Title: Financial Accounting Equivalent Exists: Low: 4.00 High: 4.00 Course Attributes: UC CSU IGETC CSU-GE CSU and UC For a given incoming institution:

  10. Stats on ASSIST Dataload: ASSIST Attribute Code Records Loaded: 610,801 ASSIST Catalog Records Loaded: 388,897 Colleges loaded: 107

  11. Receiving Electronic Transcripts What it took for us to load incoming electronic transcripts into Banner

  12. Load data into Banner using baseline program: SHRPESI Sweeps target directory for XML transcripts and loads data into series of Banner tables.

  13. Loading data into Banner SHAEDIS

  14. Courses Ready for Articulation SHATAEQ

  15. Cross Reference Rules SOAXREF Cross-reference data from incoming transcripts into Banner data

  16. STVTRMT - SOAXREF Semester/ Quarter Crosswalk between electronic value on incoming transcript and Banner value

  17. STVSBGI College Setup SOAXREF

  18. SHADRTM Crosswalk – Incoming begin end term dates with Banner term code Use default Institution if possible

  19. Downloading XML Transcripts Using eTranscriptCA Control Center

  20. Student originatedor requested by receiving institution Transcript Requests

  21. Incoming Institution Data • Organization Name • Contact info • Destination Name • FICE XML Transcript Example

  22. Course Data • Session • Translates to term code • Course level • Term type • Semester • Quarter • FICE • Translates in SOAXREF XML Coursework Sample

  23. Out-of-the-box SHRPESI didn’t work XSLT - Modify the incoming data XSLT is a language to transform incoming XML document into an XHTML document or another XML document.

  24. Incoming etranscriptCA XML XSLT template XSLT in Action XML Ready for Banner

More Related