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

Announcements
Discover how organizations are unlocking new revenue streams: Watch 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!