Dtyjlui

I am trying to load some (FinServ__ReciprocalRole__c) data using dataLaoder.
This data should be imported to many environments (sandboxes and scratch orgs).
Given that the RecordType ID is not the same in the various sandboxes and sratch orgs, i want to use the RecordType name instead of the ID as it's consistent across all environments.

Here is an example of a record that i am trying to import:

FinServ__CreateInverseRole__c, Name,   FinServ__InverseRole__c, RecordType.Name

"FALSE",                       "TEST", "INVERSE TEST",          "Contact Role"

No data was imported and i a got this error message:

RecordType ID: id value of incorrect type: Contact Role

Note: I've already checked the accessibility of the record types in my profile.

Did any one encounter this kind of issue by any chance ? thanks for your help.

FRAME CHALLENGE

For one-time imports from a CLI to use in multiple orgs (including scratch orgs), you should be using sfdx. This allows you to write a shell script/batch file that allows you to make a portable upload:

sfdx force:data:bulk:upsert -s FinServ__ReciprocalRole__c -f file/to/import.csv -i Id -w 10

Using the Bulk API allows you to specify references, as outlined in Relationship Fields in a Header Row.

The Data Loader is not purpose-built for migrating data between orgs (thus manual mapping in Excel/external apps is often required), so it lacks many of the features that are found in SFDX and newer tools.

I know one way you can use. You have to use a custom field and a trigger.

1. Create a text field on FinServ__ReciprocalRole__c named as RecordTypeTemp__c
   


2. 
   

   Write a before insert trigger on FinServ__ReciprocalRole__c to map RecordTypeTemp__c into RecordType Id

   
   
   

   Trigger ReciprocalRoleTrigger on FinServ__ReciprocalRole__c (before insert){
   
   
   
       Map<String , Schema.RecordTypeInfo> reciprocalNameRecordTypeMap = FinServ__ReciprocalRole__c.SObjectType.getDescribe().recordTypeInfosByDeveloperName;
   
   
   
   
   
       for(FinServ__ReciprocalRole__c ind : Trigger.new){
   
           ind.RecordTypeId = reciprocalNameRecordTypeMap.get(ind.RecordTypeTemp__c).recordTypeId;
   
       }
   
   }
   
   

   
   

Now when you load data, dont populate recordTypeId field just populate RecordTypeTemp__c with the developer name to make a consistent behaviour in dataload accross all orgs

You cannot use Record Type Name in data loader to map to a particular record type. You will need to use RecordTypeId for this purpose.

As a reference, it is mentioned in this knowledge article:

Changing record types for multiple records via the dataloader is not as straight forward as it would seem. Instead of using the record type name, usage of the record type ID gathered via the URL is required.