#1 2012-02-21 12:38:03

N1866
New member
Registered: 2011-06-17
Posts: 5

tFileInputExcel UTF-8

Hi,

I'm trying to import an Excel sheet to a MS SQL Database. The job runs on a local German Win XP machine perfectly but when
running it in a remote German Linux server environment TAC reports following errors:

tFileInputExcel_1
java.io.FileNotFoundException: /SWM/SWM/Projekte/S-IP/S-IP-AN/Anwendungen_2015/Projekt_?bergreifendes/Teilprojekt_Datenqualit?t/20 Qualit?tsanforderungen/ISU_Clean_Status.xls (No such file or directory)
    at java.io.FileInputStream.open(Native Method)
    at java.io.FileInputStream.<init>(Unknown Source)
    at java.io.FileInputStream.<init>(Unknown Source)

The problem is the character set which converts e.g. Projekt_Übergreifendes into Projekt_?bergreifendes (see error message above). I set UTF-8 characters as project default encoding as well the project starts with the -Dfile.encoding=UTF-8 set. What am I do wrong ?

Thanks for helping me out

Nils

Offline

#2 2012-02-21 13:03:23

shong
Talend team
Registered: 2007-08-29
Posts: 10297
Website

Re: tFileInputExcel UTF-8

Hi
What's the locale encoding of Linux server? If the project starts with the -Dfile.encoding=UTF-8 set, try to change the locale encoding to UTF-8.

Best regards
Shong


Email:shong@talend.com
Choose Talend, Enjoy Talend!
New & Event: Talend Help Center
Talend-->the leader of open source data management and application integration solutions!

Offline

Board footer

Powered by FluxBB