Data Migration and Loading
There are 2 types of data that need to be migrated to RIO Education:
|Static set of data which the transactional data refers to.
For example, Academic Program, Course, and Grade Setting.
Data that changes over time, as students progress throughout each academic year. Transactional data will look up to the master data.
Note: If the transactional data is from a legacy system/database, refer to this article for a list of data that needs to be shared with us.
- Extracts should be in CSV format.
- Extracts should only have a single header row and have no footer.
- Extracts should be in the form where a row represents a record instead of column(s) to represent the record.
- Sandbox and Production extracts should be consistent (i.e. the number of columns, format, and position of the columns).
Extract that fails to comply with the recommended format may be prone to data load error and it would incur a lot of manual work (time consuming).