https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294287#M67185 <P>Hi all,<BR />how is possibile to choose localization for an input excel file?<BR />I've a job developed, tested and used for months.<BR />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.<BR />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).<BR /><BR />Machine where it runs in IT locale: windows 8.1 ita, TOS 6.1.1, java 1.7, office 2010 ita.<BR /><BR />Machine where it runs in US locale: windows server 2012 EN, TOS 6.1.1, java 1.7, office 2010 ita.<BR /><BR />Both machines have regional settings correctly setted to italian.<BR />I forced jvm parameters&nbsp; (in TOS .ini) like this:<BR />-Duser.country=IT<BR />-Duser.language=it<BR />-Duser.variant=IT<BR />-Dosgi.nl=it_IT<BR />-Dosgi.nl.user=it_IT<BR /><BR />Now comparing configuration (by help menu), they have same parameters.<BR />But TOS reads excel in US localization.<BR />Any ideas/help?<BR /><BR />Thanks</P> Tue, 21 Jun 2016 14:22:36 GMT gorotman 2016-06-21T14:22:36Z https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294287#M67185 <P>Hi all,<BR />how is possibile to choose localization for an input excel file?<BR />I've a job developed, tested and used for months.<BR />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.<BR />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).<BR /><BR />Machine where it runs in IT locale: windows 8.1 ita, TOS 6.1.1, java 1.7, office 2010 ita.<BR /><BR />Machine where it runs in US locale: windows server 2012 EN, TOS 6.1.1, java 1.7, office 2010 ita.<BR /><BR />Both machines have regional settings correctly setted to italian.<BR />I forced jvm parameters&nbsp; (in TOS .ini) like this:<BR />-Duser.country=IT<BR />-Duser.language=it<BR />-Duser.variant=IT<BR />-Dosgi.nl=it_IT<BR />-Dosgi.nl.user=it_IT<BR /><BR />Now comparing configuration (by help menu), they have same parameters.<BR />But TOS reads excel in US localization.<BR />Any ideas/help?<BR /><BR />Thanks</P> Tue, 21 Jun 2016 14:22:36 GMT https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294287#M67185 gorotman 2016-06-21T14:22:36Z https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294288#M67186 Hi, <BR />How did you set "Advanced separator"(for numbers) on tfileinputexcel?&nbsp; <BR />Best regards <BR />Sabrina <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MFNC.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138779i02F3383C4A33D386/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MFNC.png" alt="0683p000009MFNC.png" /></span> Mon, 04 Jul 2016 11:18:06 GMT https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294288#M67186 Anonymous 2016-07-04T11:18:06Z https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294289#M67187 Hi Sabrina, sorry me but I missed your question.<BR />I set Advanced separator in according with italian locale "." for thousand separator and "," for decimal.<BR />thanks Wed, 20 Jul 2016 10:29:02 GMT https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294289#M67187 gorotman 2016-07-20T10:29:02Z https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294290#M67188 Hi all,<BR />any ideas?<BR />Problem confirmed with TOS 6.2.1.... Tue, 17 Jan 2017 11:08:35 GMT https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294290#M67188 gorotman 2017-01-17T11:08:35Z https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294291#M67189 <span class="lia-unicode-emoji" title=":confused_face:">😕</span> in TOS 6.2.1 problem may be be fixed using "Read real values for numbers" in advanced tab (tfileinputexcel component properties). Tue, 17 Jan 2017 11:22:43 GMT https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294291#M67189 gorotman 2017-01-17T11:22:43Z https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294292#M67190 Hi, <BR />Sorry for delay. <BR />The option " <FONT size="1"><FONT face="Verdana," helvetica="">Read real values for numbers</FONT></FONT>" in tfileinputexcel component fix your issue? Can we consider this topic as resolved? <BR />Best regards <BR />Sabrina Wed, 18 Jan 2017 08:12:29 GMT https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294292#M67190 Anonymous 2017-01-18T08:12:29Z https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294293#M67191 yes, you can<BR />... and I hope <span class="lia-unicode-emoji" title=":winking_face:">😉</span><BR />Regards Wed, 18 Jan 2017 09:23:03 GMT https://community.qlik.com/t5/Talend-Studio/resolved-tFileInputExcel-and-localization/m-p/2294293#M67191 gorotman 2017-01-18T09:23:03Z