[resolved] tFileInputExcel and localization

[gorotman]

Hi all,
how is possibile to choose localization for an input excel file?
I've a job developed, tested and used for months.
Now I've installed TOS to a different server, but when It reads excel input file, it uses a different number format (US instead of IT), then it gets errors caused by decimal and thousand separator.
I don't know ho to fix this problem (and I don't want to correct every job that I move from one to other systems).

Machine where it runs in IT locale: windows 8.1 ita, TOS 6.1.1, java 1.7, office 2010 ita.

Machine where it runs in US locale: windows server 2012 EN, TOS 6.1.1, java 1.7, office 2010 ita.

Both machines have regional settings correctly setted to italian.
I forced jvm parameters  (in TOS .ini) like this:
-Duser.country=IT
-Duser.language=it
-Duser.variant=IT
-Dosgi.nl=it_IT
-Dosgi.nl.user=it_IT

Now comparing configuration (by help menu), they have same parameters.
But TOS reads excel in US localization.
Any ideas/help?

Thanks

[Anonymous]

Hi,
How did you set "Advanced separator"(for numbers) on tfileinputexcel? 
Best regards
Sabrina

[gorotman]

Hi Sabrina, sorry me but I missed your question.
I set Advanced separator in according with italian locale "." for thousand separator and "," for decimal.
thanks

[gorotman]

Hi all,
any ideas?
Problem confirmed with TOS 6.2.1....

[gorotman · Accepted solution]

😕 in TOS 6.2.1 problem may be be fixed using "Read real values for numbers" in advanced tab (tfileinputexcel component properties).

[Anonymous]

Hi,
Sorry for delay.
The option " Read real values for numbers" in tfileinputexcel component fix your issue? Can we consider this topic as resolved?
Best regards
Sabrina

[gorotman]

yes, you can
... and I hope 😉
Regards