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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
gorotman
Creator II
Creator II

[resolved] tFileInputExcel and localization

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

Labels (2)
1 Solution

Accepted Solutions
gorotman
Creator II
Creator II
Author

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

View solution in original post

6 Replies
Anonymous
Not applicable

Hi,
How did you set "Advanced separator"(for numbers) on tfileinputexcel? 
Best regards
Sabrina
0683p000009MFNC.png
gorotman
Creator II
Creator II
Author

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
Creator II
Creator II
Author

Hi all,
any ideas?
Problem confirmed with TOS 6.2.1....
gorotman
Creator II
Creator II
Author

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

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
Creator II
Creator II
Author

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