Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2009-09-14 08:11 AM

Problem with tFileOutputExcel

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!
Labels (3)
Labels
485 Views
0 Likes
6 Replies
Anonymous
Not applicable
‎2009-09-14 08:45 AM
Author

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.
485 Views
0 Likes
Anonymous
Not applicable
‎2009-09-14 08:56 AM
Author

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...
485 Views
0 Likes
Anonymous
Not applicable
‎2009-09-14 09:05 AM
Author

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.
485 Views
0 Likes
Anonymous
Not applicable
‎2009-09-14 09:09 AM
Author

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!
485 Views
0 Likes
Anonymous
Not applicable
‎2009-09-14 09:39 AM
Author

Morbo, even when I do this, I get the 'wf_tFileOutputExcel_1 cannot be resolved' error. I am using TOS 3.0.4
485 Views
0 Likes
Anonymous
Not applicable
‎2009-09-14 10:18 AM
Author

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?
485 Views
0 Likes