topic Re: [resolved] Transforming XML to CSV in Talend Studio

[resolved] Transforming XML to CSV

Anonymous — Tue, 17 Dec 2013 17:56:17 GMT

Hi All,
I following an exercise in the book called 'Getting Started with Talend OpenStudio for Data Integration 2012'.
The exercise is relatively simple enough. Take an XML file; create the metadata for the xml file to be read (as an input xml); create the loop element and the fields to extract (I was able to preview the data); connect the fFileInputXML to the fFileOutputDelimited component, connect the two components by row-main and finally configured where I want the CSV to be outputted.
The problem: The file generates with no data. And the Job Designer during processing shows 0 rows.
What could I be doing wrong? Is there any other configurations I should change?
Thanks
S

Re: [resolved] Transforming XML to CSV

Anonymous — Wed, 18 Dec 2013 02:28:14 GMT

Hi,
Please show us your current component screenshots into forum so that we can get your situation more precisely.
Have you checked online component reference TalendHelpCenter:tFileInputXML.
Best regards
Sabrina

Re: [resolved] Transforming XML to CSV

Anonymous — Wed, 18 Dec 2013 17:41:12 GMT

Hi Sabrina,
Voila! In read through the tFileInputXML Properties link you sent me and it was the Loop limit that was the problem. In the manual it says use 0 to set no limit.
However, if I read the link you sent me it says for Limit (Loop Limit) "Maximum number of rows to be processed. If Limit = 0, no row is read nor processed. If -1, all rows are read or processed" so I've set it to -1 and it works like a gem.
Thanks,
S

Re: [resolved] Transforming XML to CSV

Anonymous — Wed, 01 Oct 2014 17:22:16 GMT

Fantastic - I've been banging my head on a wall with this for ages! The error is on p.41 if the book 'Talend Open Studio for Data Integration'.
I've put my search Google search phrase in below in case anyone else finds this page
tFileOututDeliminated "0 rows in"

Re: [resolved] Transforming XML to CSV

Anonymous — Mon, 31 Aug 2015 01:55:27 GMT

Thanks - I've been banging my head about this too! Good thing I came across your thread

Re: [resolved] Transforming XML to CSV

Anonymous — Tue, 17 Apr 2018 22:07:10 GMT

Thx for the answer, this helped my issue.