function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Data Loader and data migration

I have 2 questions:

1. I have address1, address2, and address3 fields in my csv that are supposed to go to Billing Street field in sfdc. Do I have to merge those three fields into one in my csv before using data loader?

2. I have a field called salesperson which is supposed to map to Account Owner on account object, but the field is OwnerId, and I don't have the Id of the person named in salesperson. how do I obtain the Contact Id of the person in question so I can put in the csv instead of the person's name?

Thanks for any help.


In your csv, you will have to concatenate the address1, address2, and address3 fields.  You will not be able to map multiple fields to the same field in without overwriting the data.

Also you will need to do some sort of vlookup with the User or Contact table to find the Id to populate in the OwnerId field before you upload.  We've done this several times and have examples if you need.