Add students by Importing from MIS Systems (SIMS, CMIS, Arbor, Integris etc.)

Before you can import students, you will first need to create a report from the schools MIS. The report will need to be in a .CSV format and contain at least these 5 mandatory fields:

• First Name 
• Last Name
• Date of Birth 
• Sex
• Registration Group 

We also strongly recommend that you import the students’ UPN numbers!

1. Log Into the My BSquared Portal
2. Go to Manage Students
3. Click on CSV Import 
4. Select the ‘Import System’
5. Browse to the file you wish to upload
6. Select the ‘Does the File Contain Headings’ slider and click Next
7. ‘Map Fields’ Screen: match the fields that have not been automatically selected
8. Click Next
9. ‘Additional Options’ Screen allows you to add ‘Left Students’ to the Historic Group.
10. Choose to use the commencement date (This is the date the student will begin in the current group)
11. ‘Preview and Confirm Import’ lists the changes that will be made to the Systems.
12. Click Commit

Sample Import Files:

Basic File Download: < Basic CSV File >

Extended File Download: < Extended CSV File >

If using the Extended file, the Need Type Category Codes are as follows:

NOTE: PLEASE CHECK THAT NO SPACES / EMPTY ROWS ARE ADDED ABOVE OR BELOW YOUR DATA AND THAT HEADINGS DON’T INCLUDE BRACKETS!