topic Re: Problem with tFileOutputExcel in Talend Studio

Problem with tFileOutputExcel

Anonymous — Sat, 16 Nov 2024 13:46:10 GMT

Hi all,
I am having a problem with tFileOutputExcel. I want to output a date (from tAccessInput)- but when I attempt to do this, I get the following error:
"wf_tFileOutputExcel_1 cannot be resolved:
Exception in thread "main" java.lang.Error: Unresolved compilation problem:
wf_tFileOutputExcel_1 cannot be resolved
at cms_project.teme_0_1.Teme.tAccessInput_1Process(Teme.java:461)
at cms_project.teme_0_1.Teme.runJobInTOS(Teme.java:881)
at cms_project.teme_0_1.Teme.main(Teme.java:802)"
I am fairly new to Talend and am unsure of how to resolve this.
However, when i use a tLogRow instead of the tFileOutputExcel, the output is correct.
Please help - much appreciated!

Re: Problem with tFileOutputExcel

Anonymous — Mon, 14 Sep 2009 12:45:56 GMT

Please see the generated code and go to the line which creates compilation error and hope you can solve thr problem.
To see the code please click on the tab that appears at the right hand side of the "Designer' tab in the design pane of TOS.
Thanks and Regards,
Pravu Mishra.

Re: Problem with tFileOutputExcel

Anonymous — Mon, 14 Sep 2009 12:56:50 GMT

Thanks! I have just worked it out - I did the following:
TalendDate.formatDateLocale("yyyy/MM/dd",row1.TempDate,"EN")
This resolves my problem - but there is still one question for me which is: Do all fields on a tFileOutputExcel always have to be String on the relevant schema? My jobs always throw errors when I attempt to use anything other than String...

Re: Problem with tFileOutputExcel

Anonymous — Mon, 14 Sep 2009 13:05:32 GMT

In case of Excel I feel it as always better to have string type for all the output columns.
Date and decimal formats by Excel creates problem.
Thanks and Regards,
Pravu Mishra.

Re: Problem with tFileOutputExcel

Anonymous — Mon, 14 Sep 2009 13:09:55 GMT

U have to specify a date format, in the schema u send to Excel because Excel mixes data and their display.
If U don't, u should get this kind of Exception :
Exception in component tFileOutputExcel_1
java.lang.RuntimeException: Date pattern must be set for column dateNaissance in the schema of component tFileOutputExcel_1!

Re: Problem with tFileOutputExcel

Anonymous — Mon, 14 Sep 2009 13:39:37 GMT

Morbo, even when I do this, I get the 'wf_tFileOutputExcel_1 cannot be resolved' error. I am using TOS 3.0.4

Re: Problem with tFileOutputExcel

Anonymous — Mon, 14 Sep 2009 14:18:11 GMT

All, I have now worked out why i was getting the 'wf_tFileOutputExcel_1 cannot be resolved' error. Having checked the Java (and not being a Java expert by any means) I managed to work out that it is because within tFileOutputExcel, the font format was set to none. Therefore, when it compiles, it fails.
For a newbie, this is baffling (I have wasted a lot of time trying to work it out). Can I make a suggestion that a default is set on the actual tFileOutputExcel so that this error does not occur?