Importing From MIS Systems

First Create the report from the schools SMS
This will need to be in a .CSV format and contains at least the fields in the Note Below 
  1. Log Into the NEW MyBsquared Portal
  2. Go to Manage Students
  3. Click on Import 
  4. Select the 'Import System'
  5. Browse to the File you Wish to Upload
  6. Select the 'Does the File Contain Headings' Slider 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. Chose 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. Click 'Commit'

Sample Files: SampleImportFile-basic.csv , SampleImportFile-extended.csv

Note: There are 5 mandatory fields 

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

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

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