Uploading Student Rosters to Typing Pal Program

Account Creation by Import

Importing allows you to upload Excel and CSV files in order to create different types of new accounts. This characteristic is simply 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 go them from the Import tab.

Notation — You tin change the lodge of the columns but you can't alter 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 Educatee Accounts and Groups

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

Example

• Student ID (optional) — If used, this field must only incorporate alphanumeric characters. Yous can enter the unique identifier that you lot utilise in your own internal management system.
• Student's first name — This field must simply incorporate alphanumeric characters.
• Pupil's last proper name — This field must only comprise alphanumeric characters.
• Username — This field must comprise between 3 and 20 alphanumeric characters. Usernames inside the same school must be unique.
• Password — This field must incorporate 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 countersign or to transmit login information.
• Grouping — This field must only contain alphanumeric characters; it generally corresponds to the proper noun of the student'south class. If the name provided for a group does not even so exist, a new grouping will be created.
• Custom subdomain — This field must incorporate the subdomain of the school's Custom URL. For case, myschool is the subdomain of the following URL: http://myschool.typingpal.com.

Annotation— The Custom subdomain cavalcade is of no apply or is absent-minded from the templates if you import the file from the school's Import tab.

Creating the Import File for Instructor Accounts and Groups

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

Example

• Teacher's first proper name — This field must only contain alphanumeric characters.
• Teacher's final proper name — This field must only contain alphanumeric characters.
• Username — This field must contain between 3 and twenty alphanumeric characters. Usernames inside the same school must be unique.
• Password — This field must contain between 5 and xx alphanumeric characters or the special characters (-_.!@#$%?&*():;.,).
• Email — This field must contain an electronic mail address.
• Group — This field must exist composed of alphanumeric characters which generally correspond to the name of the teacher's classes. If a teacher has several groups, repeat the data on several lines, changing just the name of the groups (come across example above). If the proper noun provided for a group does not still exist, a new group volition be created.
• Custom subdomain — This field must incorporate the subdomain of the school's Custom URL. For example, myschool is the subdomain of the post-obit URL: http://myschool.typingpal.com.

Annotation— 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 equally a school board acquires a subscription for all its educational institutions, the super administrator can use the import feature to add together school accounts. Otherwise, the option and the template are subconscious.

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

Example

• Schoolhouse proper 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 post-obit URL: http://myschool.typingpal.com.
• Signup code — This field must only comprise alphanumeric characters. This lawmaking can exist used past the students to register themselves.
• Administrator's commencement proper noun — This field must simply 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 comprise betwixt 5 and 20 alphanumeric characters or the special characters (-_.!@#$%?&*():;.,).
• Email — This field must contain an email address.
• Phone Number — This field must but contain alphanumeric characters.

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

Importing a List of Students, Teachers or Schools

One time your import file is ready, follow the steps below to upload your information:

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

Previous

Export

Next

Account Update past Import

bowenolon1951.blogspot.com

Source: https://www.typingpal.com/en/documentation/school-edition/guide/management/account-creation-by-import

Share this post