How to export data from iSAMS
When enrolling students on Education Perfect, you’ll need to supply certain information which will allow us to create user accounts.
This article covers the process of exporting student data from the iSAMS system.
Exporting the CSV file
- To begin, open up iSAMS and log into the system.
Once logged in, select Student Management / Pupil Management from the left hand side, then click Student Manager or Pupil Manager.
By default, the Custom Pupil Search screen will now be displayed. Leaving all the fields as they are, click on the Save & Search button in the bottom right.
This will perform a search that returns all students.
Once the search has finished, select P/S All from the dropdown and tick the Pupil’s Name (Pre Name) tick box.
The dropdown menu on the right hand side of the screen will now be enabled. Select the Exporting & Reports – Export Pupil Records option.
Make sure Create new export using new fields and options is selected and then click Next.
- On the field selection screen under Core Data Fields:
Untick either Preferred Name or Forename (Firstname) (depending on which detail should be used for student EP accounts).
EP does not store any information on gender, middle name, or date of birth, so there’s no need to include this information.
Under Current Fields, tick the boxes for Form, Year Group (NC) and Student Email Address.
Under Other Fields, tick School ID.
- Once the above fields above have been selected, click next.
On the Export Options – Step 3 of 4 screen, select Export to Comma Separated Values (.csv) and then Export File.
The iSAMS system will now generate the CSV file and display a link. You’ll need to click on the link and then select Save as to save the file to your computer.
Use your exported files to populate one of our enrolment templates within the Enrolment Portal.
Once you populate one of our enrolment templates with your exported data and upload this to our new Enrolment Portal, you'll be able to instantly add classes, teachers and students to the platform. Check out Step 2 of the guide linked above for more information on the formatting requirements of our portal.