topic Re: Multiple Loop XML in Talend Studio

Multiple Loop XML

Anonymous — Sat, 16 Nov 2024 12:22:54 GMT

Hi,
I have a problem when executing the ?tfileoutputmsxml?.
I am trying to fix elements on the xml tree, after the loop element. But when I come back on the xml tree (tfileoutputmsxml) elements have changed place.
When I execute the result is not the one expected. Is there a solution to have this output?
Expected OUTPUT:
<rootTag>
<transaction id="1300400000011">
<retailTransaction>
<lineItem article="1">
<retail discount="20.00"/>
</lineItem>
<lineItem article="2">
<retail discount="30.00"/>
</lineItem>
<lineItem paiement="34224.0"/>
<lineItem paiement="34225.0"/>
<afterLoop1></afterLoop1>
<afterLoop2></afterLoop2>
</retailTransaction>
Regards
Yoann
</transaction>
<transaction id="1300400000012">
<retailTransaction>
<lineItem article="3">
<retail discount="50.00"/>
<retail discount="10.00"/>
</lineItem>
<lineItem paiement="34226.0"/>
<lineItem paiement="34227.0"/>
<lineItem paiement="34228.0"/>
<afterLoop1></afterLoop1>
<afterLoop2></afterLoop2>
</retailTransaction>
</transaction>
</rootTag>

Re: Multiple Loop XML

Anonymous — Wed, 15 Feb 2012 06:16:52 GMT

Hi Yoann
There can be only one loop element in xml component. But you can set group element.
I guess you didn't set the component correctly.
Regards,
Pedro

Re: Multiple Loop XML

Anonymous — Wed, 15 Feb 2012 09:03:15 GMT

Hi pedro,
In the tFileOutputMSXML, it's possible to configure multiple loop element.
The problem is i don't have what i want in output...
Regards,
Yoann

Re: Multiple Loop XML

Anonymous — Wed, 15 Feb 2012 09:05:35 GMT

Hi Yoann
Sorry... I regards tAdvancedOutputXML as tFileOutputMSXML...
Regards,
Pedro

Re: Multiple Loop XML

Anonymous — Wed, 15 Feb 2012 09:54:50 GMT

Yes the main problem is not multiple loop, but i cannot put my element AfterLoop1 and AfterLoop2 where i want. They always appear in the begining of the loop instead of the end..
If anyone got a solution...
Regards,
Yoann

Re: Multiple Loop XML

janhess — Wed, 15 Feb 2012 10:22:29 GMT

The only way I've found to reposition them is by editing the jobname.item file and moving them in that. Not elegant but gets you there

Re: Multiple Loop XML

Anonymous — Wed, 15 Feb 2012 10:50:33 GMT

Hi janhess
I have this part of code in my jobname.item :
<node componentName="tFileOutputMSXML" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="736" posY="448">
<elementParameter field="TEXT" name="UNIQUE_NAME" value="tFileOutputMSXML_1"/>
<elementParameter field="FILE" name="FILENAME" value=""C:/Talend/test/outXML.xml""/>
<elementParameter field="TABLE" name="ROOT">
<elementValue elementRef="PATH" value="/rootTag"/>
<elementValue elementRef="COLUMN" value="output1"/>
<elementValue elementRef="VALUE" value=""/>
<elementValue elementRef="ATTRIBUTE" value="main"/>
<elementValue elementRef="ORDER" value=""/>
<elementValue elementRef="PATH" value="/rootTag"/>
<elementValue elementRef="COLUMN" value="output3"/>
<elementValue elementRef="VALUE" value=""/> <elementValue elementRef="ATTRIBUTE"

To see the whole post, download it here
OriginalPost.pdf

Re: Multiple Loop XML

janhess — Wed, 15 Feb 2012 11:11:35 GMT

Not quite sure where you want then. Can you give an xml example.

Re: Multiple Loop XML

Anonymous — Wed, 15 Feb 2012 11:17:26 GMT

That s what i want. The only problem is the position of AfterLoop1 and AfterLoop2

Re: Multiple Loop XML

janhess — Wed, 15 Feb 2012 11:29:44 GMT

What are you actually getting?

Re: Multiple Loop XML

janhess — Wed, 15 Feb 2012 11:37:27 GMT

I think the problem may be round the tag lineItem which has different attributes for the 2 loops. I suspect when it is doing the matching to set up the loops, it matches on tag not tag and attribute.
You may need to raise a bug.

Re: Multiple Loop XML

Anonymous — Wed, 15 Feb 2012 11:38:22 GMT

With this :
<node componentName="tFileOutputMSXML" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="736" posY="448">
<elementParameter field="TEXT" name="UNIQUE_NAME" value="tFileOutputMSXML_1"/>
<elementParameter field="FILE" name="FILENAME" value=""C:/Talend/test/outXML.xml""/>
<elementParameter field="TABLE" name="ROOT">
<elementValue elementRef="PATH" value="/rootTag"/>
<elementValue elementRef="COLUMN" value="output1"/>
<elementValue elementRef="VALUE" value=""/>
<elementValue elementRef="ATTRIBUTE" value="main"/>
<elementValue elementRef="ORDER" value=""/>
<elementValue elementRef="PATH" value="/rootTag"/>
<elementValue elementRef="COLUMN" value="output3"/>
<elementValue elementRef="VALUE" value=""/>
<elementValue elementRef="ATTRIBUTE" value="main"/> <elementValue elementRe

To see the whole post, download it here
OriginalPost.pdf

Re: Multiple Loop XML

janhess — Wed, 15 Feb 2012 11:52:19 GMT

I tried setting up your first loop which gave the following in the .item file for vn 4.0.2
<node componentName="tAdvancedFileOutputXML" componentVersion="0.102" offsetLabelX="0" offsetLabelY="0" posX="1024" posY="352">
<elementParameter field="TEXT" name="UNIQUE_NAME" value="tAdvancedFileOutputXML_1"/>
<elementParameter field="CHECK" name="USESTREAM" value="false"/>
<elementParameter field="TEXT" name="STREAMNAME" value="outputStream"/>
<elementParameter field="FILE" name="FILENAME" value=""C:/TIS_PE_RTX-All-r43696-V4.0.2/workspace/out.xml""/>
<elementParameter field="TABLE" name="ROOT">
<elementValue elementRef="PATH" value="/rootTag"/>
<elementValue elementRef="COLUMN" value=""/>
<elementValue elementRef="VALUE" value=""/>
<elementValue elementRef="ATTRIBUTE" value="main"/>
<elementValue elementRef="ORDER" value="1"/>
</elementParameter>
<elementParameter field="TABLE" name="GROUP">
<elementValue elementRef="PATH" value="/rootTag/transaction"/>
<elementValue elementRef="COLUMN" value=""/>
<elementValue elementRef="VALUE" value=""/>
<elementValue elementRef="ATTRIBUTE" value="main"/>
<elementValue elementRef="ORDER" value="2"/>
<elementValue elementRef="PATH" value="id"/>
<elementValue elementRef="COLUMN" value=""/>
<elementValue elementRef="VALUE" value=""/>
<elementValue elementRef="ATTRIBUTE" value="attri"/>
<elementValue elementRef="ORDER" value="3"/>
<elementValue elementRef="PATH" value="/rootTag/transaction/retailTransaction"/>
<elementValue elementRef="COLUMN" value=""/>
<elementValue elementRef="VALUE" value=""/>
<elementValue elementRef="ATTRIBUTE" value="main"/>
<elementValue elementRef="ORDER" value="4"/>
<elementValue elementRef="PATH" value="/rootTag/transaction/retailTransaction/afterLoop1"/>
<elementValue elementRef="COLUMN" value=""/>
<elementValue elementRef="VALUE" value=""/>
<elementValue elementRef="ATTRIBUTE" value="branch"/>
<elementValue elementRef="ORDER" value="10"/>
<elementValue elementRef="PATH" value="/rootTag/transaction/retailTransaction/afterLoop2"/>
<elementValue elementRef="COLUMN" value=""/>
<elementValue elementRef="VALUE" value=""/>
<elementValue elementRef="ATTRIBUTE" value="branch"/>
<elementValue elementRef="ORDER" value="11"/>
</elementParameter>
<elementParameter field="TABLE" name="LOOP">
<elementValue elementRef="PATH" value="/rootTag/transaction/retailTransaction/lineItem"/>
<elementValue elementRef="COLUMN" value=""/>
<elementValue elementRef="VALUE" value=""/>
<elementValue elementRef="ATTRIBUTE" value="main"/>
<elementValue elementRef="ORDER" value="5"/>
<elementValue elementRef="PATH" value="article"/>
<elementValue elementRef="COLUMN" value=""/>
<elementValue elementRef="VALUE" value=""/>
<elementValue elementRef="ATTRIBUTE" value="attri"/>
<elementValue elementRef="ORDER" value="6"/>
<elementValue elementRef="PATH" value="paiement"/>
<elementValue elementRef="COLUMN" value=""/>
<elementValue elementRef="VALUE" value=""/>
<elementValue elementRef="ATTRIBUTE" value="attri"/>
<elementValue elementRef="ORDER" value="7"/>
<elementValue elementRef="PATH" value="/rootTag/transaction/retailTransaction/lineItem/retail"/>
<elementValue elementRef="COLUMN" value=""/>
<elementValue elementRef="VALUE" value=""/>
<elementValue elementRef="ATTRIBUTE" value="branch"/>
<elementValue elementRef="ORDER" value="8"/>
<elementValue elementRef="PATH" value="discount"/>
<elementValue elementRef="COLUMN" value=""/>
<elementValue elementRef="VALUE" value=""/>
<elementValue elementRef="ATTRIBUTE" value="attri"/>
<elementValue elementRef="ORDER" value="9"/>
</elementParameter>

This has all the correct values in the elementRef="ORDER" so Afterloop1 & 2 have higher values than itemLine.
You could try setting the order values in your .item and see if it then produces the correct results.

Re: Multiple Loop XML

Anonymous — Wed, 15 Feb 2012 14:41:46 GMT

No it doesn't change anything ...

Re: Multiple Loop XML

janhess — Wed, 15 Feb 2012 14:44:49 GMT

Which version are you using?

Re: Multiple Loop XML

Anonymous — Thu, 16 Feb 2012 09:58:07 GMT

5.0.1
But i did something to correct this stuff, a little code using JDOM to change position of XML node. Not really clean but it works
Thanks

Re: Multiple Loop XML

Anonymous — Tue, 21 Aug 2012 14:30:32 GMT

I have the same problem and have raised it with support. It seems sometimes the element order is lost on tOutputMSXML. I'm fixing mine with an XSLT transformation.