topic Re: Can't write to csv or txt file with tFileOutputDelimited in Talend Studio

Can't write to csv or txt file with tFileOutputDelimited

Anonymous — Sat, 16 Nov 2024 07:50:48 GMT

Hi,

I'm trying to read rows from a database table and write them to a csv or txt file. When I execute the job, it tells me that it has retrieved a number of rows (so I suppose it all went well), but then my .csv file is empty.

How can I check if those rows were really retrieved, or where is the problem?

Re: Can't write to csv or txt file with tFileOutputDelimited

ashok5 — Tue, 07 Aug 2018 22:09:40 GMT

Hi Mary,

Place a tlogrow component between Oracle and fileoutput component, so that you can print what has been retrieved on to the console.'

thanks

Ashok

Re: Can't write to csv or txt file with tFileOutputDelimited

Anonymous — Wed, 08 Aug 2018 04:23:12 GMT

Hello,

Please try to click 'Sync columns' buttion on the basic settings of tfileoutputdelimited component to see if it works. This will take automatically the columns of the previous component.

Best regards

Sabrina

Re: Can't write to csv or txt file with tFileOutputDelimited

Anonymous — Thu, 23 Aug 2018 08:24:06 GMT

@ashokvv wrote:

Hi Mary,

Place a tlogrow component between Oracle and fileoutput component, so that you can print what has been retrieved on to the console.'

thanks

Ashok

Where can I find the console? I can't see the output anywhere

Re: Can't write to csv or txt file with tFileOutputDelimited

iamabhishek — Thu, 23 Aug 2018 08:43:13 GMT

If you have tLogRow defined in your Talend job which had input flow of data that could be displayed and the job executed successfully then you could view your result here -

Re: Can't write to csv or txt file with tFileOutputDelimited

Anonymous — Thu, 23 Aug 2018 08:57:30 GMT

Ok, in my console what I have is

[statistics] connecting to socket on port 3378
[statistics] connected
*a number of blank lines equal to the number of lines read*
[statistics] disconnected

What does this mean?

Re: Can't write to csv or txt file with tFileOutputDelimited

iamabhishek — Thu, 23 Aug 2018 09:00:17 GMT

It might mean that data is not getting displayed due to incorrect mapping or due to data retrieval issue.
Screenshot of your job layout with the mapping & output would help for better diagnosis.

Re: Can't write to csv or txt file with tFileOutputDelimited

Anonymous — Thu, 23 Aug 2018 09:05:00 GMT

And this is the output in the console:

Starting job ReadFromTable at 09:54 23/08/2018.

[statistics] connecting to socket on port 3378
[statistics] connected
*798 blank rows*
[statistics] disconnected

Job ReadFromTable ended at 09:54 23/08/2018. [exit code=0]

Re: Can't write to csv or txt file with tFileOutputDelimited

iamabhishek — Thu, 23 Aug 2018 09:19:38 GMT

Ok, how about the tLogRow settings and the mapping. Could you show the schema details too.
Also, it seems there are some warnings in your db component, what does it say?