Reconciling the batch

Reconcile three ways

1. Counts — rows supplied versus created, updated, skipped and rejected. These must account for every row.
2. Identity — do the asset IDs in the register match the file, including the ones Spatial7 generated because none was supplied?
3. Values — spot-check a sample of records field by field against the source, including geometry, dimensions and dates.

The rejection report

Rejected rows are listed with their row number and reason, in the same shape as the source file, so the supplier can correct and resubmit them without redoing the whole extract.

Close the migration properly

• Confirm the data-quality states and clear the review items
• Confirm mapped assets appear on the map at the right location
• Confirm the asset counts agree with the source register's own totals
• Keep the import batch reference — it is the audit record of what was loaded, when, by whom and from which file