topic Re: tFileInputXML generates no output in Talend Studio

tFileInputXML generates no output

PD2 — Tue, 18 Feb 2014 21:01:37 GMT

I know I must be doing something wrong but not sure what.
I have configured the tFileInputXML to read and XML file.
I have configured my Xpath loop expression as well as the fields to extract.
When I click on "Refresh Preview" everything is there, just like I want it.
I then connect the tFileInputXML to a tFileOutputDelimited via Main.
I configure tFileOutputDelimited and run the job.
Nothing gets written to the the "csv" file configured in tFileOutputDelimited, just the header row.
How is it the the "preview" works but the job when run finds no rows?

I receive no errors so it must be me. Just not sure what to do next.
Thanks
Peter

Re: tFileInputXML generates no output

Anonymous — Tue, 18 Feb 2014 21:46:42 GMT

I guess the schema definition from the tFileOutputDelimited has destroyed your schema and mapping from the tFileInputXML.
Put a tMap between both and try it again.

Re: tFileInputXML generates no output

ff06 — Sun, 02 Mar 2014 16:35:15 GMT

Just had the same issue and I found that it was related to the xpath loop limit settings.
First, I read some misleading information saying that this limit should be zero but in fact this limit should be -1.
See the links here:
https://help.talend.com/search/all?query=tFileInputXML&content-lang=en
and
https://community.talend.com/t5/Design-and-Development/resolved-Transforming-XML-to-CSV/td-p/75977

Re: tFileInputXML generates no output

Anonymous — Tue, 28 Apr 2020 18:44:03 GMT

I had a similar issue when I was following some document saying 0 to process unlimited rows. Spent 1.5 hours trying different options to make it work but since there was no error throws it was very difficult to debug.

Finally your repsonse in this thread saved me the trouble. it worked absolutely fine by just changing limit to -1.

thanks once again for sharing the information and the link for future use.

Re: tFileInputXML generates no output

ff06 — Wed, 06 May 2020 12:37:01 GMT

You're welcome !

Always happy to help.