Student Import

Stage 3 > Importing > Matching

When the CSV file has been successfully imported,existing borrowers should have their details updated and any new ones will be left in the Intake table. The next step is to check through the list of borrowers within the intake table to look for anyone that has already been enrolled. This is a crucial step to the process because it ensures that there are no duplicate borrowers when the records are actually transferred to the borrowers table.


When a CSV file has been imported, the library system goes through a process that matches records in the CSV against records in the Borrowers table. It attempts to match records based on their Management System ID and failing that, their surname and forename.

If a record is not matched (such as the new users) then they are left in the enrolment table as 'new'. The easiest way to check for borrowers that are potentially duplicates, is to look down the list in the Intake table.

  • Open the Intake table from Management -> Database -> Intake
  • Check down the list using the mouse wheel or the scroll bar

Checking the total number of records that have been imported is often a good indicator too.

  • From the Intake table, look at the record count at the top right hand corner.


Generally, if you have been informed how many new pupils there are you will have an idea whether this number reflected in the record count is about right or not. In the event that you do suspect a few of the borrowers need matching to their respective Borrower record you can use the resources below to help.




Once all applicable records have been matched, only new students should be present in the Intake table. When this is confirmed, click Continue to move to the next step.

Continue