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: Handling External ID

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


During migration, there are 2 ways to populate the External ID for existing EDA objects:

  • Method 1: Using Data Loader.
  • Method 2: Run Script.


Method 1: Use Data Loader

Step 1: Export all records for existing EDA objects from production into a spreadsheet.

Step 2: Define the External ID for each record.

Step 3: During go live, load the spreadsheet to update the External ID in RIO's field.


Example: Export all current courses into a spreadsheet (with the record ID), and then define the External ID for each Course.


Method 2: Run Script

Step 1: Create a custom field for existing EDA objects in Production.

Step 2: Populate the External ID for each record in the custom field.

Step 3: During go live, run a script to copy the value from the custom field to RIO's External ID field.


Example: Create a custom field in the Course object, and then define the external ID.




Was this article helpful?

Yes
No
Give feedback about this article

Related Articles

  • Course Enrollment Data
  • Program Enrollment Data
  • Transactional Data
  • Data Migration: Recommended Data Extract from Paradigm
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