topic Re: DATE DATA TYPE (UNPARSED DATE ERROR) in Talend Studio

DATE DATA TYPE (UNPARSED DATE ERROR)

Anonymous — Tue, 25 Sep 2012 10:13:24 GMT

hi all,
i am new to talend
My sourece is csv, there in date column i have date date in "MM/DD/YYYY" pattern,
when tried that to load in staging table . I am getting the error "UNPARSED DATE"
My db is oracle here defaoult pattern is dd-mm-yyyy, i tried talend.parsedate in tmap also
any help.....

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

Anonymous — Tue, 25 Sep 2012 10:36:44 GMT

How does you schema look like? is the datatype of the field set to date?

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

Anonymous — Tue, 25 Sep 2012 12:55:09 GMT

hi,
Yes, datatype field set as Date

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

Anonymous — Tue, 25 Sep 2012 15:24:38 GMT

Did you define the date-pattern in the schema of tOracleOutput?
you can modify this by pressing ctrl-space in, see my screenshot for an example.

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

Anonymous — Tue, 25 Sep 2012 15:41:59 GMT

Hi,
I can't find your screen shot.
But between file and staging table i am using Tschemacompliancechaeck component
to check the datatype, so all the records stopped there itself...and it shows that Unparseable date: "5/31/2011"

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

Anonymous — Wed, 26 Sep 2012 08:03:11 GMT

Click on "Edit Schema" on your input component (tFileInputDelimited?).

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

Anonymous — Wed, 26 Sep 2012 10:42:19 GMT

Hi,
In my (tFileInputDelimited ) Schema i have date pattern like this "MM-dd-YYYY", but in my source file its like MM/dd/yyyy-5/31/2011

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

Anonymous — Wed, 26 Sep 2012 10:53:03 GMT

Hi,

Just change date pattern in edit schema menu. If the date is in the format "MM/DD/yyyy", you should set date pattern to "MM/DD/YYYY" (for the input file). For writing in a db table in format "MM-dd-YYYY", just edit the tDb_nameOut component schema and set date pattern there to "MM-dd-yyyy".

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

Anonymous — Wed, 26 Sep 2012 10:59:06 GMT

*note, for this to work you have to read the date correctly from input(date column should be of date type, not string type for the schema of your file input)

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

Anonymous — Wed, 26 Sep 2012 13:03:31 GMT

Hi,
I need to change MM/dd/YYYY to dd-MM-YYYY
MM/dd/YYYY---this format in source file
dd-MM-YYYY-- this is in output table , so as you said i changed in schema still it showing error

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

Anonymous — Thu, 27 Sep 2012 12:06:51 GMT

tfileinputdelimited | ---> toracleoutput
(for the date field | (for the datefield set the date pattern "dd-MM-YYYY" in toracleoutput schema)
set date pattern to |
"MM/dd/YYYY" in the
tfileinputdelimited
schema)
what is the error shown? copy-paste the err msg

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

Anonymous — Fri, 28 Sep 2012 08:06:13 GMT

Are there null values or other wrong data in your source file?