US English (US)
ES Spanish

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • Log in
English (US)
US English (US)
ES Spanish
  • Home
  • RIO Recipe
  • Build & Implementation
  • Data Migration & Loading

Data Migration and Loading

Contact Us

If you still have questions or prefer to get help directly from an agent, please submit a request.
We’ll get back to you as soon as possible.

Please fill out the contact form below and we will reply as soon as possible.

  • About Us
    Who is RIO Education? Experience RIO in action Customer go-live events Our Partners Housekeeping
  • RIO Insights
    Careers
  • RIO Recipe
    Project Management & Governance Discovery Design & Prototype Build & Implementation UAT Deployment & Metadata RIO Recipe: Training
  • Install RIO Education
    Configuration Integration with RIO Extension Package Installer Products
  • Releases
    Release Notes
  • Support
    Support FAQs Feature Articles Deep Dive RIO Academy Updates for other products
+ 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.


Delete

Important - Recommended format for extracts

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




Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Data Migration: Recommended Data Extract from Paradigm
  • Transactional Data
  • Course Enrollment Data
  • Course Enrollment Result Data
RIO Education

RIO Education Inc, a WDCi Company. This information is proprietary, confidential and protected by copyright ©2023.

CONTACT

E:  getinfo@wdcigroup.net

  • Privacy
  • Terms of service

Definition by Author

0
0
Expand