Import Teachers

IMPORT NEW TEACHER DETAILS

1. Select the Import New Teacher Details option from the drop-down menu in Step 1 and click the Submit button.

2. Download and fill in the .csv file by clicking the Download CSV File Template button.

Follow the instructions listed below to fill out the .csv file.

• All classes need to have been created before importing new teachers.
• Begin entering user data in the eleventh row (cell A11).
• Account Type should be entered as TA for a 30-day Trial Account. For subscription account, enter as 'SA-3M' for a 3-month subscription, 'SA-6M' for a 6-month subscription or 'SA-12M' for a 12-month subscription.
• If a teacher belongs to multiple classes, enter all the relevant class names, each separated by commas.
• If a teacher is not assigned to any classes, the Class column should be filled in as N/A.
• Role should be entered as either TEACHER or SCHOOLADMIN.
• All fields are required.
• Please ensure that none of the columns contain illegal characters (' " `).

Please note that instructions can also be viewed by clicking the View Instruction Guide in Step 2.

3. Select the completed .csv file by clicking Select File in Step 3 and then the Upload button.

Please note: Please do not refresh this page or press the back button when the system is processing your data. Additionally, the Teacher Subscription will be deducted from your school account once you have added the teachers using the Subscription Account (SA) option.

UPDATE EXISTING TEACHER DETAILS

1. Select the Update Existing Teacher Details option from the drop-down menu in Step 1 and click the Submit button.

2. Select Teacher Status from either All (excluding discontinued teachers), Active, Inactive, Virtual, Expired or Discontinued.

3. Download and fill in the .csv file by clicking the Download CSV File Template button.

Follow the instructions listed below to fill out the .csv file.

• All classes need to be created before importing new teachers.
• Please ensure that none of columns contain illegal characters (' " `).
• Do not alter the DATABASE ID, STATUS, ACCOUNT TYPE, SUBSCRIPTION STATUS or EXISTING CLASS fields as they are linked to each user.
• You may modify FIRST NAME, LAST NAME, EMAIL, NEW CLASS and SUBSCRIPTION ACTION for teachers if required.
• An SA (annual subscription account) cannot be downgraded to a TA (30-day free trial account).
• The SUBSCRIPTION STATUS column gives you information about the account expiry and will be marked as EXPIRING for accounts expiring within 30 days, as EXPIRED for accounts that have already expired, or as ACTIVE otherwise.
• When an account is renewed, the account type will be changed to SA and its status will be changed to ACTIVE.

TRANSFER TEACHERS

• To transfer teachers from an existing class, update the NEW CLASS column for each teacher.
• For a teacher assigned to multiple classes, enter all the relevant class names, each separated by commas.
• For a teacher who is not assigned to any classes, the NEW CLASS column should be filled in as N/A.
• If you would like to remove the teacher from all their existing classes, the NEW CLASS column should be filled in as N/A.
• If the teacher remains in the same class, fill in the NEW CLASS column with their existing class name.

EXPIRED ACCOUNTS

• Expired accounts should be either renewed or discontinued.
• If you do not wish to renew/upgrade an expired account, mark the SUBSCRIPTION ACTION as DISCONTINUE. The discontinued accounts will be deleted after the account has expired for 6 months.

ACCOUNT RENEWAL/UPGRADE

• To renew/upgrade an account, fill in the SUBSCRIPTION ACTION as 'SA-3M' for a 3-month subscription, 'SA-6M' for a 6-month subscription or 'SA-12M' for a 12-month subscription.
• If the account does not need to be renewed/upgraded, SUBSCRIPTION ACTION should be filled in as N/A.

TEACHERS WHO LEFT SCHOOL

• For teachers who have left the school, specify the SUBSCRIPTION ACTION as DISCONTINUE and fill in their NEW CLASS column as N/A. The discontinued accounts will be deleted after the account has expired for 6 months. Please note that any existing classes for the discontinued teachers will be deleted.

REACTIVATE INACTIVE/DISCONTINUED ACCOUNTS

• To reactivate an inactive/discontinued TA or SA that has not expired, SUBSCRIPTION ACTION should be filled in as REACTIVATE. If the account has expired, SUBSCRIPTION ACTION should be filled in as 'SA-3M' for a 3-month subscription, 'SA-6M' for a 6-month subscription or 'SA-12M' for a 12-month subscription..

DEACTIVATE ACTIVE ACCOUNTS

• To deactivate an active TA or SA, fill in the SUBSCRIPTION ACTION as DEACTIVATE.

Please note that instructions can also be viewed by clicking the View Instruction Guide in Step 2.

4. Select the completed .csv file by clicking Select File in Step 3 and then the Upload button.

The available Number of Teacher Subscriptions is also displayed for your information in Step 3.

Please note: Please do not refresh the page or press the back button when the system is processing your data.