Students

Import and export students for 2026 enrolments.

Import/Export Students

2 Student Inspection

3 Import

Import scope

bellhaven-2026-enrolments.csv · parsed 29 Aug 2026 at 08:14 Dry run

Total selected

214

Rows in the file, plus rolls no longer in it

New students

No match on any pass

Record updates

191

Matched to a student already on the roll

Removals

On the roll, absent from this file

18 new + 191 updates + 5 removals = 214 selected. The scope row counts records once each, so it sums. The change counters further down do not, and are kept separate for that reason.

How each row was matched

Three passes, in order, first hit wins 196 matched

studentNumber 171 Exact, then normalised. Leading zeros and separators stripped before comparison.

name 19 Exact, then normalised. Hyphens and apostrophes stripped on both sides.

nickname 6 Bidirectional prefix. Clem matches the Clementine already enrolled.

null 18 No match on any pass. These become the 18 new students above.

171 + 19 + 6 + 18 = 214. Every row reports the pass that caught it. The weaker the pass, the more worth a look: a nickname match is the one that creates a duplicate student if it is wrong, so those six are surfaced for review rather than applied quietly.

What changes, by type

Across the 196 matched records 9 NCCD

Grade Advances

186

NCCD Updates

Form Updates

143

Medical Updates

With warnings

These overlap and so do not sum to the total, because one student can advance a grade and change form and carry an NCCD update all at once.

Student Inspection

Row by row, before anything is written Showing 8 of 214 7 need review

CSV Student	Matched against	Match	What changes	Action
Ravenscourt, Tamsin STU-0040817	Tamsin Ravenscourt, on the roll Leading zeros stripped, so STU-0040817 met STU-40817	studentNumber	Year 7 to Year 8, form 7B to 8C already_enrolled_different_grade	Update High confidence
Kestrelton, Clem STU-40993	Clementine Kestrelton, on the roll Prefix match only; the number is absent from this export	nickname	Year 9 to Year 10, form 9A to 10G already_enrolled_different_grade	Update Low confidence
Quillane, Sunniva STU-41266	Sunniva Quillane, on the roll Apostrophes and hyphens normalised on both sides before comparison	name	Adjustment level, Supplementary to Substantial Category unchanged, Cognitive. This moves her place in the count.	Update NCCD change
Marchetti, Corinne STU-41402	Nothing on the roll All three passes returned empty	null	Created, Year 7, form 7D Cognitive, QDTP brand_new	New
Halbrook, Marta STU-39118	Archived enrolment from 2024 Returning after a year away	studentNumber	Re-enrolled, Year 11, form 11F Prior evidence retained and reattached previously_unenrolled	Update Needs opt-in
Tilbrook, Rafferty STU-41055	Rafferty Tilbrook, on the roll Exact number match	studentNumber	Year 10, no advance, form 10C to 10A Repeating the year, so the grade is held same_grade_no_advance	Update High confidence
Norrington, Yusra STU-40188	Yusra Norrington, on the roll Exact number match	studentNumber	Enrolment only, Year 8 to Year 9 NCCD columns empty in this export, so the existing record is left untouched no_nccd_data	Update NCCD skipped
Estcourt, Bede STU-38702	Bede Estcourt, on the roll Present last year, absent from this file	not in file	Unenrol, Year 12 completed Record and evidence retained, enrolment closed	Remove

Eight invented rows, one per outcome the dry run distinguishes. The third is the reason the dry run exists: an adjustment level moving from Supplementary to Substantial changes a student's place in the national count, and it should never happen because a spreadsheet column arrived in a different order this year.

Nothing has been written yet

This is the dry run. The roll is untouched until the import is confirmed. Running it writes an ImportAuditLog recording who performed it and what it did, and the whole operation can be reversed from Import History.

performedBy: R. Calderwood
timestamp: 2026-08-29 08:14
targetYear: 2026
sourceFilename: bellhaven-2026-enrolments.csv
durationMs: 4812