One Star

DATE DATA TYPE (UNPARSED DATE ERROR)

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.....
11 REPLIES
One Star

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

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

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

hi,
Yes, datatype field set as Date
One Star

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

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.
One Star

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

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"
One Star

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

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

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

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
One Star

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

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".
One Star

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

*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)
One Star

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

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
One Star

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

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
One Star

Re: DATE DATA TYPE (UNPARSED DATE ERROR)

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