I need to import Contacts into SFDC(NPSP). I know I have to update the account id value in contacts csv file before importing the records. But how do i get ids of each of the account names? I know it is possible by checking the url. Is there any other way to find out? The account id values are unique if i'm correct. What does it mean if the account id is same for multiple accounts? Please help me to understand this.
regards,
Anandhi
5 respuestas
Lakhan Meghani (NA) Forum Ambassador
Hi Anandhi,
I have a better suggestion and further you want to import the data in SFDC
Open workbench and login in your Org.
http://workbench.developerforce.com/
SOQL query-
Select id, name from Account;
Run this query and export data
Note- You can export it using dataloader or workbench, whatever you want to use
Now, In your excel of Contact records, match columns of Contact list having account name and in your export list, you have id,account name
By this, you can just import the contact data along with accountid
Does that make sense?