function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
KkngKkng 

Recruitment app: I have got errrors while importing job_applications.csv. I have followed the tips but still have got errors.

error is 
INVALID_FIELD:Foreign key external ID: george@schnell.com not found for field Name in entity Candidate__c:--"
"","false","false","INVALID_FIELD:Foreign key external ID: dcarroll@merce.com not found for field Name in entity Candidate__c:--"
"","false","false","INVALID_FIELD:Foreign key external ID: mary@jane.com not found for field Name in entity Candidate__c:--"
"","false","false","INVALID_FIELD:Foreign key external ID: bonnie@existnet.com not found for field Name in entity Candidate__c:--"
"","false","false","INVALID_FIELD:Foreign key external ID: claudie@remark.com not found for field Name in entity Candidate__c:--"
"","false","false","INVALID_FIELD:Foreign key external ID: george@schnell.com not found for field Name in entity Candidate__c:--"

I have followed 

Step 1) Setup>Find>Object>Candidate>Email>Edit>Do not allow duplicate values
Step 2) Setup>Data Import Wizard>Custom Objects>Job Applications>Add new records>Candidate Field>Email(External ID)>Position Field>Position Name>Next>Map Postion object with Position and Cadidate with Candidate>Next and VIOLA.

Still got errors? Please help/

Also When i Cross check position lookup field, it was mentioned job_applications1 as child. why? I couldn't able to edit it to job_applications because its giving error saying job_applications lookup already present on positons.
NagendraNagendra (Salesforce Developers) 
Hi Kavitha,

Sorry for this issue you are encountering.

Please follow below steps and let us know if this helps.

For uploading the data you need to define email id in candidate object as unique. Then you will get an option Email(External ID) in data import wizard. Rest process is the same as the pdf.

The instruction Define Lookup Matching: Which field on Candidate...? Email(External ID) Which field on Position...? Position Title
Wants you to be able to upload data on basis of External IDs but as per current version, the pdf is a bit outdated. Selecting only Candidate Name in Candidate lookup field does not resolve the lookup relation completely. In the case of position look up, as position name is a standard field it gets mapped easily.

Kindly mark this as solved if the reply was helpful.

Thanks,
Nagendra
KkngKkng
Hi, Thank you for your response.
I have done these steps. still getting same errors.
Please check the User-added imageUser-added image
Please suggest a way to find the solution.
KkngKkng
Errors are 

"Id","Success","Created","Error"
"","false","false","INVALID_FIELD:Foreign key external ID: george@schnell.com not found for field Email__c in entity Candidate__c:--"
"","false","false","INVALID_FIELD:Foreign key external ID: dcarroll@merce.com not found for field Email__c in entity Candidate__c:--"
"","false","false","INVALID_FIELD:Foreign key external ID: mary@jane.com not found for field Email__c in entity Candidate__c:--"
"","false","false","INVALID_FIELD:Foreign key external ID: bonnie@existnet.com not found for field Email__c in entity Candidate__c:--"
"","false","false","INVALID_FIELD:Foreign key external ID: claudie@remark.com not found for field Email__c in entity Candidate__c:--"
"","false","false","INVALID_FIELD:Foreign key external ID: george@schnell.com not found for field Email__c in entity Candidate__c:--"
 
NagendraNagendra (Salesforce Developers) 
Hi Kavitha,

Please check with below link from the forums community which might help you further. Please let us know if this helps.

Thanks,
Nagendra
KkngKkng
Found this
For Importing Job Application make Email field TRUE for Unique and External ID in Candidate Object. 

How to make
Email field TRUE for Unique ?