Take a look around our Help Centre for answers to your common questions

Import Teachers

CSO Support Professional -

IMPORT NEW TEACHER DETAILS

CSO_Import_Teachers.png

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 30-day Trial Account or SA for Annual Subscription Account.
    • 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 all the columns does not have 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 from your school account will be deducted once you have added the teachers using the Subscription Account (SA) option.

UPDATE EXISTING TEACHER DETAILS

CSO_import_Teachers_sequential.png

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 all the columns does not have 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 the accounts expiring within 30 days, as 'EXPIRED' for the accounts that have already expired or as 'ACTIVE' otherwise.
  • When an account is renewed, the account type will be changed to 'SA' and 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 'RENEWSUB'.
  • 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 'RENEWSUB'.

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.

Please note that the available Number of Teacher Subscriptions is displayed for your information as well in Step 3.

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

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.