NOTE: As part of the CASEMIS to CALPADS (aka C2C) transition, the CDE has updated the CASEMIS Table A and Table B formats for the 2018-2019 school year forward. Aeries is aware of these changes and has added support for the new formats in our automated CASEMIS Import process


Changes in 2015-16 CASEMIS File Layout

The CASEMIS file layouts for the 2015-16 through 2017-18 school years no longer contain the State Test Participation fields (fields A-57 through A-62) in the CASEMIS Student Data (Table A) file. These fields are now Filler fields. Since the CSE Special Ed Participation in State Wide Assessment fields are still necessary for varies Aeries reports (such as the CAASPP Student Test Assignment Extract) and may need to be hand-entered, we will process the CASEMIS import in the following manner:

  • If the CASEMIS (pre-2018)  Students (Table A) file has blanks or no value in the A-57 – A-62 filler fields, then the CSE Participation fields will not be changed (so hand-entered data will not be removed).
  • If the CASEMIS (pre-2018)  Students (Table A) file has non-blank values in the A-57 – A-62 filler fields, then the CSE Participation fields will be updated with the values in the CASEMIS file.
  • The 2018-19 and forward Student Sped (Table A) format also does not contain these State Test Participation field. Importing the Student Sped file will not update the CSE Participation fields.


Schedule CASEMIS Import

Regular imports of Special Education Student data and Student Services data can be scheduled into the Aeries database. The Student Sped (tableA) file and Student Services (tableB) file must be the ASCII text (.csv) formatted file as defined by the CDE. Once the scheduled imports are set up, districts will need to ensure that the Student data and Student Services data files are refreshed prior to the next scheduled import, otherwise the same data files will be re-imported  


Administrators can access the CASEMIS Import page in the School Info | Configurations | Imports and Exports node of the navigation tree. This page defines where the Special Education data files will be stored, the name of the files, and the scheduled day(s) and time for the import to run. There is also a button to import the Special Education files immediately. Once all selections have been made, click on the SAVE button.



NOTE: Once the scheduled imports are set up, districts will need to ensure that the Student data and Student Services data files are refreshed prior to the next scheduled import, otherwise the same data files will be re-imported.


After the import has completed an email will be sent to the email address defined in the CASEMIS Import page. The body of the email will report summary information such as the date and time the import completed, and the number of records matched, unmatched, duplicate records, and records with errors. The email will also contain completion report attachments for the Student data and Student Services data files.



For more detailed information on CASEMIS Scheduled Imports please refer to this series of articles:   CASEMIS Scheduled Imports.