Warning : usage of a local non-builtin name and Debug format string

[YVES1]

Hi ,
During execution of a job
tInputFileDelimited
|
|
tInputFileExcel ----->tMap ----> tOutputFileDelimited
the following messages are displayed :
"Warning : usage of a local non-builtin name "
"Debug format string is : 0.0%"
"Debug format string is #,##0.00 \ £

With same tInputFileDelimited(same csv file) I did'nt get such message and am suspecting Excel file.
How can I identify the non-builtin name ?

Here enclosed screenshots (Job , tMap , Warning1 , Warning2)
Best regards,
YVES

[Anonymous]

Hi Yves
Which version of TIS/TOS are you using? I seen the same problem before, the warning messages are printed on tFileInputExcel component.
To locates the problem further, try to use a a tfileInputExcel to read a simple excel file and see the problem comes from the component or the file.
Best regards
Shong

[YVES1]

Hi Shong ,
I am using "Talend Open Studio"
Version: 4.2.0
Build id: r59885-20110505-1025
French version

Best regards,
Yves.

[YVES1]

Hi Shong,
With a simple job tFileInputExcel --> tFileOutDelimited I get same messages .
I attached the file the file to the post (I try use the worksheet IPP3).
Best regards,
Yves.

[YVES1]

Hi Shong,
file too big , I attach the worksheet IPP3 in zip file
Best regards,
Yves.

[YVES1]

Hi ,
zip file not allowed , I try Excel file
Best regards,
Yves.

[YVES1]

Hi Shong ,
Xls file not allowed , is there a way for me to send you the Excel file ?
now I am to go in a meeting.
Best regards,
Yves.

[Anonymous]

Hi Yves
Please send the file and the job to me via email.
Best regards
Shong

[Anonymous]

Hi
It seems the file problem, we have seen many related topics on forum, see
https://community.talend.com/t5/Design-and-Development/Excel-Warning-usage-of-a-local-non-builtin-na...
http://forum.iopus.com/viewtopic.php?f=8&t=4818
You can ignore the warning message by checking the box 'Ignoring warning message' in the advanced setting of component.
About the NPE exception, there are some null value in column row1.Crit_, to solve it, change the expression of Var1 to:
row1.Crit_==null?"":row1.Crit_

Best regards
Shong