topic Re: [resolved] Extract attachment file from outlook 365 in Talend Studio

[resolved] Extract attachment file from outlook 365

Anonymous — Wed, 16 Jul 2014 15:29:39 GMT

Hello,
I want to extract the file attachment outlook 365.
I tried to use the component and tHttpRequest and tFileInputMail but it is not working properly because I can not extract the txt file.
The tHttpRequest extract a file ". Mail» but the tFileInputMail can't retrieve a txt file.
However, if I connect directly to the mailbox via internet explorer, I can see that there is 2 mail with each attachment file.
Maybe I don't use the good solution ? If you have an idea ...
For information, before I was on Lotus notes and TPOP component and tFileInputMail worked well. But now, we've change and pass on Outlook 2010 (

Thanks
Regards
Stef

Re: [resolved] Extract attachment file from outlook 365

Anonymous — Thu, 17 Jul 2014 03:18:36 GMT

Hi,
TalendHelpCenter:tFileInputMail helps to extract standard key data from emails not .txt file.
Is your file attachment extracted by tHttpRequest .txt or .mail?
Best regards
Sabrina

Re: [resolved] Extract attachment file from outlook 365

Anonymous — Thu, 17 Jul 2014 09:21:01 GMT

Hi Stef,
If nothing works for you, then there is an option of web scrapping using web automation tools.. eg. selenium.. this is handy tool when nothing works to fetch data..
vaibhav

Re: [resolved] Extract attachment file from outlook 365

Anonymous — Thu, 17 Jul 2014 14:53:47 GMT

Hi Sabrina,
Yes my component tHttpRequest extract a file ". Mail" but when I want to use my tFileInputMail component, I have the following error :
Exception in component tFileInputMail_1
java.lang.NullPointerException
at integration_npai.test_0_4.Test.tFileInputMail_1Process(Test.java:2169)
at integration_npai.test_0_4.Test.tFileInputDelimited_2Process(Test.java:1734)
at integration_npai.test_0_4.Test.runJobInTOS(Test.java:2970)
at integration_npai.test_0_4.Test.main(Test.java:2500)
I would like to say that before, my job was working fine with a Notes mailBox.
And if I compare two ".mail" file : one from Outlook and an other from Note, the structure of the file is very différent ...

Regards
Stef

Re: [resolved] Extract attachment file from outlook 365

Jcs19 — Thu, 17 Jul 2014 15:11:06 GMT

hi try to use TPOP component instead of httprequest

Re: [resolved] Extract attachment file from outlook 365

Anonymous — Thu, 17 Jul 2014 15:47:41 GMT

Hi Jcs19,
Before I was uses a TPOP component.
But now, there is no pop protocol ...
Regards

Re: [resolved] Extract attachment file from outlook 365

Anonymous — Thu, 17 Jul 2014 15:51:44 GMT

Now I have to connect to https://portal.microsoftonline.com and then go to Outlook ...

Re: [resolved] Extract attachment file from outlook 365

Anonymous — Fri, 18 Jul 2014 08:34:49 GMT

Hi Stef_el,
It's welcome to open a workitem jira issue of DI project on Talend Bug Tracker.
Best regards
Sabrina

Re: [resolved] Extract attachment file from outlook 365

Anonymous — Fri, 18 Jul 2014 15:14:01 GMT

The problem was solved by the network team.
In fact, they opened the port at the firewall for Pop server of Office 365.
I was able to again utiiser my TPOP component.

Re: [resolved] Extract attachment file from outlook 365

Anonymous — Mon, 21 Jul 2014 03:48:49 GMT

Hi Stef_el,
Thanks for your feedback and sharing your experience with us. It's helpful.
Best regards
Sabrina