CSV Imports

PLEASE READ BEFORE PROCEEDING

If you are currently in implementation for Student Learning & Licensure, please ensure you are referencing the Data Files materials that were provided to you by your Project Manager.

CSV Imports

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

To use Student Learning & Licensure (SL&L) and its reports to the fullest, your institution will need to regularly provide data from your student information system. This data is provided via several CSV files that establish foundational data like users, courses, course sections, and enrollment. The articles below explain exactly what data is needed from your student information system. Examples of each CSV file type are also attached to this article.

• User Imports
• Hierarchy Imports
• Course Imports
• Section Imports
• Membership Imports
• Academic Data Imports
• Term Imports

How to manually import CSV files in Student Learning & Licensure (SL&L)

1. Log into a SL&L administrator account.
2. Click on the Menu button in the upper right corner of your account.
3. Click Admin.
4. Click Import at the top of the page.
5. On the left side of the page, select the import you would like to run (Import Hierarchy, Import Users, etc.).
6. 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.
7. The file will begin uploading. Click check status.
8. The Import Status will now display the number of rows that were imported successfully and the number of rows that failed.
9. 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

[cite_start]For most imports (excluding the Hierarchy import), a spreadsheet that has been previously committed can be re-imported with changes, and those changes will be updated in the system[cite: 1]. However, there are two important things to keep in mind:

1. The “ID” fields of the imports define the unique object in SL&L, so once the ID is created, the ID value cannot be changed.
2. Fields that have previously imported values will be deleted if a re-import happens with those fields left blank. [cite_start]When a field is left blank, SL&L will update the field with a “blank”. 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. [cite_start]The column can be left off the spreadsheet, and SL&L will neither add or change existing values for that field[cite: 1].