The 2015-16 through 2017-18 CAASPP Student Results can only be imported from the Import Test Results page in the Aeries Web Version. It will not be able to be imported from Aeries Client Version.


Select the appropriate file layout to import the CAASPP Student Results. In the below example the CAASPP Test Results - SY:2017-18 file layout was selected in order to import the 2017-18 CAASPP score data.



Districts can download both a text (.dat) file and a caret-delimited (.csv) file from the testing vendor. The Import Test Results page has been programmed to import only the caret-delimited (.csv) file. If the text (.dat) file is selected to load, a message will appear explaining that files with a .dat extension are not supported.



If this message displays, click OK, click on the Select File(s) to Load button, select the file with the .csv extension, and click on Open. Then continue to load and match the records.



The Default Date for the CAASPP Test Results is the oldest date in the data file. The Testing Administration for the Test Results is SPRGXX where XX is the end of the school year for the data being imported (ex. 2017-18 test results would have a SPRG18 Testing Administration).



The Student State ID is the primary identification in the CAASPP Student Results data files. It should be the first method used for matching students.



The CAASPP Student Results import will add/update records to the Test Scores (TST), Content Standards Scores (CST), Testing Exclusions (TEX), and Authorizations (AUT) tables. After the import process has completed an email with summary information will be sent to the user that initiated the import.