Troubleshooting Grade Import Issues

Article Last Updated June 2021

If you run into issues while attempting to upload csv files into the eClass gradebook, try the following troubleshooting steps:

Error message: 'user mapping error, could not find user...'

  • These errors are usually caused by mis-mapping the columns from your spreadsheet to the corresponding gradebook column in eClass. For assistance with these problems, see the instructions in the knowledgebase article: Importing Grades into The Grader Report (or the link immediately to the right of 'Identify user by' inside the eClass gradebook when importing grades).
  • If you have verified that your mapping is correct and still see this error, another cause of mapping issues is if a Student ID number or CCID has become corrupted in your spreadsheet. In these cases, check for the user id identified in the error message. These can sometimes be inadvertently converted by auto-formatting in MS Excel:
    • If you have a user whose Student ID number begins with zero, Excel will trim the leading zero.
    • If you have a student with a CCID approximating a date, eg. may4, Excel will convert it into a date.

Error message: 'Error writing to database'

  • This error message occurs when the grader report is expecting to receive numeric values and instead receives textual data.
  • The most common cause is text written directly into your spreadsheet in place of numbers as in the example depicted below:

  • This error will also occur if you are attempting to upload textual data such as feedback or comments directly into a gradebook column. Text columns must be imported into the 'Comments' area of a pre-existing gradebook column following the instructions in this article: Importing Text Columns to the Gradebook.
  • This error will also be thrown on rare occasions by user mapping problems. See the tips above for solving those issues.
(9 vote(s))
Not helpful