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
  • RIO Ready
  • RIO Ready: Master Data

Loading data with dependencies

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? RIO Events Start Your RIO Journey 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
  • RIO Academy
    RIO Partner Enablement Program RIO Challenge V2 Learning Material Video Guides
  • Install RIO Education
    Configuration Integration with RIO Extension Package Installer Products
  • Releases
    Release Notes
  • Support
    Support FAQs Feature Articles Deep Dive Updates for other products
+ More


This is a tip on using the Data Loader and Master Data Template, when performing master data migration.


Occasionally, there will be data which refers to other data of the same type.

For example, the Term record for Semester 2 2021, is referencing Semester 1 2021 as its previous Term.


When you load these into your instance, you will encounter an error, because Semester 2 2021 needs Semester 1 2021, but Semester 1 2021 has not been created yet at that point in time.

In other words, the error happens because you are trying to create these dependent records at the same time.



To resolve this issue, you will need to load all the Term data first, without the 'Previous Term' lookup.


Then, you can proceed to upsert these data again, but this time with the 'Previous Term' lookup populated.



Note:

This also applies to any data which has a parent data of the same type.

For example, Grade Criteria might lookup to a parent Grade Criteria, and if both child and parent records are to be created at the same time, the same error will occur.

You will need to load all the records first without any lookup to parents, then, upsert the same records again with the lookups.



Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Master Data Template Guide - Program Course Requirement
  • Master Data Template Guide - Grade Setting
  • Master Data Template Guide - Facility
  • Master Data Template Guide - Plan Requirement
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