How to Import Bulk Students

How to Import Bulk Students

Idea
Overview
Bulk Import allows your administrators to efficiently import multiple students into the Student Management System. Importing students allows you to add the student in the SMS ready for enrolment at a later date. This feature is a great way to increase productivity as it saves countless hours of data entry work. 

This tutorial will show you how to download the spreadsheet template to be used in the importing and enrolment of students. This tutorial will also cover how the system validates the information provided as well as how to fix possible errors in the import.  

InfoNOTE: This exclusive feature is only available for Performance Package subscribers. Unlock the full potential of your SMS with the Performance Package. To upgrade your plan and access this feature, please contact our Support team.

Notes
Step Tutorial
Before importing your list of students, you should have the appropriate format for the SMS to properly import your students. Please follow the steps below:

1. Log in to your SMS and go to Administration. Click Settings, then click "Download" under Bulk Import Students Only Template in Organisation Information. This will download a Microsoft Excel Worksheet file with the student fields (headers) that you can populate with your students' data.


2. Check your Downloads folder in your computer and open your downloaded template. There are two tabs in the spreadsheet: Main and Reference List. 


3. Populate the Main tab with your students' data.

Use the dropdown selection available for certain columns in the spreadsheet to ensure that correct information is entered.


These dropdowns are referenced from the Reference List tab. DO NOT EDIT ANY PART OF THE REFERENCE LIST WORKSHEET to ensure data integrity. 


Once you've entered all your students' information, Save it in your computer folder.

4. Go to Students and click Bulk Import Icon.


5. A pop-up will open and you will have two options to select from:
  1. Bulk Import and Enrol
  2. Bulk Import Students Only


6. Select Bulk Import Students Only.

7. Type CONTINUE (all capitalised) and click the CONTINUE button to proceed.


8. Select your populated Excel file to import.

9. A prompt message will confirm that import was successful. Click OK.

Warning
IMPORTANT:
  1. Date of Birth format is DD/MM/YYYY.
  2. When the Password Link for a student is set to Yes, students will receive the "Student – Set Password"  email where they can now set a password for their account.
  1. A prompt message will appear for any UNSUCCESSFUL import. Click OK. 


  2. A text file will be automatically downloaded to your computer to show errors in your uploaded file.
​
​
And that’s how to import bulk students in the SMS!


Congratulations on completing this tutorial. We hope this has been helpful to you and your organisation. For any questions or concerns regarding this function, please reach out to the contact support via email.