You can export a CSV file from iSAMS which can be imported directly into the library system.
To begin, open up iSAMS and log into the system.
Once logged in, select 'Student Management' or 'Pupil Management' from the left hand side, then click on 'Student Manager' or 'Pupil Manager'
By default the 'Custom Pupil Search' screen will now be displayed. Leaving all the fields as they are already set click on the 'Save & Search' button in the bottom right:
This will perform a search that returns all students.
Once the search has completed select 'P/S All' from the menu and tick the 'Pupil's Name (Pre Name)' tick box.
The menu on the right-hand side of the screen will now be enabled. Select the 'Exporting & Reporting - Export Pupil Records' option.
Make sure 'Create new export using new fields and options' is selected and then click on 'Next'.
On the 'Field Selection' screen under 'Core Data Fields', untick 1 of either 'Preferred Name' or 'Forename (Firstname)' (depending on which is required to be imported into the library system) and then tick 'Gender' and 'Date of Birth'.
From 'Current Fields', tick the boxes for 'Form' and 'Year Group (NC)'.
Under 'Other Fields', tick 'School ID'.
Once the fields have been selected, click 'Next'.
On the 'Export Options - Step 3 of 4' screen, select 'Export to Comma Separated Values' (.csv) then click on 'Export File'.
The iSAMS system will now generate the CSV file and display a link. Click on the link and select 'Save as' then save the file to the computer.
Amending the Column Headers
Once the file has been exported, some of the field headers need to be changed so that the library system knows how to read the CSV.
Open the CSV file with Notepad or an equivalent text editor.
Change the relevant column headers to match the below:
- ManagementSystemID
- Surname
- Forename
- Gender
- DateOfBirth
- YearGroup
- TutorGroup
When the necessary columns have been renamed, the first row of the CSV will look something like this:
ManagementSystemID,Surname,Forename,Gender,DateOfBirth,YearGroup,TutorGroup
Subsequent lines will include the associated data.
The order of the columns does not matter, as long as the headers are correct.
If you are importing any additional fields with your CSV the headers will need to be changed to match the library system.
When you come to import the CSV file, select the 'WBLS' option when prompted.
