Common errors that are encountered while uploading assessments are listed below, together with potential solutions. This troubleshooting table will be expanded over time.
...
Issue | Potential solution |
|---|
Error related to file name (e.g., invalid assessment type or invalid district id). | View file formatting page for file naming conventions. |
Zero matching student records found in ODS for file. | Make sure that the students who are listed in the assessment file are students who are currently active so they will match the students in your student information system. |
File header format error | View the text and CSV files on the file formatting page for the required format for each assessment type. |
Student mismatch errors | |
Receive an error message indicating “cannot insert NULL” | Because an assessment score is matched with a student by using the student’s first name, last name, and date of birth, these fields MUST be populated accurately in the assessment file. Either For rows with missing data, either add in the missing information or delete the rows, rename the file (e.g., file_name_v2), and reload it. If this solution doesn’t work, please submit a help desk ticket.
|
File does not show up on import status screen | If you need to update a file and reload it, you must change the name of the file (e.g., file_name_v2) because the system will not allow you to upload the same file twice. Files will also not show up if zero students matched. If renaming the file doesn’t work, please submit a help desk ticket.
|
Red error message on import status screen | For ACT files only: Try to change the date format in the “test date” column to a date category with format type “Mar-12” and then reload the file. If this doesn’t work, please submit a help desk ticket.
|
Red error message on import status screen | For AP files only: Try to change the date format in the “date of birth” column to “text” and then reload the file. If this doesn’t work, please submit a help desk ticket.
|