LIBRARY WORKSPACE

Import school register

Add starters or safely compare a complete pupil register.

Help Watch video

1Choose the file and purpose

Choose a CSV or Excel file (.xlsx or .xls). For an Excel workbook, the first worksheet containing data is used. The file remains in this browser until you preview and confirm it.

A full register matches pupils by UPN first. When a UPN is unavailable, an exact name is used only when it is unique in both lists, preserving existing loans and history. Ambiguous names must be corrected in the source file. Pupils absent from the file become possible leavers.

2Check the columns

Recognised MIS headings are mapped automatically. Missing optional fields remain ignored; choose a column manually when required. Positional order is used only when the file has no heading row.

Library fieldsYour MIS columnsExample
required ✓ Mapped
New
Updates
Unchanged
Errors
Possible leavers

3Review before applying

possible leavers found. Review the highlighted records before applying this full-register import.

Class/Form review ()

Only new classes and MIS names matched to a differently formatted library class are shown here.

MIS Class/Form NameYear groupResultLibrary class used

Error rows are shown first and highlighted in red. Open the original file, correct it, save it, then choose the corrected file above.

borrower matched by name only. The name was unique in both lists, but these matches should be reviewed because a UPN was unavailable.

Possible leavers ()

These active pupils were not matched to the full register. Applying the import adds them to the saved Class progression plan with destination Leavers. Their original class, loans and reservations remain unchanged until that plan is reviewed and finally applied.

NameCurrent classUPN
Open Class progressionBack to borrowers

Confirm borrower import

Check the totals before making these database changes.

Possible leavers will be assigned to Leavers in the saved Class progression plan. Their live class remains unchanged and nobody is deleted until that plan is separately reviewed and confirmed.
Existing borrower barcodes will be retained. New borrower barcodes will be generated automatically.

This mode compares the whole pupil register. Pupils are matched by UPN first, then by exact unique name only where a UPN is unavailable. This retains their existing loans and history. Ambiguous names must be corrected in the source file. Any active pupil not matched is assigned to Leavers in the saved Class progression plan.
This mode only adds or updates pupils contained in the file. Pupils absent from the file are ignored, so this mode cannot identify leavers.

You will receive a full preview before any database changes are made.

Please confirm