Migration problems often begin with inconsistent records rather than software bugs. A controlled preparation process reduces duplicate learners, incorrect balances and unexpected access to personal information.
Inventory the current data sources
List the spreadsheets, physical registers, accounting exports and existing systems currently used by the institution. For each source, record its owner, last update date and whether it contains personal or financial data.
Choose the source of truth for each item. For example, one list should be authoritative for learner identifiers and another for outstanding financial balances if those belong to different departments.
Clean and standardise before importing
Check duplicate admission numbers, inconsistent phone formats, missing guardian relationships, expired staff accounts and unclear class codes. Keep a record of how ambiguous entries were resolved.
Do not erase historical names or amounts simply to make an import pass. Corrections should follow an approved process with an audit record.
- Back up original source exports securely.
- Map each source field to the intended LMS field.
- Identify required data that is missing or unreliable.
- Separate test records from real institutional data.
- Approve who may see export files and imports.
Rehearse the import with minimal data
Use a small authorised sample or synthetic data to test field mappings, relationships and date formats. Validate class assignments, permissions, balances and report totals.
Where a migration requires temporary access to personal data, record the legal basis, restrict access and securely dispose of unneeded copies after verification.
Verify, sign off and monitor
After import, compare record counts and representative samples against the approved source. Have academic and finance owners sign off separately where both domains are affected.
Plan a correction window and clear support contacts. Coordinate the actual import method with Elimvia because availability and supported data formats differ by environment and release.