Difference between revisions of "SAM V2:import"

From CIDI Wiki
Jump to navigation Jump to search
Line 1: Line 1:
=='''Banner Data'''==
=='''Banner Data'''==


In order to import data into SAMV2 a Banner data extract/script will have to be created.  There are two SAM tables that need to be submitted to the Banner IT professional '''student and class schedules'''.  The Banner data extract format can be either a CSV file or a tab-delimited text file.  Ideally the IT professional should be able to run the Banner extract on demand and save the data to a local file.  This local file would then be loaded/updated by the IT professional using SQL/MySQL into SAM.
In order to import data into SAMV2 a Banner data extract/script will have to be created.  There are two SAM tables that need to be submitted to the Banner IT professional '''student and class schedules'''.  The Banner data extract format can be either a [[Wikipedia:Comma-separated_values|CSV]]  file or a tab-delimited text file.  Ideally the IT professional should be able to run the Banner extract on demand and save the data to a local file.  This local file would then be loaded/updated by the IT professional using SQL/MySQL into SAM.
'''THE IT PROFESSIONAL SHOULD SUBMIT A COPY OF THE '''[[Student]]''' AND '''[[Class Schedules]]''' DATA TO THEIR BANNER IT REPRESENTATIVE.'''   
'''THE IT PROFESSIONAL SHOULD SUBMIT A COPY OF THE '''[[Student]]''' AND '''[[Class Schedules]]''' DATA TO THEIR BANNER IT REPRESENTATIVE.'''   



Revision as of 15:16, 29 June 2009

In order to import data into SAMV2 a Banner data extract/script will have to be created. There are two SAM tables that need to be submitted to the Banner IT professional student and class schedules. The Banner data extract format can be either a CSV file or a tab-delimited text file. Ideally the IT professional should be able to run the Banner extract on demand and save the data to a local file. This local file would then be loaded/updated by the IT professional using SQL/MySQL into SAM. THE IT PROFESSIONAL SHOULD SUBMIT A COPY OF THE Student AND Class Schedules DATA TO THEIR BANNER IT REPRESENTATIVE.

The Banner Student extract should contain a single row for each student. The student extract would not contain a row for every student in Banner, so a mechanism must be in place within Banner to identify or flag disability services students, as only those students should be included in the extract.

The Banner class schedule extract should contain a single row for each class of a student. For example, if a student is taking three classes, there would be three rows of data, one for each class with the same student identifier. The class schedule extract would not contain a row for every student class in Banner, so a mechanism must be in place within Banner to identify or flag disability services students, as only the class schedules of those students should be included in the extract.