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

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.

  • 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 '16 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. – Ilya Lepesh May 17 '16 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 '16 at 19:56

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.