Migrating Approval Data
This section outlines the migration of Approvals the source (Dev/Test) to any other target (Dev/Test/Prod) environment.
Tools Used for Migrating Data
Dataloader.iMio (to export/ import data with reference ids) www.dataloader.io
Naming convention
To migrate data
- Ensure all other metadata is migrated beforehand. For example, any new fields created on Quote/Agreement objects which are used in Approval Process.
- Create External ID fields for the objects, if not created. Text field with external ID flag checked, with an appropriate name entered.
- Approval Process
- Approval Rule Dimension
- Approval Rule
- Approval Rule Entry
- In the approval process object, create a RecordType text formula field with the return type "Text". Formula: RecordType.Name.
- For all these objects, copy each record's ID into the External ID fields in the SrcEnv. For this you must export the data from SrcEnv, update the data in the CSV and import the data back to SrcEnv. For example, ID and External ID should be the same for all these records in the source environment.
Exporting Data
- For Object Approval Rule Dimension export all records from SrcEnv.
- For Object Approval Rule export all records from SrcEnv.
- For Object Approval Rule Entry export all records from SrcEnv
- For Object Approval Rule Assignee export all records from SrcEnv
- For Object Approval Process from SrcEnv (copy-paste the filter
values)
- Export records with filter Record Type Text = Approval Process and a
specific Process Name.
- Export records with filter Record Type Text = Approval Process and a
specific Process Name.
- Manually update Backup Admin field in the CSV with the user id from
TrgEnv.
- Export records with filter Record Type Text = ‘Entry Criteria’
- Export records with filter Record Type Text = ‘Initial Submission Action’
- Export records with filter Record Type Text = ‘Final Action’
- Export records with filter Record Type Text = ‘Step Group’
- Export records with filter Record Type Text = ‘Step’
- Blank out all data from Step Assignee ID column in CSV.
- Export records with filter Record Type Text = Step Filter Criteria.
Importing Data
Before importing data sort the spreadsheet by record name (for advanced logic purposes).