How do I change student usernames during the import process?

District Administrators can change the student usernames of each student account during the import process by following the steps detailed below.

The student username field is a special field. When you run the import process if the student usernames match all of the other information in each student account will be updated with the new information in the import sheet. This allows you to import a new student roster before the beginning of a school year and all grade and class assignments will be updated . . . as long as the username in the system matches the username in the import sheet. Even first and last names can be modified with this approach.

If the usernames do not match, then duplicate accounts will be created. This needs to be avoided as it can take considerable time to manually delete many duplicate accounts.

The only way to update the username field (i.e. change student usernames) through the import process is if you are using the Student ID field. The Student ID field takes priority over the username field. If you have Student ID's assigned to your student accounts you can update the student usernames by running a new import. Be sure to make sure the Student ID in the system matches the corresponding Student ID in your import sheet. All other fields will be overwritten with the information in the import sheet.

If you currently do not have Student ID's assigned to your students in the system, you can follow the steps below to add them. You can then import with Student ID's and overwrite student usernames with new data.

Click your name then click District

changeschool1

Click EXOPRT

importusername

Use the drop down filters in the left column to select the students for whom you want to change the username, then click the checkbox at the left of the header row to select all students

importusername2

Click EXPORT CSV

importusername1

The roster will open in as a csv file

Add the Student ID

82b11ff4-4cd1-4aec-80d8-7a860b5e5933_display

Edit the csv file you just exported. Add in your student ID numbers. Keep the other student information the same on the csv file.

Import your revised student roster

importusername3

If you are not familiar with the import process please see How do I import my student roster? Use the edited csv file with the student ID number column complete and perform a student import.

Create updated import sheet

d49c2031-aae6-4b4c-a643-0a8b4ab60036_display

Create import sheet with new student usernames. The student ID number on the new import sheet needs to match the student ID number associated with that student in your Track My Progress account. 

Import your new file