This error indicates that a student in your spreadsheet is missing a first name.

All students require both a first and last name on Sumdog. This is to help teachers easily identify students. Example: A student with the last name Smith, in the class Miss Smith Math Class, is missing a first name.

You will need to go back and include a first name for the student in your spreadsheet that is listed next to the named error.

Students’ first names and last names should be listed in separate columns in the spreadsheet.

Once you have added the first name for the student, you can then re-upload the spreadsheet.

This error indicates that a student in your spreadsheet is missing a last name.

All students require both a first and last name on Sumdog. This is so teachers are able to easily identify students. Example: A student with the first name Sara, in the class Miss Jones’ Math Class, is missing a last name.

You will need to go back and include a last name for the student in your spreadsheet that is listed next to the named error. Students’ first names and last names should be listed in separate columns in the spreadsheet.

Once you have added the first name for the student, you can then re-upload the spreadsheet.

This error indicates that a student in your spreadsheet has not been assigned a class.

All students will need to be assigned to a class on Sumdog. Example: The student Sara Smith is missing a class. You will need to go back and assign a class to Sara in the spreadsheet which is listed next to the named error.

If you are unsure which class the student should be assigned to at your school, you can create a temporary class name and list that in your spreadsheet.

Once you have ascertained which class a student should be assigned to, you can then move their account to that class.

Once you have assigned a class to the student you should then re-upload the spreadsheet. Do make sure that a student is only assigned to one class on your spreadsheet as students can only be in one class on Sumdog.

This error message means that the format in your spreadsheet for the grade or year level column is incorrect.

Within the spreadsheet your first row should not include any headings, and only the relevant data. If you have included headings in your spreadsheet, please remove them so that the first row onwards only contains relevant student data. You can assign the meaning of that data using the drop-down menus during the upload process.

Ensure that the grade/year column is not formatted to text or similar format. It should be set to a number format in the spreadsheet.

We recommend that you list the grade or year level in the spreadsheet as 1, 2, 3, etc.

In this error message you will see there are two different students in the spreadsheet who have been assigned the same username.

You will need to locate the names in question in the spreadsheet and change the username for one of the students.

In this error message, it appears that the same student is appearing twice in the spreadsheet. You will need to remove one of the names in the spreadsheet and re-upload the spreadsheet.

If the two names in the spreadsheet represent separate students, you will need to change the username for one of the students and then re-upload the spreadsheet.

There are a few cases where this error message could appear. Below you will find three common examples and their solutions.

Example 1: In this first example, you can see an error message advising that there is another student in the school account named Bob Jet, assigned to Class 4, with the username included for Sara Smith.

You will need to change either Sara Smith’s username in the spreadsheet, or the other student’s username on the system. Do advise the student if you change their username as it will impact their ability to log into Sumdog.

Example 2: In this second example, an error advises that there is another student also called Sara Smith with the same username. Chances are that these two students are the same, however, the student listed in the error message is currently in the ‘Students No Longer in My School’ folder. This means that their account was removed from the school.

If the student Sara Smith in the ‘Students no longer in my school’ folder is the same person as the one you are trying to upload, drag and drop the student’s account from the ‘Students no longer in my school’ folder into any class. This is because students in the ‘Students no longer in my school’ folder are considered no longer in the school, and will not be picked up by any uploads.

If however the student in the ‘Students no longer in my school’ folder is not the same student, you will need to change the username for either the student in your spreadsheet, or the student in the ‘Students no longer in my school’ folder. The reason for this is that although the student in the ‘Students no longer in my school’ folder is considered no longer part of the school, their usernames can’t be reused to avoid problems if it is decided to add them back to the school account at a later point.

Example 3: In this third example, an error shows that two students each have assigned usernames that are already in use in the school. The error message also looks to indicate that these students might be the same.

Upon closer look you can see that it appears Alice Smith was listed in the spreadsheet with an incorrectly assigned name of Alice Sith. The student Sara Smith was originally included with the middle name Marie, but is now only listed as Sara Smith.
In both these cases, the system is attempting to create new accounts for two students since their names do not exactly match those already stored in the system. Matching the accounts will require both the names in the spreadsheet and system to be the same. If there is a difference in spelling, or additional names, the system will assume these are two different people.

You will need to either change the names in the spreadsheet to match the names stored in the system, or edit the names in the system to match the spreadsheet.

This error means that the password you have listed in the spreadsheet is only one character in length. For account security, all passwords will need to be at least two characters long.

We normally recommend a password of three to ten characters so that it is both secure, and easy to remember for the student.

This error message means that the student’s password is too long. You will need to shorten the password to less than 20 characters, and then re-upload the spreadsheet.

This limit is to ensure that passwords aren’t too complicated for students to remember, and also helps avoid errors when keying in a long password. We recommend passwords of between three and ten characters.

This error means that the username you have listed in the spreadsheet is only one character in length. For account security, all usernames will need to be at least two characters long.

We normally recommend a username of three to ten characters, so that it is both secure and easy to remember for the student.

This error message means that the username for your student is too long. You will need to shorten the username to less than 40 characters, and then re-upload the spreadsheet.

This limit ensures that usernames aren’t too hard for students to remember, and helps avoid errors when the student is keying in their username. We normally recommend between three and ten characters for usernames.

This error message means that the first name for your student is too long. You will need to shorten the first name to less than 40 characters, and then re-upload the spreadsheet.

This error message means that the last name for your student is too long. You will need to shorten the last name to less than 40 characters, and then re-upload the spreadsheet.