• Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Metadata default date format

#1 2011-03-17 12:59:15

janhess
Member
Company: Newcastle University
Registered: 2009-05-19
Posts: 1277

Metadata default date format

Is there any way in TIS 4.0.2 to change the defult metadata date format of dd-MM-yyyy? All my dates are in yyyy-MM-dd format from files and databases.

Offline

#2 2011-03-17 14:51:34

vladika
Member
Company: YetAnotherBank Ltd.
Registered: 2010-05-21
Posts: 47

Re: Metadata default date format

When importing from plain txt source (tabdelimited, etc..) you have to match format as it is written inside the file you're about to import into job.

In schema editor, define the appropriate field as Date and double click on the date DatePattern and write down your format or just use CTRL+SPACE for suggestions.

For example, if your starting .csv file has date in numeric format: 17032011, you would write in DatePattern field in schema editor: "ddMMyyyy".

Once inside talend, you can just use the default format "dd-mm-yyyy". At the end of the flow:

1. If you're dumping data into say tabdelimited file, you can choose again the Date Pattern
2. if you're dumping the data into some database, there's no option to specify the date format. Database will use it's own.

Offline

#3 2011-03-17 15:30:58

janhess
Member
Company: Newcastle University
Registered: 2009-05-19
Posts: 1277

Re: Metadata default date format

I need to be able to change the default automatically generated date pattern so when I generate a table schema for a database I want the pattern as yyyy-MM-dd not dd-MM-yyyy. I don't want to have to change anything in the schema as there are dozens of date fields in the database.
I was hoping there would be something to change in the Talend preferences.

Offline

#4 2011-03-17 23:32:22

alevy
Member
Registered: 2009-11-20
Posts: 1920

Re: Metadata default date format

What DB are you using?  As vladika said, generally for a DB, a date is a date is a date.  It does not have a format as such.  The way dates are displayed by the DB is native to the DB and cannot usually be set at the field/table level.  So, when writing a Date to a DB, it does not matter what the Date Pattern is in Talend.  The Talend Date Pattern is only relevant when reading from/writing to flat-files.

Offline

#5 2011-03-21 10:37:15

janhess
Member
Company: Newcastle University
Registered: 2009-05-19
Posts: 1277

Re: Metadata default date format

I just want to be able to change the default so it applies to any date from anywhere!!

Offline

#6 2012-03-13 12:56:22

geuder
Member
Company: Mojang
Registered: 2011-10-19
Posts: 112
Website

Re: Metadata default date format

I second janhess' request.

I also want to have the default date pattern "yyyy-MM-dd"

Is that possible?

Offline

#7 2012-04-12 18:04:50

eric_k
New member
Registered: 2012-04-11
Posts: 2

Re: Metadata default date format

We really need this option as well. 

I don't see why the mapping.xml file cannot have an attribute for default date pattern just like the other fields (length, precision, etc).

if you have a job that requires hundreds of patterns to be declared, it literally makes the product unusable.  You want to waste hours of an engineers time changing a text box when the UI could just default the value from your xml config.

Shameful.

Offline

#8 2012-06-07 13:41:34

emaxt
Member
Registered: 2008-08-04
Posts: 325

Re: Metadata default date format

up.
any news?
Talend should really include a customizable global/per-project/per-DBMS default datepattern.
Very much needed.
I see also an opened ticket:
http://jira.talendforge.org/browse/TDI-13550

Offline

#9 2012-06-07 14:03:41

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

Re: Metadata default date format

Hi  All

I agree that it is an interesting and useful feature, our R&D team have known it.

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

  • Index
  •  » Talend Open Studio for Data Integration » Usage, Operation
  •  » Metadata default date format

Board footer

Powered by FluxBB