Migrating the Clause Library and Orchestrate Definitions between Salesforce Orgs
Once you have installed and configured all necessary Conga managed packages into your target org, you can migrate your Clause Library and Orchestrate definitions using the following steps:
Manually Migrate the Clause Library between Salesforce Orgs
In some cases, the Clause Library Migration Utility will not work and you will need to migrate your library manually.
Follow the steps below to move the library between orgs. Once the library has been migrated, follow steps 2 and 3 above to move your Orchestrate definitions.
Export Clause Types from Source Org
Begin with the environment that you’re migrating from:
- Log in to dataloader
- Export the Clause Type object (APXT_Redlining_Clause_Type__c) and include the field's Id and Clause Type Name
- Change the Id header on the export file to read “Original Id” and map this to the Original Id field in the destination org
Import Clause Types to Destination Org
Move to the environment that you’re migrating into:
- Log in to dataloader
- Set up an insert on the Clause Type object (APXT_Redlining__Clause_Type__c)
- Map the fields from your CSV
- Check that records created in the new environment
Export Clause Categories from Source Org
Begin with the environment that you’re migrating from:
- Log in to dataloader
- Export the Clause Category object (APXT_Redlining__Clause_Category__c) and include the field's Id and Clause Category Name
- Change the Id header on the export file to read “Original Id” and map this to the Original Id field in the destination org
Import Clause Categories to Destination Org
Move to the environment that you’re migrating into:
- Log in to dataloader
- Set up an insert on the Clause Category object (APXT_Redlining__Clause_Category__c)
- Map the fields from your CSV
- Check that records created in the new environment
Export Clauses from Source Org
Go back to the environment that you’re migrating from:
- Log in to dataloader
- Export the Clause object (APXT_Redlining__Clause__c) with fields Id, APXT_Redlining__Clause _Type__c, APXT_Redlining__Text_Rich__c, Name
Import Clauses to Destination Org
Go back to the environment that you’re migrating into:
- Open the clause export file from the Export Clause Categories from Source Org step.
- Create a new column labeled “Destination Clause Type Id” and change the other to read “Source Clause Type Id”
- Create an additional sheet within the clause export .csv and copy the data from the Clause Type output success file
- Use a vlookup to map Clause Type Ids from your destination org into the “Destination Clause Type Id” column in the clause export file
- Save the updated file
- Login to dataloader
- Set up an insert on the Clause object (APXT_Redlining__Clause__c)
-
Map the fields from your updated CSV
- Make sure "Destination Clause Type Id” is mapped to the APXT_Redlining__Clause_Type__c field
- Map the Id column to the APXT_Redlining__External_Id__c field (this will be used in later steps)
- Check that the records created in the new environment
Export Clause Configurations from Source Org
Note: This only needs to be done for non-default configurations. Default configurations are generated automatically when the Clause records are created.
-
If you do not want to migrate all non-default Clause Configuration records:
-
If you are migrating all non-default Clause Configuration records:
Import Clause Configurations to Destination Org
Since you have uploaded clauses by this point, the system will have automatically generated the default configurations for these clauses. The query from the Export Clauses from Source Org step will have provided you with a CSV of all additional configurations which you created.
- Use the success file from your clause import from the Import Clause Categories to Destination Org step to update the Clause lookup on the Clause Configuration records using a vlookup
- Verify that no configurations have a True value in the Default field
-
Upload the CSV to the APXT_Redlining__Clause_Configuration__c object
- Map the Changes Require Approval field
- Map the Restricted field
- Map the Clause lookup field
- Map the Id to the APXT_Redlining__External_Id__c field
Export Sub Clauses from Source Org
Import Sub Clauses to Destination Org
- Pull a full export of the Clause Configuration records in your target org
- Use a vlookup on the configuration name to update the configuration ID on each sub clause
- Pull a full export of your Clause records and use a vlookup to update the Clause lookup on each sub clause to use destination org Clause Ids
-
Log in to dataloader and set up an insert on the
Sub Clause object (APXT_Redlining_Sub_Clause__c)
- Map the Clause Configuration ID to the updated lookup column field in your CSV
- Map the Sort Order
- Map the Clause ID to the updated Clause column in your CSV
Export Alternate Clauses from Source Org
Import Alternate Clauses to Destination Org
Export Clause Bundles from Source Org
Import Clause Bundles to Destination Org
- Log in to dataloader
-
Set up an insert on the Clause Bundle object (APXT_Redlining_Clause_Bundle__c)
- Map the sandbox ID field to the External ID field
- Map the Name field
Export Bundle Clauses from Source Org
Import Bundle Clauses to Destination Org
-
Use the Clause success file from the Import Clause Categories to Destination Org step, the Clause Configuration export from the Import Clause Configurations to Destination Org step, the Clause Bundle success file from the Export Clause Bundles from Source Org step to use vlookups to populate the Clause, Clause Bundle, and Clause Configuration columns on your import CSV using destination org Ids
- Pull clause name and Id from destination org, then use vlookups to associate destination org Clause Ids with the proper Bundle Clause records in your CSV
- Vlookup configuration ID’s from your destination org, mapping against the parent clause name where the configurations are DEFAULT
- For non-default configurations, map against the custom field value you set up in the Export Clauses from Source Org and Import Clauses to Destination Org steps (it is used as an external ID)
-
Log in to dataloader and set up an insert on the Bundle Clause object (APXT_Redlining_Bundle_Clause__c)
- Map Clause Bundle
- Map Clause Configuration
- Map Clause
- Map Sort Order
Export Clause Approver from Source Org
Importing Clause Approvers into a Destination Organization
Import Clause Approvers to Destination Org
- Use a vlookup to update the User Id column with Ids from your destination org
- Log in to dataloader and set up an insert on the
Clause Approver object (APXT_Redlining_Clause_Approver__c)
- Map the User field to the User Id column you just updated
Export Approval Steps from Source Org
Import Approval Steps to Destination Org
- Use the Clause Configuration export from the Import Clause Configurations to Destination Org step and the Clause Approvers success file from the Import Bundle Clauses to Destination Org step to vlookup the destination org Ids for the Clause Configuration and Clause Approver columns in your CSV
-
Log in to dataloader and set up an insert on the Approval Step object (APXT_Redlining_Approval_Step__c)
- Map Clause Approver ID
- Map Clause Configuration ID