You need to sign in to do that
Don't have an account?
Upserting Leads with the Apex Data Loader
After successfully merging Accounts, Contacts, and Opportunities from one org to another via upserting them with external IDs in the Data Loader, I went to do the same with the Leads object. I quickly noticed that when attempting to Upsert the Leads, it did not give me the option to select the External ID field on my Users so that I could map "OwnerID".
Why can't I map the external ID field on my User records to reflect lead ownership upon importing them via the Data Loader? Do I need to simply insert them and then Mass Transfer the Leads to the appropriate owner, or is there a better way?
Thanks!
Hi,
I haven't tried this explicitly but try the workbench. Pretty sure it has the smart lookup functionality available for OwnderId.
Hope this helps!
Florian
Thanks for this; it looks like a great tool. Unfortunately, my csv file is too large. Is there a size limit when using Workbench? And is it possible for you to confirm or deny whether or not inserting them with myself as the lead owner and then mass transferring them would be appropriate?