Onboarding Guide: Data Migration
Prepare your source data, then we profile, import and verify it together.
What this stage covers
The Data Migration stage moves your existing records into SHEQ Assure. It covers four steps:
- Upload source workbook & create migration run
- Profile (dry run) & review issues
- Execute import
- Verify imported records
Steps 1-4 are run by the SHEQ Assure team from the Data Migrations console - but the quality of the import depends on the workbook you provide.
What to provide
Send your source data as a spreadsheet with one sheet per register, typically:
- Personnel - name, email, position, department, start date
- Assets / plant & equipment - name, number, type, serial number, purchase or commissioning date
- Contractors & suppliers - name, contact, ABN, services, prequalification status
- Documents (optional) - number, title, category, version, review date
How to prepare the data
- One record per row; keep column headings on row 1
- Use consistent spelling for departments and positions (they are matched to your lookup lists)
- Fill in emails where you have them - they drive logins and notifications
- Flag or remove records you do not want imported
- Do not worry about perfect formatting: the profiling step reports duplicates, missing fields and mismatched values so we can fix them before anything is imported
How the steps run
- Profile (dry run) shows exactly what would be created and what would fail - nothing is written yet
- Execute import creates the records and keeps a rollback manifest
- Verify compares record counts and spot-checks samples against your source
If anything looks wrong after import, the run can be rolled back cleanly and re-run once the data is corrected.