I have one custom object named Class__c, which has one master relationship with another custom object named Plan__c.

I have Class.csv files which contains classes objects. This csv file also has external id of the parent Plan__c record.

When I import Class__c records using the following relationship:


Where External_Plan_Class_Key__c is the external key for Class__c object and External_Plan_Key__c is the external key for Plan__c object.

It is throwing error

required field plan__c is missing.

I was expecting that if load will first match external keys for class if it does not exist it should insert it.

Our business plan always comes in Class.csv files which will always exist in salesforce. We do not plan to support upsert, only update.

Still it is asking for Plan__c missing field.

  • 7
    I found same question from user here: salesforce.stackexchange.com/questions/112363/… Mar 1 '16 at 5:02
  • Thanks Martin for quick response.Is there any other way apart from trigger and job which can be implemented.And yes that question was also posted by me,i thought i was not able to explain problem in that. Mar 1 '16 at 5:06
  • If you don't mind me taking a step back, why not support upsert? That's the easiest way to work with external ids.
    – martin
    Mar 1 '16 at 5:08
  • We are doing upsert only.Process is upsert. Mar 1 '16 at 5:23
  • Your org Validation is preventing not the upsert job itself i think Mar 1 '16 at 5:24

I tried to mimic your scenario, and I was able to load the data. I guess the problem is with your Mapping file only. If there is a existing Plan record with the external Id you specified in csv, it should pickup the master record accordingly.

And this behaviour is something which is not a Org specific, there is no different setting we have to do for it. Please let me know if you need any other info.


Not the answer you're looking for? Browse other questions tagged or ask your own question.