Sisra Analytics: How do I resolve file health check issues when importing student data? (Admin)

Overview

This article explains the main file health check issues when importing Student data files into Sisra Analytics, and how to check/resolve these.

You must be an administrator.

When issues are identified, select Show/Hide Warnings to see the students/qualifications affected.

Select an error message below to understand the reason for the error and the actions you can take to resolve it:

Reason	This is usually caused by the file having blank information in the Subject and/or Class columns.
Actions	Check that the Subject and Class columns in the file are fully populated. The import will not work if these are blank for every student. Save the file and import it. Make sure that the columns are mapped correctly whilst on the Column Mapping page during the import.

Reason	Filter conflicts occur when a student has more than one value for a filter in a student data file. For example, if a student has a Y and N for Looked After in different rows, this would be seen as a conflict (they can only be one or the other).
Actions	Select Show/Hide Errors to see the students affected. After identifying the students, select Cancel the import Edit your file to ensure that the student(s) have a consistent filter value for each row in your file. Save the file and import it. Ensure the columns are mapped correctly (particularly Subject and Class) in the Column Mapping page during the import.

Reason	This occurs when a large number of characters are included in any of the columns in your file.
Actions	Double-check the values present in these columns. Edit where necessary. Save the file and import it.

Reason	This occurs where commas are included in the file (usually between a student's first name and surname), and the file has been saved as a Comma-Separated Values (CSV) file.
Actions	Reopen your file in Excel. Use Find & Replace to replace the commas with either a blank, or a semicolon. Save the file and import it.

Reason 1	This occurs if you have rows in the file with no Student Name or Student ID in the file.
Actions	Opening the file in Excel. Filter the Student ID or Student Name column to check if there are any blank rows for students. Delete the blank rows if they don't contain valid data, or enter the correct Student ID or Student Name for these students. Save the file and import it.
Reason 2	If you can't see any rows where there are missing Student IDs or Names there may be hidden/blank data in the rows below the last row of the file that are being treated as rows of grades.
Actions	Open the file in Excel. Select all the rows below your last row of data. Select the Home tab. Select Delete Sheet Rows: Save the file and import it.

Reason 1	This occurs if you have Column Headers in this file that are duplicates.
Actions	Opening the file in Excel. Check the column headers to see if there are duplicates. Check for hidden column headers that are duplicates. To resolve this, you would need to edit the names of these columns so they no longer match.
Reason 2	If you can't see any duplicate column headers, this may be caused by hidden/blank data in the columns after the last column in this file that are being treated as column headers.
Actions	Open the file in Excel. Select all the columns after your last column of data. Select the Home tab. Select Delete Sheet Columns: Save the file and import it.

Reason 1	This occurs where commas are included in the file (usually between a student's first name and surname), and the file has been saved as a Comma-Separated Values (CSV) file.
Actions	Reopen your file in Excel. Use Find & Replace to replace the commas with either a blank, or a semicolon. Save the file and import it.
Reason 2	If you can't see any commas in this file, this may be caused by hidden/blank data in the columns after the last column in this file that are being treated as column headers.
Actions	Open the file in Excel. Select all the columns after your last column of data. Select the Home tab. Select Delete Sheet Columns: Save the file and import it.

The student data file should now import correctly without any error messages.

Updated 23 June 2025 09:36