function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
New_DeveloperNew_Developer 

Help with data extracting and loading

Hi All,

 

I have this CSV which has tasks list which needs to be loaded into the tasks. I donot have Whatid's. The whatId's in my case are Contacts. But instead i have a field called ClientID which is a external id field on Contacts. Is there any way i can pull the ContactId's(WhatId) based on that external id field into the CSV file?

 

Thanks

AmitSahuAmitSahu
Extract the contact external id and id and add them to your csv.
New_DeveloperNew_Developer

But i dont need all the Contact id's . I just need contactId's for those ClientID(ExternalId) which are there in my csv file
AmitSahuAmitSahu
First copy everything to the excel and then use vlookup to find and replace all the corresponding contact id
CNimmaCNimma

I think you should be able to use the external id to load data directly without having to get the salesforce id. In the data loader step 2a. select the external id as the matching field and in step 2b. choose the related object (Ex: Contact_r=External ID). In step 3 map Contact = Contact_r:External ID

 

Hope this helps.