+ Start a Discussion
Rocks_SFDCRocks_SFDC 

How to insert Opportunity Line Item for an Opportunity by using External ID and Apex Data Loader

Hi All,

I want to insert Opportunity Line Item for an Opportunity by using Apex Data Loader.

I want to do upsert operation and i want to use "External ID".

So, could anyone please give the steps do the same.

Thanks,
Anil
Rahul Sangwan7341Rahul Sangwan7341
Hi Anil,

For Using external id in data loader. You have to modify your mapping file of data loader.
Please check below mapping file(.sdl extention) for reference.
 
ActionTypeID=ActionTypeID__c
AdvocateExternalID=Contact__r\:Contact_External_Id__c
EngagementID=Engagement_name__r\:Engagement_ID__c
DateAction=DateAction__c
RecipeintPersonName=RecipientPersonName__c
actionId=Name

 
Rahul Sangwan7341Rahul Sangwan7341
Please select this as Best Answer if it helps you