topic Re: Read XML and write to Talend XML component in Talend Studio

Read XML and write to Talend XML component

Anonymous — Sat, 16 Nov 2024 13:50:13 GMT

Hi,
I am trying to convert an xml file to talend component xml file so that from the new talend xml component file , I can able to create java source from Talend.

But when I try to read an xml file using tFileInputXML, am not able to give the xml schema to tFileInputXML component to read the existing xml file and trying to put in tAdvancedFileOutputXML component. In this component I can able to select the xsd but am getting the error message saying "Parameter (XML Loop) must have atleast one value".

Kindly help me to resolve this issue.

Thanks & Regards,
Inigo Skylab

Re: Read XML and write to Talend XML component

Anonymous — Fri, 07 Aug 2009 12:03:29 GMT

Hi,
Now I can able to read XML file using tFileInputXML but in output am not getting the loop data.
i.e.; The original xml file is
<Vector__Changed>
<person>
<firstname>Joe</firstname>
<lastname>Walnes</lastname>
<phone>
<code>123</code>
<number>1234-456</number>
</phone>
<fax>
<code>123</code>
<number>9999-999</number>
</fax>
<phoneList>
<phonenumber>
<code>456</code>
<number>9999-999</number>
</phonenumber>
<phonenumber>
<code>879</code>
<number>9999-999</number>
</phonenumber>
</phoneList>
</person>
<person>
<firstname>Inigo</firstname>
<lastname>Skylab</lastname>
<phone>
<code>123</code>
<number>1234-4567</number>
</phone>
<fax>
<code>123</code>
<number>9999-999</number>
</fax>
<phoneList>
<phonenumber>
<code>456</code>
<number>9999-999</number>
</phonenumber>
<phonenumber>
<code>879</code>
<number>9999-999</number>
</phonenumber>
<phonenumber>
<code>222</code>
<number>9999-999</number>
</phonenumber>
<phonenumber>
<code>555</code>
<number>9999-999</number>
</phonenumber>
</phoneList>
</person>
</Vector__Changed>
and the generated xml file from Talend tAdvancedFileOutputXML component is
<?xml version="1.0" encoding="ISO-8859-15"?>
<Vector__Changed>
<person>
<firstname>Joe</firstname>
<lastname>Walnes</lastname>
<phone>
<pcode>123</pcode>
<pnumber>1234-456</pnumber>
</phone>
<fax>
<fnumber>9999-999</fnumber>
<fcode>123</fcode>
</fax>
<phoneList>
<phonenumber>
<pncode>456</pncode>
<pnnumber>9999-999</pnnumber>
</phonenumber>
</phoneList>
</person>
</Vector__Changed>
Under Phone number tage the loop has not taken place and under person tag, Inigo Skylab data has not generated from original file.

Please suggest anything else to be added in configuration part.
Thanks & Regards,
Inigo Skylab

Re: Read XML and write to Talend XML component

_AnonymousUser — Fri, 09 Oct 2009 16:48:01 GMT

Hi
I'm trying to do a very simple XML file transformation and I'm getting the same error (and I've had the same results - just one record in the outfile)
Did you get an answer from anyone in the end? Or did you manage to figure it out?
I'd be keen to hear?
Thanks
Dave

Re: Read XML and write to Talend XML component

Anonymous — Fri, 09 Oct 2009 20:03:50 GMT

You can try using component tFileInputMSXML
BR,
Roman