• #11154
    Salesforce | Himanshu Himanshu #465

    How to import lookup relationship data from sandbox to prod in Salesforce?

    How to import lookup relationship data from sandbox to prod?


    Salesforce | Prakhar Prakhar #482

    Hii Himanshu,

    If you want to import the data which is related to the other object such as an Lookup or an Master Detail relationship then in that case you can go through the following steps:

    First create the external id field on the parent object which can be marked as unique according to the requirement in the destination org.
    Import the data for the parent in the destination org using data loader and map the id of the record with the external id field.
    Then Upsert the data for the child object into the destination Organization using Data Loader. In Step 2a of the Data Loader, select ‘ID’ as the field to use for matching child object. In Step 2b of the Data Loader, select the field created as an external id as the field to match the parent object. In the next mapping step of the Data Loader, map the parent related field of the child object to the external id field. This will allow the Data Loader to associate each child record with its respective parent record.
    After the data is being imported successfully you can delete the field.
    Hope that helps.


Viewing 2 posts - 1 through 2 (of 2 total)

Please to reply to this topic.


We're not around right now. But you can send us an email and we'll get back to you, asap.


About Us

Forcetalks is a Salesforce collaboration platform for coders & developers, geeks & nerds, consultants & business heads, admins & architects, managers & marketers and of course the business owners. A community where you can learn from, where you can contribute to. For you. For Salesforce. Read More...

Copyright 2019 Forcetalks. All Right Reserved.

Log in with your credentials


Forgot your details?