Troubleshoot Errors in the Import Log

EMS

You can access the import error log via one of two ways.

• Using a District Safety Team account.
  1. Log into CatapultEMS.com 
  2. Choose District Settings > Import Data for District.
  3. Choose the latest log file.
• If you have SFTP access to the top-level folder for your district, look under the "/logs" folder. The folder includes a file per day for the last seven days.

CONNECT

You can access the import error log via one of two ways.

• Using an Organization Communication Team account.
  1. Log into Catapult-CONNECT.com 
  2. Choose Organization Settings > Import Data.
  3. Choose the latest log file.
• If you have SFTP access to the top-level folder for your district, look under the "/logs" folder. The folder includes a file per day for the last seven days.

See below for help on specific errors.

Contents

• 185: SchoolCode does not exist in database.
• 218: StudentExport.csv is missing. / StaffExport.csv is missing. / StaffToStudentExport.csv is missing.
• 219: StudentExport.csv/StaffExport.csv/StaffToStudentExport.csv is empty or does not contain enough rows of data.
• 433: Invalid Email provided for staff member.
• 599: Staff to student period import error, staff member or student unknown or not in database.

185: SchoolCode Does Not Exist in Database.

• If the school code should be included in CatapultEMS, reach out to support and indicate whether it needs to be merged with an existing site or added as a new site.
• If the school code isn't needed, exclude it on your end or ask CatapultEMS to exclude it on their end (to clean up the error log).

218: StudentExport.csv is Missing. / StaffExport.csv is Missing. / StaffToStudentExport.csv is Missing.

The file listed is missing.

• Check the files are loading to the correct folder.
• Check the spelling of the file name.
• If your contract does not include students, then you can ignore the StudentExport.csv error.

219: StudentExport.csv/StaffExport.csv/StaffToStudentExport.csv is Empty or Does Not Contain Enough Rows of Data.

• Check whether the file contains data (beyond headers).
• Check that the headers are spelled correctly.
• If classes are not in session, you can ignore the StaffToStudentExport.csv being empty.

433: Invalid Email Provided for Staff Member.

• "Invalid Email" can mean blank or no "@" sign. Email required for login.
• If your district uses Aeries, see "Email" under the Staff heading for details on where that pull from.

599: Staff to Student Period Import Error, Staff Member or Student Unknown or Not in Database.

• Check if the student mentioned in StaffToStudentExport.csv is in the StudentExport.csv
  • Check that you only included the current semester/term in your StaffToStudentExport.csv
  • Check that you excluded inactive students from your StaffToStudentExport.csv
• Check if the staff mentioned in StaffToStudentExport.csv is in the StaffExport.csv
  • Check that you exclude inactive staff from your StaffToStudentExport.csv
• Check if the same line appears twice in the StaffToStudentExport.csv. If so, remove the duplicates.
• Check the relevant column names are labeled correctly. 
  • StudentExport: the student id column should be labeled "id".
  • StaffExport: the staff id column should be labeled "id".
  • StaffToStudentExport: the staff id column should be labeled "teacher" and the student id column should be labeled "student".