I am trying to Upsert to sfdc from a CSV using SFDMU. I believe something in my config is off. In the log, I see that it finds the appropriate RecordType record, but I get the error: "1 missing parent lookup records were found." (I have a couple of other lookups using External Ids, and they're working nicely.)
Any idea what I am doing wrong?
My source csv header row ends with: ,RecordTypeId
For the source csv data row, I've tried both the DeveloperName (High_School) and the composite name (High_School;;Education_Institution__c)
Both of those retrieve a single RecordType...but both give the same error.
My json has this node:
{
"query": "SELECT <misc fields> ,RecordTypeId FROM Education_Institution__c",
"operation": "Upsert",
"externalId": "External_ID__c"
}
Any guidance is appreciated.
Hello Kermit. I did not find an answer here. I did do some additional work on this, and may have found the cause though. Looking in the targets folder, the RecordType file contains:
Id,$$DeveloperName$NamespacePrefix$SobjectType
High_School;;Education_Institution__c,ID0000000000000003
This seems backwards? The header shows the Id in the first column, but in the data, the Id is the second column. But as far as I know, I have no control over this.
I worked on importing other objects, and I encountered other issues...
This one is very peculiar - upserting to an object where there are two lookups to the same object - SFDMU doesn't seem to handle it properly.
And a timeout when uploading about 120k records.
https://salesforce.stackexchange.com/questions/400524/sfdmu-timeout-during-insert
Are you very familiar with SFDMU? I encountered a number of issues in a pretty short amount of time...although I'm also very new to it - only worked with it for about three days - so maybe the issues are with my config.
