Skip to main content
Hi All,

 

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
  1. Lakhan Meghani (NA) Forum Ambassador
    27 feb 2021, 12:10
    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?
0/9000