topic Re: gmail mail file generated through tPOP has encrypted message in Talend Studio

gmail mail file generated through tPOP has encrypted message

Anonymous — Wed, 15 Aug 2018 02:47:39 GMT

When an email is read from Gmail (IMAP), the mail file created contains encrypted message text. How to decrypt?

Thanks,

Rasyq

Re: gmail mail file generated through tPOP has encrypted message

Anonymous — Wed, 15 Aug 2018 02:49:13 GMT

Re: gmail mail file generated through tPOP has encrypted message

Anonymous — Wed, 15 Aug 2018 07:25:36 GMT

Hello,

These encrypted messages are in message or attachement? Are you able to use tfileinputmail component to read the standard key data of a given MIME or MSG email file? Does this issue repro on other email server(office 365?)

Best regards

Sabrina

Re: gmail mail file generated through tPOP has encrypted message

Anonymous — Wed, 15 Aug 2018 10:34:14 GMT

Thanks Sabrina for replying.

The original Gmail email message body is plain text. There are no attachments. I can read various message headers (To, From, Date, Subject) through tFileInputMail. But mail part "Message" output is blank. Is the mail part declaration correct?

When I used to use tPOP nearly 10 years ago there was no encryption. Gmail has changed. I don't have option to check on other mail servers.

Thanks,

Rasyq

Re: gmail mail file generated through tPOP has encrypted message

Anonymous — Wed, 15 Aug 2018 11:00:53 GMT

Worked!

Mail Type 'MSG' throws error

Exception in component tFileInputMail_1 (FuelRateEmailToDB01)
org.apache.poi.poifs.filesystem.NotOLE2FileException: Invalid header signature; read 0x65726576696C6544, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document

So MIME is used. The mail part 'Body' worked whereas mail parts 'HtmlBody' and 'RtfBody' both return null.

Also one has to lower down Google account security.

Thanks,

Rasyq

Re: gmail mail file generated through tPOP has encrypted message

sasi8008 — Tue, 23 Jul 2019 08:25:54 GMT

hi ,

Exception in component tFileInputMail_1 (Copy_of_Job_010_Read_Email)
org.apache.poi.poifs.filesystem.NotOLE2FileException: Invalid header signature; read 0x005B000A000DFEFF, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document.

could you help on this solution

Re: gmail mail file generated through tPOP has encrypted message

sasi8008 — Tue, 23 Jul 2019 08:28:10 GMT