+ Start a Discussion
Satish RamananSatish Ramanan 

Importing data in junction objects

Hi, I have created one junction object "Consumer - Campaign Association". Consumer and Campaign are two master objects. Now I want to import some records which contain all the fields of Consumer object and Name field of the Campaign object. I want the Consumer records to be associated with the Campaign automatically after the import. So how can I achieve this?
 
Thanks.
JitendraJitendra

Hi Satish,

 

There are two ways :

 

1. Import required Master records and in Excel sheet assign ID of those records in Junction object and upload it using Data Loader.

 

2. This is simpe one but needs to create External ID field on both Master objects. and External ID field in Child object. While importing using DataLoader, use Upsert option.