Account Creation by Import

Importing allows you to upload Excel and CSV files in order to create different types of new accounts. This feature is only available to administrators.

If you wish to update existing accounts, please refer to the Account Update by Import section.

Excel and CSV Templates

Download the Excel and CSV templates or get them from the Import tab.

Note — You can change the order of the columns but you can’t change the names of the headings, because the system relies on the name of each column to determine the nature of the content of the cells in that column.

Creating the Import File for Student Accounts and Groups

The import file for creating student accounts must be composed of the following eight column headings:

Example

Example

  • Student ID (optional) — If used, this field must only contain alphanumeric characters. You can enter the unique identifier that you use in your own internal management system.
  • Student’s first name — This field must only contain alphanumeric characters.
  • Student’s last name — This field must only contain alphanumeric characters. 
  • Username — This field must contain between 3 and 20 alphanumeric characters. Usernames within the same school must be unique.
  • Password — This field must contain between 5 and 20 alphanumeric characters or the special characters (-_.!@#$%?&*():;.,).
  • Email (optional) — If used, this field must be an email address that is only used to recover a forgotten password or to transmit login information.
  • Group — This field must only contain alphanumeric characters; it generally corresponds to the name of the student’s class. If the name provided for a group does not yet exist, a new group will be created.
  • Custom subdomain — This field must contain the subdomain of the school’s Custom URL. For example, myschool is the subdomain of the following URL: http://myschool.typingpal.com.

Note— The Custom subdomain column is of no use or is absent from the templates if you import the file from the school’s Import tab.

Creating the Import File for Teacher Accounts and Groups

The import file to create teacher and group accounts must be composed of the following seven column headings:

Example

Example

  • Teacher’s first name — This field must only contain alphanumeric characters.
  • Teacher’s last name — This field must only contain alphanumeric characters. 
  • Username — This field must contain between 3 and 20 alphanumeric characters. Usernames within the same school must be unique.
  • Password — This field must contain between 5 and 20 alphanumeric characters or the special characters (-_.!@#$%?&*():;.,).
  • Email — This field must contain an email address.
  • Group — This field must be composed of alphanumeric characters which generally correspond to the name of the teacher’s classes. If a teacher has several groups, repeat the information on several lines, changing only the name of the groups (see example above). If the name provided for a group does not yet exist, a new group will be created.
  • Custom subdomain — This field must contain the subdomain of the school’s Custom URL. For example, myschool is the subdomain of the following URL: http://myschool.typingpal.com.

Note— The Custom subdomain column is of no use or is absent from the templates if you import the file from the school’s Import tab.

Creating the Import File for Schools

If an organization such as a school board acquires a subscription for all its educational institutions, the super administrator can use the import feature to add school accounts. Otherwise, the option and the template are hidden.

The import file to create schools and their school administrators must be composed of the following nine column headings:

Example

Example

  • School name — This field must only contain alphanumeric characters.
  • Custom subdomain — This field must contain the subdomain of the school’s Custom URL. For example, myschool is the subdomain of the following URL: http://myschool.typingpal.com.
  • Signup code — This field must only contain alphanumeric characters. This code can be used by the students to register themselves.
  • Administrator’s first name — This field must only contain alphanumeric characters.
  • Administrator’s last name — This field must only contain alphanumeric characters.
  • Username — This field must contain between 3 and 20 alphanumeric characters. Usernames within the same school must be unique.
  • Password — This field must contain between 5 and 20 alphanumeric characters or the special characters (-_.!@#$%?&*():;.,).
  • Email — This field must contain an email address.
  • Phone Number — This field must only contain alphanumeric characters.

Note — To create a school without an administrator, leave columns D to I empty.

Importing a List of Students, Teachers or Schools

Once your import file is ready, follow the steps below to upload your data:

  1. Import the file from the Import tab, choosing the type of data to be imported. You can also choose the Import … option from the menu of the More button on the Students, Teachers or Schools tab.
  2. Validate the operations that will be carried out in the File preview window, then click the Process data button and wait for the confirmation window.