Unparseable date error

One Star

Unparseable date error

I'm parsing through a CSV file and mapping it over to a MySQL database connection and when I run the job, I get an unparseable date error for every row (except for one). I've provided a couple of the error lines below, along with the date format that I've specified in the metadata. Anyone have any ideas as to what could cause this?
Unparseable date: "2006-11-03 15:11:34"
Unparseable date: "2006-11-06 10:35:15"
Unparseable date: "2006-11-08 13:15:17"
Unparseable date: "2006-11-10 13:51:34"
...
Date format: "yyyy-MM-dd HH:mm:ss"
Thanks.
Community Manager

Re: Unparseable date error

Hello
Which version of TOS are you using?
I tested it on TOS3.0.0M2 and it works fine.(please see the screenshot)
Best regards
shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Unparseable date error

Hi Shong,
I am working on Talend 5.3.0.r101800
My dates are in format DD/MM/YY in csv and I want to convert it into MM/DD/YYYY.
I have tried many cobination but no luck.
Can you suggest here.
Moderator

Re: Unparseable date error

Hi gopal_raturi,
My dates are in format DD/MM/YY in csv and I want to convert it into MM/DD/YYYY.

Could you please elaborate your case with an example with input and expected output values? "DDD" stands for Day in year(001-366). "dd" stands for Day in month(01-31). Could you confirm it? Thanks a lot.
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: Unparseable date error

Hi, I am having the same problem, I even change all the date types to string but still same problem. Can anyone help
Moderator

Re: Unparseable date error

Hi adjrock,
Could you give us more information about your current situation. What's your input and expected result?
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.
One Star

Re: Unparseable date error

Hi, I'm also experiencing this error
Using tFileFetch --> tFileInputDelimited --> tMap --> MysqlOutput
When I do a debug run I see unexpected text date formats like, "Mon Nov 25 00:00:00 PST 2013"
Here is my console:
connecting to socket on port 3436
connected
connecting to socket on port 4932
connected
Status Line: HTTP/1.1 200 OK
*** Response Header ***
Cache-Control: no-cache
Content-Type: text/csv; charset=UTF-8
Content-Disposition: attachment; filename=query_response.csv
Vary: Accept-Encoding
Date: Tue, 26 Nov 2013 17:11:31 GMT
Server: Google Frontend
Alternate-Protocol: 443:quic
Transfer-Encoding: chunked
Unparseable date: "ga:date"

However, the actual data gets transferred fine into my MySQL table, the dates are ok... a bit odd
Please see screen captures for my configuration; if you need any other information let me know, thanks Smiley Happy
Community Manager

Re: Unparseable date error

Hi ddctf
There is a value "ga:date" in the source file that is unparseable, if you check the 'die on error' option on tFileInputDelimited, the job will throw the exception and stop at this line.
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: Unparseable date error

Resolved, thank You Smiley Happy

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

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

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

Download