CSV Imports are required to establish foundational data such as users, courses, course sections, and enrollment. These files must either be imported manually or an Application Programming Interface (API) can be established to facilitate automatic import.
CSV Import Guidelines
In order to use Student Learning & Licensure (SL&L) and its reports to the fullest, your institution will provide data from your student information system on a regular basis. Data from your student information system will be provided by means of several CSV files which will establish foundational data such as users, courses, course sections, and enrollment. The following articles explain exactly what data is needed from your student information system. Examples of each type of CSV file are also attached to this article.
How to manually import CSV files in Student Learning & Licensure (SL&L):
- Log into a SL&L administrator account
- Click Import at the top of the page
- On the left side of the page, select the import you would like to run (Import Hierarchy, Import Users, etc.)
- Click Upload File and select your .csv file (if you do not have a .csv file, please see the sample files attached to this article)
- The file will begin uploading. Click check status
- The Import Status will now display the number of rows that were imported successfully, and the number of rows that failed.
- If there are any failed rows, click Failed Information to view the errors for those rows. Correct the errors in your .csv file, then repeat step 4
A note about re-importing and changes
For most imports (excluding the Hierarchy import,) a spreadsheet that has previously been committed can be re-imported with changes, and those changes will be updated in the system. However, there are two important things to keep in mind:
- The “ID” fields of the imports define the unique object in SL&L. This means that once the ID is created, the ID value cannot be changed.
- Fields that have previously imported values will be deleted if a re-import happens with those fields left blank. In the same way that values can be updated, if a field is left blank, SL&L will update the field with a “blank.” This means that once a field value has been imported, it needs to be maintained through all re-imports, unless its value is being changed.
- Note: For optional fields, it is not necessary to include the field at all. The column can be left off the spreadsheet, and SL&L will neither add or change existing values for that field.