tFileOutputExcel date format issue

Four Stars

tFileOutputExcel date format issue

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

Moderator

Re: tFileOutputExcel date format issue

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 datab...?

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

Best regards

Sabrina

 

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: tFileOutputExcel date format issue

Hi Sabrina,

 

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

 

Thanks,

Vanitha

 

 

 

Moderator

Re: tFileOutputExcel date format issue

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Why Companies Move to the Cloud: 7 Success Stories

Learn how and why companies are moving to the Cloud

Read Now

Agile Data lakes & Analytics

Accelerate your data lake projects with an agile approach

Watch

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download