You need to sign in to do that
Don't have an account?
Kkng
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.
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.
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
I have done these steps. still getting same errors.
Please check the
Please suggest a way to find the solution.
"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:--"
Please check with below link from the forums community which might help you further.
- https://developer.salesforce.com/forums/?id=906F0000000D867IAC
Please let us know if this helps.Thanks,
Nagendra
For Importing Job Application make Email field TRUE for Unique and External ID in Candidate Object.
How to make
Email field TRUE for Unique ?