[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!

What’s New for Talend Spring ’19

Join us live for a sneak peek!

Sign up now

Definitive Guide to Data Quality

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

Download

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads