Skip to main content
Importing data through import wizard how can we import data to a related list of the object.
4 risposte
  1. 12 mag 2014, 13:21
    Well, this is not using the Import Wizard but yet another awesome tool: Dataloader.io. So this might get a little long but should be very easy:

     

    **Note** : Click on the Images to View them Larger.

     

    1. Now say the I have an Account in the Name: Salesforce.com

    in my Org.

    Well, this is not using the Import Wizard but yet another awesome tool: . So this might get a little long but should be very easy: **Note** : Click on the Images to View them Larger. 1.

     

     

    2. There is a Related List in the Name Contacts on the Account record. I need to insert another 2 Contacts just under this Account.

     

    User-added image

     

     

    3. Now, how I would I go about doing this. As first step, just add another Column to the CSV named: Account. You can now mass-fill this Column with the Account Name: Salesforce.com

     

    User-added image

     

     

    4. Save it as a CSV say: Contacts.csv.

     

     

    5. Just type in https://dataloader.io in your Browser. Log-in with your Credentials.

     

     

    6. Click New Task to select: Import. Ref: http://prntscr.com/3iirpe

     

     

    7. Select the Operation as Insert and select the Object as Contacts.

     

    User-added image

     

     

    8. Click Next.

     

     

    9. Upload your CSV and Map the Columns.

     

    User-added image

     

    This step is very important and we're making use of the Lookup via Name [1] option of the Dataloader.io.

     

     

    10. Click Next. Ref: http://prntscr.com/3iisfw

     

     

    11. Save and Run.

     

     

    12. Here is what you'll have: Ref: http://prntscr.com/3iispp

     

     

    [1]: Lookup via Name (https://dataloader.io/using-import-lookups)