Apex Code Development You need to sign in to do that
Don't have an account?
wilbur07 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.
James
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.
James
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 Salesforce.com 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.