Legacy data migration
Move records out of old tools and spreadsheets, checked before anything is saved.
- Uploaded
- Validated
- Approved
- ImportedDone
PassedWaits for a personEvery move is kept in the record's history
The problem
What goes wrong today
Today
Replacing an old system means moving years of data out of exports and spreadsheets. Imports fail halfway, lookups do not match, and the team finds bad rows only after they are already in the new system.
How It Works
How this use case runs, step by step
Amber steps wait for a person's decision; everything else moves on its own.
- The export arrivesAn implementation partner is moving a housing association off a system built many years ago. The client sends Excel exports of tenants, properties and repairs.
- Dry run firstThe partner runs the property file as a validation only. Forty rows reference a region spelled two different ways.
- Fix and approve Data owner approvesThe client fixes the source file. The dry run comes back clean, and the data owner approves the batch.
- ImportProperties are imported with their rooms as child records in one pass. Repairs follow, linked to the right properties by lookup.
- Rehearsed, then realThe whole migration was rehearsed in QA. On cut-over weekend, the same files run in production.
Product Capabilities
What you configure in this app
Mostly configuration. Rules that configuration cannot express are written in C#.
Records 5
- Import batch5 fields + history, files, comments
- Property4 fields + history, files, comments
- Room4 fields + history, files, comments
- Repair4 fields + history, files, comments
- Lookup lists4 fields + history, files, comments
Stages 4
- Uploaded
- Validated
- Approved
- Imported
Automatic 4
- WorkflowA validate-only dry run reports errors row by row without saving anything
- WorkflowLookups are resolved by name, so a spreadsheet can say “North region” instead of an id
- WorkflowChild records are imported with their parents in the same file
- WorkflowBulk updates fix a field across many records after import
Screens and reports 4
- Import screen with the row-level error list
- Data grid of imported records for spot checks
- Import summary by batch, in Excel
- Reconciliation counts per entity as a CSV
Who approves, in detail
Before a batch is processed, the data owner for that entity approves the validation results (record field strategy).
When the rules change
See TechAppForce on your own use case
Bring your own version of “Legacy data migration” and we will model its records, stages and approvals with you. A change a few months in is a reviewed release, not a rebuild.
Release: Entity: property
Fields
Added: + Legacy reference
Added: + Region (lookup)
Reference data
Added: + Regions North · South · East
- Developmentmake the change
- QAreview the diff, test it
- Productionpromote the release