Data Migration and Loading

+ More

There are 2 types of data that need to be migrated to RIO Education:

Master Data

Static set of data which the transactional data refers to.
For example, Academic Program, Course, and Grade Setting.

Transactional Data

Data that changes over time, as students progress throughout each academic year. Transactional data will look up to the master data.

For example:

Program Enrollment records change as new students enroll to the Academic Program every year.
Course Enrollment records change if students change Courses.
Grades that a student achieved will look up to the Grade Setting for the range (i.e. 80 - 100: High Distinction) and be displayed accordingly.

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).

Contact Us