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
  • Help & Support
  • 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.

  • RIO Certification
    RIO Certification Program RIO Academy RIO Challenge RIO Recipe Training
  • Releases
    Release Notes
  • Help & Support
    Install RIO Education RIO Insights RIO Recipe Support
  • About Us
    Who is RIO Education? Start Your RIO Journey Housekeeping
  • Experience RIO in action
+ 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, a WDCi Company. This information is proprietary, confidential and protected by copyright ©2024.

CONTACT

Get in touch

  • Privacy
  • Terms of service

Knowledge Base Software powered by Helpjuice

Definition by Author

0
0
Expand