1

Can we use JitterBit Loader it import data into 2 related objects in a single load ?

Right now we are loading it twice using dataloader

  1. Import parent object
  2. Export Parent Object and update csv
  3. Import Child Object

Can we do this in single import uisng JitterBit ?

1 Answer 1

1

I'm afraid that Jitterbit just extends dataloader functionality. You have to describe how child is related to parent. That's why you are using three operations.

But you can reduce it to two operations by implementing external Id in you parent object. Just define in csv external Id for parent and provide it for correspondent children records.

How do I use an External ID to import related records?

You will get rid of pulling and populating Ids.

Another way is to utilize SObject Tree

But it will require some programming. I'd prefer to create win service, which runs python. And in python you can do implement your extract, import etc.

3
  • I am trying to import articles and their data categories. One article can have one or more data categories. Even after exporting I have to duplicate the rows if article has more than one data category ? Any alternative solution ?
    – ab0369
    May 17, 2016 at 18:07
  • Data categories is not child record of article, its metadata. You should consider it as field, not relationship. I can only recommend you to use excel do build your csv. Excel has vlookup functionality. May 17, 2016 at 19:35
  • Article Title, Description, Attachment .. etc are on article type object and ArticleId, DataCategoryGroup and DataCategoryName are on DataCategory.ArticleType object when I use the data Loader. We can do this in Article import but only 10MB at a time
    – ab0369
    May 17, 2016 at 19:56

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .