Account Update by Import
Only the super administrator or a school administrator can update accounts by file import.
Existing accounts can be updated by uploading the new information in an Excel or CSV file.
Importing Data to Update Existing Accounts
- Export a list of the accounts you want to update. The number of columns in an exported file and the nature of the information contained therein will vary depending on the management level from which you exported the list of accounts.
- Edit the information in the exported file to match the new account data. Some columns are not editable when used for import; changes to the information under these headings will not be processed by the system.
- Import the updated file.
Assigning a Teacher to Multiple Groups
Assign a teacher account to multiple groups by entering the group names separated by commas (,) in the corresponding cell of the Groups column.
Note — If a group’s name contains a comma, add a backslash (\) before the comma.
Deleting Accounts
Delete an account by entering either “yes” or “1” in the corresponding cell of the Delete? column.
Leave the cells empty for accounts you want to retain (do not enter “no” or “0”).
Warning — Deleting an account permanently removes all personal information and any activity results associated with that account. This operation cannot be undone.
Editable and Non-Editable Data
Only certain types of information can be edited when updating accounts by file import. The following tables indicate the column headings under which data can or cannot be edited.
Student Accounts
| Editable | Non-editable |
|---|---|
| Student ID (optional) | School |
| Student’s first name | Teacher’s first name |
| Student’s last name | Teacher’s last name |
| Username | Completed activities |
| New password | Last login |
| Email address | Edited |
| Group | Typing Pal student ID (optional) |
| Custom subdomain | |
| Delete? |
Teacher Accounts
| Editable | Non-editable |
|---|---|
| Teacher’s first name | School |
| Teacher’s last name | Number of groups |
| Username | Number of students |
| New password | Last login |
| Email address | Edited |
| Groups | Typing Pal teacher ID |
| Custom subdomain | |
| Delete? |
School Administrator Accounts
| Editable | Non-editable |
|---|---|
| Administrator’s first name | School name |
| Administrator’s last name | Custom subdomain |
| Username | Creation |
| New password | Edited |
| Email address | Typing Pal administrator ID |
| Phone number | |
| Delete? |
Schools
| Editable | Non-editable |
|---|---|
| School name | Number of administrators |
| Custom subdomain | Number of groups |
| Signup code | Number of teachers |
| Delete? | Number of students |
| Creation | |
| Edited | |
| Typing Pal school ID |
Importing Updated Data Using an External List
Student accounts can be updated or deleted by importing a list from your own database if you bypass the default account identification system.
Typing Pal uses the Typing Pal student ID or Student ID as unique internal account identifiers, but you can still update student account information without them.
Warning — If you do not use the Student ID or Typing Pal student ID fields in your import file, make sure no two student accounts share the same username. Otherwise, you run the risk of unintentionally overwriting account data.
Once you have made sure that every student account has a unique username, follow these steps:
- Click the My settings tab, then click Import in the sidebar, check off the option Allow existing accounts to be updated or deleted by username and click Save.
- Delete the Typing Pal student ID column from the import file to force the system to identify accounts by Student ID or Username, in that respective order.
- Import the file to update the accounts.
Unsupported Elements
-
The Excel file must not contain functions. If you were planning on creating passwords using an Excel formula to generate random numbers, we suggest doing so in a different Excel file instead. You can then copy the cell value and paste it in the file you want to export by clicking Edit, selecting Paste Special from the menu and choosing the option to paste Values.
-
The columns in a CSV file must not be separated by a tab character. The only delimiters supported in a CSV file are commas and semicolons.
-
The file import feature cannot be used to move student accounts between schools. Moving a student account to a group at a different school can only be done from the management interface.