+ Start a Discussion
JTTNTJTTNT 

Inserting New Records Using Data Loader - One Field Being a Custom Lookup Data Type Field

Hi All,

 

I have created a custom field on a custom object as a lookup data type for our Product Codes.  This way we can enter a Product Code and the Product Name field will autofill.  We use the Data Loader to insert new records for all our samples that get shipped on a daily basis and I keep getting an error that the Product Code is invalid and I know that it is in our lookup.  Does the Data Loader not work on lookup fields when inserting new records or do I need to do some additional work?

 

Thanks,

JT

Greg HGreg H

You need to use the Id of the record where the product code is stored, not the product code itself.

-greg

TBonTBon

Could you please provide more information on how this is performed?  Do you update the csv file?  I have been trying to resolve this issue all day.  I would like to load all case data for existing contact but have problems associating with contact due to lookup field.

 

Thanks