Importing Students
IMPORTANT!
If you are using one of the integration platforms such as Clever, ClassLink, or Google Classroom, do not use the Data Import page to import your information. Please go to the Help section and find the appropriate instructions for your rostering needs.
If you are a District Administrator, ensure you have selected the correct school from the drop-down menu at the top of the page before importing a file.
On the Data Import page, under Import student users, select Download Student Import Template.
The template will open in Excel. Starting with row 5 in the template, complete a row for each student, then save the file.
IMPORTANT!
Do NOT modify the first 5 rows of the template.
Field | Column | Required | Description |
First Name | A | Yes | Enter the student’s first name. |
Middle Name | B | Yes | Enter the student’s middle name. |
Last Name | C | Yes | Enter the student’s last name. |
Grade Level | D | Yes | Enter the student’s grade level. |
Student ID | E | Yes | Enter the student’s unique Student ID. |
Desired Username | F | Yes | Enter a unique username for the student. |
Password | G | Yes | Enter a valid password for the student, following the password requirements:
|
Class Code 1 | H | No | Enter the class code for the student. You may import students without class codes, and teachers will set up classes and add students from the master list. If you do use class codes, they must match the classes you previously imported. |
Class Code 2 | I | No | Additional class code if applicable. |
Class Code 3 | J | No | Additional class code if applicable. |
Email Address | K | No | Required for Google Classroom Users. |
Gender | L | No | Valid values –
|
Date of Birth | M | No | Student's date of birth in mm/dd/yyyy format. |
Ethnicity | N | No | Valid values –
|
Disadvantaged Status | O | No | Valid values –
|
Title 1 | P | No | Valid values –
|
Title 1 Details | Q | No | Valid values –
|
Migrant | R | No | Valid formats –
|
LEP | S | No | Valid values –
|
Bilingual | T | No | Valid values –
|
ESL | U | No | Valid values –
|
Gifted-talented | V | No | Valid values –
|
Special Education | W | No | Valid values –
|
At Risk Status | X | No | Valid values –
|
At Risk Type | Y | No | Valid values –
|
After saving your file, select Upload Students, locate the file and select it to import.
To confirm import, scroll to the bottom of the page and check Import History for the Status of import.
If the file import was successful, you would see Import Success in the Status column.
If the import was not successful, you would see Import Fail in the Status column. This means that none of the students in the file were imported. Select the Import Fail link to view the errors.
After you have reviewed the errors, open the template file, correct the issues indicated, and upload the file again. Refer to the Troubleshooting Import Errors below for additional guidance.
Troubleshooting Data Import Errors
The entire import will fail if any field in your file is incorrect. Partial imports are not allowed.
If you receive the message that your Student Import failed, you must fix the errors in the file then try to reimport it. Here is a list of common errors and explanations.
If you receive the message that your Student Import failed, you must fix the errors in the file then try to reimport it. Here is a list of errors with explanations.
Error Message | Explanation |
First name missing | Enter the student’s first name. |
Last name missing | Enter the student’s last name. |
Username missing | Enter a username for the student. |
Password missing | Enter a password for the student. |
Grade missing | Enter the student’s grade level. |
Duplicate Student ID | The student ID already exists within the district’s account. Remove the student row from the file. See further instructions for this error following the table. |
Student Number is missing | Enter the student’s ID number. |
Invalid Grade | Enter the student’s grade level. |
Password too short | Password must –
|
Password too long | See row above. |
Invalid Email Address | Ensure the student’s email address is valid. |
Duplicate Email Id | The email address already exists within the district’s account. Remove the email address from the row. |
Invalid Gender | Valid values – F, M, or N. |
Invalid Date of Birth | Valid format: MM/DD/YYYY |
Invalid Ethnicity | Valid values –
|
Invalid Disadvantaged Status | Valid values –
|
Invalid Title 1 | Valid values –
|
Invalid Title 1 Details | Valid values –
|
Invalid Migrant | Valid values –
|
Invalid LEP | Valid values –
|
Invalid Bilingual | Valid values –
|
Invalid ESL | Valid values –
|
Invalid Gifted-talented | Valid values –
|
Invalid Special Education | Valid values –
|
Invalid At Risk Status | Valid values –
|
Invalid Risk Type | Valid values –
|
Duplicate Student Id present in the file | The same student ID exists in more than one row of the file. Student ID numbers must be unique per student. Locate and correct duplicated student IDs |
Username should be at least 5 characters long | Ensure the username has at least five characters. |
Class Code 1 does not exist | Ensure the entered class code exists in the school’s account. |
Class Code 2 does not exist | Ensure the entered class code exists in the school’s account. |
Class Code 3 does not exist | Ensure the entered class code exists in the school’s account. |
Class Code duplicated in the row | Remove the duplicated class code from the row |
Class Code 1 does not exist in the current school | Ensure the entered class code exists in the school’s account. |
Class Code 2 does not exist in the current school | Ensure the entered class code exists in the school’s account. |
Class Code 3 does not exist in the current school | Ensure the entered class code exists in the school’s account. |
Class is deleted | Remove deleted class code from the row. |
If you received the error “Duplicate Student ID”, it means the student ID already exists within the district’s Measuring Up Live account. The ID may already be in use at your school or in another school within the district.
To check within your school:
Go to Management > Student > Student Roster, select All Years from the school year drop-down menu, then enter the student ID in the Search field and select GO. If the student account is found under a previous school year, click to restore the account to the current school year.
To check within your district:
Go to Management > Transfer > School Transfer, enter the student ID, and select GO. If the student account is found in another school’s account, you can click to transfer the student to your school’s account.
If certain rows in your Student Data Import file continue to cause the import to fail and attempts to fix and reimport the file are unsuccessful, it may be best to remove those rows and address them separately. Start with the last row in the file and work your way backward, deleting the rows with data issues. The error report will indicate which rows contain errors (see example below).