Moving off paper registers without losing a record
Migrations are four passes, not one import: students, seats, memberships, then an audit — with duplicate detection and a rollback you can actually rely on.
The worst migrations are not the ones that fail. They are the ones that half-succeed — 186 of 200 members imported, four of them merged into the wrong person, and nobody notices for a month. The fix is process, not software.
Four passes, in this order
StudyDesk's migration workspace runs the job as distinct passes rather than one bulk insert, because each pass depends on the last and each can be inspected on its own.
- Students — the people, their contact details and their identifiers. Nothing else can be attached until this is right.
- Seats — the floor, mapped and labelled exactly as it exists today, so allocations point at real desks.
- Memberships — plans, shifts, start and end dates and payments, linked to the students from pass one.
- Audit — a review of what was created, what was changed and what was refused, written as it happens.
Duplicates are a data problem
Paper registers accumulate the same student many times: a new line after a long absence, a second phone number in different handwriting, a shortened name on the dues page. A duplicate check runs across the imported set and surfaces candidates before anything is merged, because merging the wrong pair is far more expensive than refusing to merge at all.
“Refuse to merge is a valid outcome. Silently merging two paying members into one is how a library loses a customer and never knows.”
Rollback is a feature
Every migration action is logged — created, updated, skipped, with the reason. That log is what lets you reverse a bad pass without rebuilding the library from scratch, and it is what you show a member who disputes whether their seat was ever theirs.
Verify before you retire the register
Pick a random sample of ten members and reconcile them end to end: person, membership, seat, shift, payments, dues. Ten is enough to catch a systematically wrong import and small enough to finish in an hour. Only when all ten agree do you retire the paper.
Cutover checklist
- Full export of the paper registers photographed and stored before anything is typed.
- Pass one complete and spot-checked against the register.
- Duplicate review finished, with every merge decision recorded.
- Seat map matches the physical floor, label for label.
- Ten-member end-to-end reconciliation passed.
- Registers kept, but clearly marked as closed, for one full billing cycle.
StudyDesk Team
The team behind StudyDesk. We write about the parts of running a library that software actually fixes — seats, shifts, attendance, dues and the gate.