topic [resolved] Unparseable date tFileInputMail component in Talend Studio

[resolved] Unparseable date tFileInputMail component

Anonymous — Sat, 16 Nov 2024 14:05:15 GMT

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

Re: [resolved] Unparseable date tFileInputMail component

Anonymous — Thu, 05 Feb 2009 09:53:56 GMT

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

Re: [resolved] Unparseable date tFileInputMail component

Anonymous — Wed, 09 Sep 2009 10:25:37 GMT

I have same problem. Did you solve it?
Thanks

Re: [resolved] Unparseable date tFileInputMail component

Anonymous — Mon, 14 Sep 2009 10:43:16 GMT

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!