Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

[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
Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

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!

View solution in original post

3 Replies
Anonymous
Not applicable
Author

I need your help !! Thanks a lots...
Ben
Anonymous
Not applicable
Author

I have same problem. Did you solve it?
Thanks
Anonymous
Not applicable
Author

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!