Activity Forums Salesforce® Discussions How can i load Objects into Salesforce with Relationship using Data Loader?

  • How can i load Objects into Salesforce with Relationship using Data Loader?

    Posted by Manpreet on March 30, 2017 at 12:51 pm

    Say i want to import Accounts , contacts and opportunities via Data Loader, how can i achieve it?

    Saurabh replied 7 years, 7 months ago 2 Members · 1 Reply
  • 1 Reply
  • Saurabh

    Member
    April 4, 2017 at 7:09 am

    Hi Manpreet,

    If in a Master-detail relationship, you first need to insert all master records.

    Then run a report to get all the Inserted Master record Id's and export them your machine.

    Now to insert detail object records, you need to associate them with Master Record ID.

    A possible approcah would be use VLOOkUP function in Excel to populate the Id's.

    Once you have the ID's populated then you can insert Detail records using data loader.

    Whereas 

    VLOOKUP is an Excel function to lookup and retrieve data from a specific column in table. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. The "V" stands for "vertical". Lookup values must appear in the first column of the table, with lookup columns to the right.
    Hope it helps.

    Thanks

Log In to reply.

Popular Salesforce Blogs

Popular Salesforce Videos