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. Aeries is aware of these changes and plans to add support for the new formats in our automated CASEMIS Import process by the end of October 2018.


Changes in 2015-16 CASEMIS File Layout

The CASEMIS file layout for the 2015-16 school year no longer contains 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 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 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.


Schedule CASEMIS Import

Regular imports of CASEMIS Student Data and Student Services Data can be scheduled into the Aeries database. The CASEMIS Students (tableA) file and Services (tableB) file must be the ASCII text (.csv) formatted file as defined in the CASEMIS Technical Assistance Guide. Once the scheduled imports are set up, districts will need to ensure that the CASEMIS Student Data and CASEMIS 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 CASEMIS 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 CASEMIS 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 CASEMIS Student Data and CASEMIS Student Services Data files are refreshed prior to the next scheduled import, otherwise the same data files will be re-imported.


After the CASEMIS 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 CASEMIS 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 CASEMIS Student Data and CASEMIS Student Services Data files.



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