When you import your data into Enriching Students, you may come across a variety of errors in the import process. An error message will alert you as to what the problem is. Below, we've broken down each error, for each data file, as it will appear in the error message, and how to fix it.
Once you fix an error in the file, save it, and upload the data again.
Roster file
Roster file, row: 2 is missing student id
This tells you that in a particular row in the file, you're missing a student ID. Find the row #, and add the missing ID.
Roster file, row: 2 has student id that is missing from student file
This means that in a particular row, the student ID found does not match any student ID in
Roster file, row: 3 is missing course name
Go to the correct row #, and fill in the correct course name for the student in that row.
Roster file, row: 8 has staff id that is missing from staff file
This notifies you that in this row #, the staff member is missing their ID.
Roster file, row: 8 is missing Staff Id
In the given row number, this message notifies you that you're missing an ID for a staff member.
Staff File
Staff file, department required in row: 8
A department name is required to successfully import your staff file. If a department name is missing, this error message will tell you in which row. Go to that row, and add the correct department name.
Staff file, duplicate staff id: 300662
You cannot add the same staff member twice. If there is a duplicate staff ID, this message will tell you which staff member appears more than once. Find the duplicate staff ID, and change it to the correct one.
Staff file, email address duplicated: studentname@gmail.com
There must been a unique email address for each unique staff member. If an email address occurs more than once in the staff file, this warning message lets you know which email is duplicated, so you can find that email and edit/delete it.
Staff file, email required in row: 8
An email address is required for each staff member. If a staff member has not been given an email address in the file, this warning message tells you in which row the email address is missing. Go to that row, and add the missing email address for the staff member.
Staff file, first name required in row: 8
If you have missed adding a staff member's first name, this error message tells you in which row. Go to that row in the file and add the missing first name.
Staff file, last name required in row: 8
Each staff member must have a first and last name. This error message alerts you if a staff member is missing their last name. Go to the given row number, and add the missing name.
Staff file, homeroom required in row: 8
Each staff member must have an assigned homeroom number. This message lets you know that in a specific row #, you're missing a room number. Go to that row, and add the missing homeroom number.
Staff file, maximum number of students not valid in row: 9
There is a maximum number of students allowed
Staff file, staff id required in row: 8
This message alerts you if a staff member is missing their ID. Go to the row number, and add the missing staff ID.
Staff file, user type must be Admin or Teacher in row: 8
You must choose either an Admin or Teacher account type for a staff member. If you haven chosen either of these user types for a staff member, you will get this error message. Go to the row number, and type either Admin or Teacher.
Staff file, maximum number of students required in row: 8
In the staff file you will need to add the max number of students for each staff member. This error message will appear if a number has not been added in this row.
Student File
Student file, missing email address in row: 10
If you are missing a student's email address, this message tells you in which row. Go to that row, and add the student's email.
Student file, missing first name in row: 10
A student's first name is required to successfully upload the student file. Go to the row number given in the error message, and add that student's first name.
Student file, missing last name in row: 10
You need to add a last name for each student for a successful data import. Go to the row number, and add the student's missing last name.
Student file, missing graduation year in row: 10
It's required to give each student a graduation year. This error message tells you in which row you're missing a graduation year. In that row, add the missing graduation year.
Student file, missing staff id in row: 10
IN the student file, you will be adding the student's homeroom staffer. If one of those staff members is missing their ID, you will be notified in which row. Go to that row, and add the missing ID.
Student file, missing student id in row: 10
Each student must have a unique student ID in the file. If you're missing a student ID, the error message will give you the row number for that student. Go to the row number, and add the missing ID.
Student file, graduation year not valid in row: 9
A 'valid' graduation year needs to follow the format YYYY, not including a month or date. For example, 6/20/18 would be invalid. A valid graduation year would be 2018.
Student file, staff id not in staff file in row: 9
A staff member's ID needs to match the ID in the staff file. If it doesn't, you will get this error message. To fix it, go to the row number given, and make sure the ID for that staff member matches the one in the staff file. If it is a new staff member that has not been added to the staff file, make sure they are added to the staff file.
Student file, student id: 8 appears more than once
Each student should have a unique ID. A student ID cannot be used more than once. If there is a student ID that's in the file more than once, this error message will appear. It ill tell you which ID appears more than once. Find the ID, and make sure that it appears for only one student. Change any ID necessary.
Student file, email address: clocktowerhr@gmail.com appears more than once
Each student in the file must have a unique email address. You cannot have the same email address for more than one student. If an email address does appear more than once in the file, you will get this error message when you try to upload the file. It will tell you which email address it is, so you are able to find the problem in the file and fix the duplicate email address.
Comments
0 comments
Please sign in to leave a comment.