• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tAdvancedFileOutputXML - Order of elements

#1 2012-06-22 11:00:38

outlaw77
Member
Registered: 2011-06-03
Posts: 39

tAdvancedFileOutputXML - Order of elements

Tags: [xml]

Hello,
I am using 4xtAdvancedFileOutputXML  to create an XML file.
Unfortunately it seems not possible to get the correct order for the elements, if "create empty elements if needed" is not checked. (but this is not possible according xsd definition!)
Is there a way to solve this?

Elements should be like:
<pricatLineItem>
tradeItemIdentification
>>procutAttributes<<
itemDescription
taxInformation
procucerCharges
>>priceInformation<<
packageInformation
</pricatLineItem>

but they are created like:
<pricatLineItem>
>>priceInformation<<
tradeItemIdentification
itemDescription
taxInformation
procucerCharges
packageInformation
>>procutAttributes<<
</pricatLineItem>

All inputs are identified due <pricatLineItem NR>, and are using the same schema.
Thankx for any input!
regards,
robert


Uploaded Images

Offline

#2 2012-06-25 08:39:24

pedro
Member
Registered: 2011-11-17
Posts: 3682

Re: tAdvancedFileOutputXML - Order of elements

Hi

Which version of TOS do you use?
I didn't encounter this issue before.
Do you check the option "Append the source xml file"?
Why don't you use tFileOutputMSXML?

Regards,
Pedro


Only Paranoid Survive.

Offline

#3 2012-06-26 12:15:29

outlaw77
Member
Registered: 2011-06-03
Posts: 39

Re: tAdvancedFileOutputXML - Order of elements

hy pedro,
Thank you for your answer!

I'm using 5.0.1 TEDICe.

I thought this would be the best component for my needs :-). I used it bevor (in previous versions of TOS and it worked fine). I don't know if tFileOutputMSXML would really worke with my xml structur?.
Nevertheless in the mean time I tried it, but using more than 2 Datasources always gives me an org.eclipse.emf.codegen.jet.JETException: InvocationTargetException/java.lang.NullPointerException - I gave it up!

My temporary solutions is to insert a fix value in the second DataInput at the position I fill in the third input and to clean the element + fix input at the end of the job. Not very nice - but it works.

Regards,
Robert

Offline

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » tAdvancedFileOutputXML - Order of elements

Board footer

Powered by FluxBB