topic Re: tFileOutputExcel date format issue in Talend Studio

tFileOutputExcel date format issue

Anonymous — Sat, 16 Nov 2024 08:24:41 GMT

Hi All,

I have an oracle table which have two columns of date format. When i pull the data from Db to Excel those are shown as -1. The code is working fine in my local DB, but when i deploy it in Unix machine im facing this issue. Can you anyone help me with this

Re: tFileOutputExcel date format issue

Anonymous — Mon, 16 Apr 2018 09:24:43 GMT

Hello,

Did you deploy your Job on Talend Runtime to retrieve data from your database? Are you referring to this related scenario:TalendHelpCenter: Scenario: Deploying your Job on Talend Runtime to retrieve data from a MySQL database?

In advanced settings of tfileoutputexcel component, have you tried to set the "Encoding" as UTF-8 to see if it works?

Best regards

Sabrina

Re: tFileOutputExcel date format issue

Anonymous — Mon, 16 Apr 2018 10:08:11 GMT

Hi Sabrina,

I have checked the encoding UTF-8 but still it doesn't work.

Thanks,

Vanitha

Re: tFileOutputExcel date format issue

Anonymous — Tue, 17 Apr 2018 08:41:17 GMT

Hello,

What's the locale encoding of your unix server?

If the project starts with the -Dfile.encoding=UTF-8 set, try to change the locale encoding to UTF-8.

Best regards

Sabrina