Import Students

Please note: Only a School Administrator is able to import students and this functionality is not available for tablets and mobile devices.

IMPORT NEW STUDENT DETAILS

1. Select Import New Student Details 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 students.
• Begin entering user data in the eleventh row (cell A11).
• Account Type should be entered as VA for Virtual Account, TA for 30-day Trial Account or SA for Annual Subscription Account.
• If a student belongs to multiple classes, enter all the relevant class names, each separated by commas.
• If a student is not assigned to any classes, Class column should be filled in as N/A.
• Ensure the classroom name you provided in the class column is identical to your Classroom List. The classroom name is space sensitive.
• All fields are required.
• Please ensure that all columns do not contain illegal characters (' " `).

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

3. Upload the completed .csv file by clicking Select File to select the file and then the Upload button. 

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

UPDATE EXISTING STUDENT DETAILS

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

2. Select student status from either All (excluding discontinued students), 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 students.
• Please ensure all columns do not contain illegal characters (' " `).
• Do not alter the DATABASE ID, ACCESS CODE, STATUS, ACCOUNT TYPE, SUBSCRIPTION STATUS or EXISTING CLASS fields as they are linked to each user.
• You may modify FIRST NAME, LAST NAME, NEW CLASS and SUBSCRIPTION ACTION for the students, if required.
• An SA (annual subscription account) cannot be downgraded to a TA (30-day free trial account) or a VA (virtual account). A TA (30-day free trial account) cannot be downgraded to a VA (virtual 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. For a virtual account, the SUBSCRIPTION STATUS will always be N/A.
• When an account is renewed, the account type will be changed to SA and status will be changed to ACTIVE.

TRANSFER STUDENTS

• To transfer students from an existing class, update the NEW CLASS column for each student.
• For a student belonging to multiple classes, enter all the relevant class names, each separated by commas.
• For a student 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 student from all their existing classes, the NEW CLASS column should be filled in as N/A.
• If the student 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.

STUDENTS WHO LEFT SCHOOL

• For students 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 students 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.
• To reactivate a discontinued VA, SUBSCRIPTION ACTION should be filled in as REACTIVATE.

DEACTIVATE ACTIVE ACCOUNTS

• To deactivate an active TA or SA, fill in the SUBSCRIPTION ACTION as DEACTIVATE. A virtual account cannot be deactivated.

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

4. Upload the completed .csv file by clicking Select File to select the file and then clicking on the Upload button.

The Number of Student Subscriptions remaining is also listed in Step 3.

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