Importing XML Transcripts into Banner CISOA 3 CBG
Importing XML Transcripts into Banner CISOA / 3 CBG Conference • 2014
Overview. . .
Overview: Importing and Loading ASSIST Data into Banner ------------Two Technologies: 1. Banner Setup and Processes 2. XML – XSL Translation Data Source: e. Transcript. CA California Transcript Exchange
Loading ASSIST DATA
Loading ASSIST Catalog Data into Banner* Files : * Not articulation data • • • UC Transferable to Community Colleges CSU Transferable to Community Colleges IGETC Applicable Community Colleges CSU-GE Breadth Certification CSU and UC (UC all)
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
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
SHTATC Transfer Institution Catalog The result: Course catalog data from ASSIST is loaded into Banner
Close-up Look at the Data For a given incoming institution: 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
Stats on ASSIST Dataload: ASSIST Catalog Records Loaded: 388, 897 Colleges loaded: 107 ASSIST Attribute Code Records Loaded: 610, 801
Receiving Electronic Transcripts What it took for us to load incoming electronic transcripts into Banner
Load data into Banner using baseline program: SHRPESI Sweeps target directory for XML transcripts and loads data into series of Banner tables.
Loading data into Banner SHAEDIS
Courses Ready for Articulation SHATAEQ
Cross Reference Rules SOAXREF Cross-reference data from incoming transcripts into Banner data
STVTRMT - SOAXREF Semester/ Quarter Crosswalk between electronic value on incoming transcript and Banner value
College Setup STVSBGI SOAXREF
SHADRTM Crosswalk – Incoming begin end term dates with Banner term code Use default Institution if possible
Downloading XML Transcripts Using e. Transcript. CA Control Center
Student originated or requested by receiving institution Transcript Requests
XML Transcript Example Incoming Institution Data • Organization Name • Contact info • Destination Name • FICE
XML Coursework Sample Course Data • Session • Translates to term code • Course level • Term type • Semester • Quarter • FICE • Translates in SOAXREF
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.
XSLT in Action Incoming etranscript. CA XML XSLT template XML Ready for Banner
- Slides: 25