One Star

[resolved] Extract attachment file from outlook 365

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 Smiley Surprised(

Thanks
Regards
Stef
9 REPLIES
Moderator

Re: [resolved] Extract attachment file from outlook 365

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
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: [resolved] Extract attachment file from outlook 365

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
One Star

Re: [resolved] Extract attachment file from outlook 365

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
One Star

Re: [resolved] Extract attachment file from outlook 365

hi try to use TPOP component instead of httprequest
One Star

Re: [resolved] Extract attachment file from outlook 365

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

Re: [resolved] Extract attachment file from outlook 365

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

Re: [resolved] Extract attachment file from outlook 365

Hi Stef_el,
It's welcome to open a workitem jira issue of DI project on Talend Bug Tracker.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: [resolved] Extract attachment file from outlook 365

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.
Moderator

Re: [resolved] Extract attachment file from outlook 365

Hi Stef_el,
Thanks for your feedback and sharing your experience with us. It's helpful.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.