Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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