You need to sign in to do that
Don't have an account?
Dheeraj-(DJ)
Unable to import look up field using Data Loader and Import Wizard
Hi Team,
I am trying to import data using data loader but getting error. I have created a custom object "Test" which has a look up field "Merchandise"
I have added Merchandise ID in the column as well. Please correct me where I am doing wrong.
Thanks in Advance!
Dheeraj
I am trying to import data using data loader but getting error. I have created a custom object "Test" which has a look up field "Merchandise"
I have added Merchandise ID in the column as well. Please correct me where I am doing wrong.
Thanks in Advance!
Dheeraj
@Lokesh: Hi! I am able to import with 15 digit ID and 18 both.
@Tarun: Hi! It is a picklist data type.
Thanks for your help guys.
Dheeraj
All Answers
Check the Id values in Merchandise Id column. It should be Id of existing record of Merchandise in your org.
-Thanks,
TK
Thanks for your response. I have taken correct Merchandise IDs I guess. I am in a fix what is missing right in there.
Could you please share any existing sample csv file screenshot which has look up field in there? That would be very helpful.
And I am using the Record ID from the url displayed below.
Thanks!
Dheeraj
Always use 18 digit ID's instead of !5-digit to get the 18 digit ID's export records through WorkBench or DataLoader and take the record ID and format your CSV with 18-digit ID and do insert.
If you need any more help please let me know.
Thanks,
Lokesh
@Lokesh: Hi! I am able to import with 15 digit ID and 18 both.
@Tarun: Hi! It is a picklist data type.
Thanks for your help guys.
Dheeraj