Sisra Analytics: How do I resolve file health check issues when uploading grades? (Admin)

Overview

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

Prerequisites

You must be an administrator.

Instructions

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:

  • Error Message: X Student(s) do not have any student data or the Student IDs are not recognised

    Reason

    This occurs when one or more students in your file do not currently exist in your student data for this cohort, and therefore, are not recognised.
    Actions
    • If the student should be included, select Continue with the upload to proceed and import a new student data file including this student, or add the student and their classes manually to Sisra Analytics.
    • If the student should not be included, either continue with your upload and manually delete the grade(s) within Sisra Analytics, or cancel the upload, remove their grade(s) from your file, and re-upload your file.

  • Error Message: X Student(s) have conflicting grades for a qualification

    Reason

    This occurs when a student has more than one grade for the same qualification in the grades file, for example, a student with entries for both a grade 8 and grade 7 for Art.
    Actions

    Check whether the student(s) should have duplicate conflicting grades, for example, two exam grades in the same qualification due to a resit.

    • If the student should have duplicated grades, select Continue with the upload, and the best/first grade would be used within the reports, depending on whether you’re working with KS5 or KS3/4.
    • If the student shouldn't have conflicting grades, remove these from your Excel file and re-upload.

  • Error Message: File to be imported contained commas. Please upload a file with no commas.

    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.

  • Error Message: One or more rows do not contain the Student ID and/or Name. Please ensure every row has this data.

    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.

  • Error Message: The file's column headers contained duplicates, which is not valid for this upload type. Please upload a suitable file.

    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.

  • Error Message: Some rows in the file had more columns than others. Please ensure that the file contains no commas and is correctly formatted.

    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.

Outcome

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

Related information

 

Updated

Was this article helpful?

0 out of 0 found this helpful

Have more questions? Submit a request