Updating User Data with CSV Data Import

You can mass-update user data using your CSV roster files for school administrators & teachers (see our article about Importing School Administrators and Teachers) and students (see our article about Importing Students). The application with try to find a matching user using the unique identifier external id, email, or username.

If the user account already exists, TypeTastic will either update modified fields or just skip if there are no updates in the data. 

School administrators and teachers 

• A unique identifier is an external ID or Email address if an external ID has not been used 
• Fields that update automatically when a match is found are 
  • first name 
  • last name 
  • password 
  • school 
  • role 
• email (=username) can only be updated with CSV data import if you have imported admins and teachers with external IDs. If not, a changed email will create a new account for the teacher.

Students 

• A unique identifier is an external ID or Username if an external ID has not been used 
• Fields that update automatically when a match is found are
  • first name 
  • last name 
  • password 
  • email 
  • school 
  • class 
• username (can only be updated with CSV data import if you have imported students with external IDs)

Using external system IDs

If you have included an external system id such as staff or student number in the initial CSV data import file, it will be used as the primary unique identifier instead of email or username. This is useful if you need to update email addresses or usernames with the CSV data import. If external ID is not used, teacher emails and student usernames can only be updated manually. 

You can use the CSV updating to add external IDs to TypeTastic afterward, matching will be done by email (admins, teachers) or username (students). 

NOTE!

You can only update user data with the CSV data import, it is not possible to delete user accounts with it.