[resolved] Unparseable date tFileInputMail component

One Star

[resolved] Unparseable date tFileInputMail component

Hi,
I need to pop email and generate a CSV file with 3 columns (From, Date, Subject). I started to use the talend example (tPop + tFileinputmail + tFileOutputDelimited).
It's work when each column format is in string type. But if i try to put the date format like "EEE, dd MMM yyyy HH:mm:ss Z", i have à unparse error like that
Starting job POPMAIL at 11:09 02/02/2009.
Exception in component tFileInputMail_1
java.lang.RuntimeException: Unparseable date: "Thu, 11 Dec 2008 09:33:06 +0000"
at routines.system.ParserUtils.parseTo_Date(ParserUtils.java:127)
at sncf.popmail_0_1.POPMAIL.tPOP_1Process(POPMAIL.java:700)
at sncf.popmail_0_1.POPMAIL.runJobInTOS(POPMAIL.java:963)
at sncf.popmail_0_1.POPMAIL.main(POPMAIL.java:877)
Job POPMAIL ended at 11:09 02/02/2009.
Thanks a lot for your help.
Ben

Accepted Solutions
One Star

Re: [resolved] Unparseable date tFileInputMail component

Solve it!
Instead using parseDate method, I've used parseDateLocale, like this :
TalendDate.parseDateLocale("EEE, dd MMM yyyy HH:mm:ss Z",row2.date,"en")
And it works fine!

All Replies
Highlighted
One Star

Re: [resolved] Unparseable date tFileInputMail component

I need your help !! Thanks a lots...
Ben
One Star

Re: [resolved] Unparseable date tFileInputMail component

I have same problem. Did you solve it?
Thanks
One Star

Re: [resolved] Unparseable date tFileInputMail component

Solve it!
Instead using parseDate method, I've used parseDateLocale, like this :
TalendDate.parseDateLocale("EEE, dd MMM yyyy HH:mm:ss Z",row2.date,"en")
And it works fine!

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

6 Ways to Start Utilizing Machine Learning with Amazon We Services and Talend

Look at6 ways to start utilizing Machine Learning with Amazon We Services and Talend

Blog