Import students 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 effective date (This is the date the students 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:

OTH Other Difficulty Disability
ASD Autism Spectrum Disorder
HI Hearing Impairment
SPLD Specific Learning Difficulty
SLD Severe Learning Difficulty
NSA No Specialist Assessment
MLD Moderate Learning Difficulty
PDA Pathological Demand Avoidance
PMLD Profound Multiple Learning Difficulty
VI Visual Impairment
PD Physical Disabilty
MSI Multi Sensory Impairment
SLCN Speech Language Communication Needs
SEMH Behaviour Emotional Social Difficulties

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


Top tips before you start an import:

  • Update your MIS first - if you're importing students using a csv, make sure your MIS (e.g. SIMS) is updated with their new classes before generating the file. Only import the students that you wish to work with in our systems.
  • Set the correct start date - Use the first day of the new academic year as the “effective date”.
  • Include the student UPN numbers in the import - If there is no UPN number, first name, last name and DOB will be used to match student records. This is less reliable as duplicate records will be created if the information in those three fields does not match exactly.
Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us