One Star

Read XML and write to Talend XML component

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
3 REPLIES
One Star

Re: Read XML and write to Talend XML component

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
One Star

Re: Read XML and write to Talend XML component

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
One Star

Re: Read XML and write to Talend XML component

You can try using component tFileInputMSXML
BR,
Roman