The purpose of the CCMR Assessment File Data Loader web application is to allow data stewards at the district level to upload ACT, AP, IB, SAT and TSI assessment data into their district's CCMR Insights dashboard using a simple, intuitive interface which provides loading and error statistics for the end user.
...
Information and assistance with the CCMR Assessment File Data Loader can be found here.
...
1.) Be sure to read the Important Notice section.
2.) A link to this user guide is found in the Help sections along with a link to open a support ticket.
...
2.) The next section (see below) contains any records in the file(s) that were uploaded where no student id could be found in the ODS. All student assessment records are matched with an associated student record in the ODS by using the student’s first name, last name and date of birth. If a match fails for a student ,then a “student id mismatch” occurs and the student's first name, last name and date of birth, along with the associated assessment file that contains the student’s assessment data, will appear in this section. The Clear button on the upper-right can be used to clear/reset the records in this section. There is also an action (see Actions button) to download the contents of this section to a .csv file on your local system. Also, you can search for a student by name or search for a filename using the search feature (see Student or File Name button).
...
Detailed Overview of the File Format Errors page
With the exception of the ACT assessment file - which does not have a header record - the header row (first row) of the assessment file is verified against the standard file format for that assessment type. If the header is not valid, then the following message will appear:
...
Going to the File Format Errors page will reveal which file failed, which header fields (columns) are erroneous and what the standard file format should be regarding those (erroneous) fields. Erroneous header fields could be in the wrong order and/or be misspelled.
...
Detailed Overview of the Import Status page
After the assessment data has been successfully uploaded, and after a 5 minute delay, the status of the assessment data import can be verified by viewing this page.
The top section will provide the import status by filename. The status will contain:
i.) a count of rows processed
ii.) a count of rows inserted (Success)
iii.) a count of rows updated (Exists)
A totally successful import will appear in green while import with errors will appear in red.
A Refresh button exists (top-right) so that the page can be manually updated to show the latest status.
...
Clicking on the filename reveals a second section which provides a more detailed status of import rows. The example below shows details on a successful import.
...
The second section can be useful when trying to determine why certain rows had errors. The example below shows details on a failed import and the cause of the failure.
...