Historical SIS Files
This is the third step of the onboarding wizard. Here you upload your Student Information System (SIS) exports for the previous school year. This historical data is what lets TKG Analytics build your prior-year impacts and accountability picture.
Files to upload
Upload the following five files, each as a .csv:
| Upload | File name |
|---|---|
| Schools | schools.csv |
| Students | students.csv |
| Teachers | teachers.csv |
| Enrollments | enrollments.csv |
| Schedules | schedules.csv |
All five are for the previous school year. When every file is uploaded, click Next to continue.
These names are required
Each file has to be named exactly as shown above, in .csv format, and uploaded into its own slot. A file with any other name is refused as you upload it, including a name that differs only in capitalization or carries a suffix your export added, such as students (1).csv. Nothing is stored, and the message names both what the slot takes and what you chose, so rename the file and upload it again. This is the same rule as the SIS Data Format page states for every SIS file.
Finish District Information first
You can only upload files once the District Information step is complete. If the upload area is not available, return to that step and save it first.
File format and columns
Every SIS file has a required set of columns. See the SIS Data Format page for the exact column list for each file, including teachers.csv.
Each file is checked as you upload it, and a file that is not the one the slot asks for, or that would import nothing, is refused. When a file is refused it is not stored, so the slot keeps showing that no file has been uploaded and you can correct the file and upload it again. A file is refused when it is not named as the slot's file name above, when a required column is missing, when the file has no header row, when it has a header row but no data rows, or when it is empty or unreadable.
The Current SIS Files step applies the same checks, with one difference: it also requires an email column on teachers.csv, because the current-year file creates your teachers' logins. The prior-year file here builds Teacher records only, so it does not need one.
Getting these files from your SIS
We provide the SIS queries and step-by-step export instructions for the common Mississippi SIS platforms. To get the queries for your SIS, open a Helpdesk Ticket and we will send them to you.
Not sure something is right?
If anything on this step does not look right, open a Helpdesk Ticket and we will help before you continue.
Where you are
Previous step: District Admins. Next step: Current SIS Files.