XML to MongoDB - Best Approach?

Anonymous — Sat, 16 Nov 2024 11:31:22 GMT

Objective:
Read complex xml file, do some minor transformations, then load into existing mongodb collection.
Current Approach:
Use tInputFileMSXML to flatten xml into multiple tHashOutputs (works fine), use tMap to do transformations and joining (works fine), construct output to load into Mongodb (here is the problem).
Challenge (I think):
I tried using the tWriteJsonField, but it does not support multiple loop elements. How can I get the data into the structure needed to insert into MongoDB? I did search the forum (found that multiple loop elements are not support in Json related talend components), and reviewed every tutorial I could find on the internet, but none have complex XML examples.
Any help would be appreciated.
XML Source (pseudo example):
<Product name="Domesticated Animal Care Manuals">
<Attributes>
<Attrib name="Category">Care Manuals</Attrib>
<Attrib name="Type">Domesticated Animals</Attrib>
</Attributes>
<Images>
<Image name="bird photo">x2345.jpg</Image>
<Image name="cat photo">x45678.jpg</Image>
<Image name="dog photo">x5927.jpg</Image>
</Images>
<productPdfs>
<Document name="Bird Care Manual">takecareofyourbird.pdf</Document>
<Document name="Cat Care Manual">takecareofyourcat.pdf</Document>
<Document name="Dog Care Manual">takecareofyourdog.pdf</Document>
</productPdfs>
<productPricing>
<COG Type="EACH">
<Attrib name="Our Cost">4</Attribute>
<Attrib name="Retail Price">15.5</Attribute>
<Attrib name="Sale Price">10</Attribute>
</COG>
</productPricing>
</Product>
Desired Output
Mongodb Collection Structure:
{"name":"Domesticated Animal Care Manuals","category":"Care Manuals","type":"Domesticated Animals","images":,"productPdfs":,"productPricing":}

Re: XML to MongoDB - Best Approach?

Anonymous — Mon, 01 Sep 2014 12:39:48 GMT

Anyone out there that could help me, it would be greatly appreciated.

Re: XML to MongoDB - Best Approach?

Anonymous — Thu, 04 Sep 2014 13:10:00 GMT

I am willing to pay for support on this issue. Are there any resources that could help me out?

Re: XML to MongoDB - Best Approach?

Anonymous — Fri, 19 Aug 2016 11:13:04 GMT

How did you manage to do this? i want to load data into MongoDB ( more then 1 nested loop ) but I don't know how ..
I manage to fixe the 'multiple nested loop' issue by using tXMLmap but I don't know how to load this data in the MongoDB ...
Thanks

topic Re: XML to MongoDB - Best Approach? in Talend Studio

XML to MongoDB - Best Approach?

Re: XML to MongoDB - Best Approach?

Re: XML to MongoDB - Best Approach?

Re: XML to MongoDB - Best Approach?