Difference between revisions of "SAM V1:import"

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


In order to import data into SAM 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 [[http://en.wikipedia.org/wiki/Delimiter-separated_values|tab-delimited] text file.  Ideally the DSP should be able to run the Banner extract (created by the Banner IT professional) on demand and save the data to a local file.  This local file would then be [https://www.quickbase.com/help/default.html#importing_data.html imported] by the end-user into SAM.  
In order to import data into SAM 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 [[Wikipedia:Tab-Delimited|Tab-Delimited] text file.  Ideally the DSP should be able to run the Banner extract (created by the Banner IT professional) on demand and save the data to a local file.  This local file would then be [https://www.quickbase.com/help/default.html#importing_data.html imported] by the end-user into SAM.  


'''THE DSP SHOULD SUBMIT A COPY OF THE '''[[Student]]''' AND '''[[Class Schedules]]''' DATA TO THEIR BANNER IT REPRESENTATIVE.'''  From that point the Banner It representative can assemble a script containing all students receiving disability services.  Now the DSP has a list from Banner that contains all of the required fields for SAM.  The Banner IT representative should make the script into a process that the DSP can use weekly to update SAM.
'''THE DSP SHOULD SUBMIT A COPY OF THE '''[[Student]]''' AND '''[[Class Schedules]]''' DATA TO THEIR BANNER IT REPRESENTATIVE.'''  From that point the Banner It representative can assemble a script containing all students receiving disability services.  Now the DSP has a list from Banner that contains all of the required fields for SAM.  The Banner IT representative should make the script into a process that the DSP can use weekly to update SAM.

Revision as of 15:24, 29 June 2009

In order to import data into SAM 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 [[Wikipedia:Tab-Delimited|Tab-Delimited] text file. Ideally the DSP should be able to run the Banner extract (created by the Banner IT professional) on demand and save the data to a local file. This local file would then be imported by the end-user into SAM.

THE DSP SHOULD SUBMIT A COPY OF THE Student AND Class Schedules DATA TO THEIR BANNER IT REPRESENTATIVE. From that point the Banner It representative can assemble a script containing all students receiving disability services. Now the DSP has a list from Banner that contains all of the required fields for SAM. The Banner IT representative should make the script into a process that the DSP can use weekly to update SAM.

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.