Skip to Content
0

How to read attached CSV \ XLS file from Outlook mailbox through "read mail action block" - SAP MII

Oct 14, 2016 at 10:43 AM

173

avatar image

Hi Experts,

I wants to read attached CSV file from outlook mail box using SAP MII 14.0 .

Have Tried with read mail action block - was not able to get the attachment .

We don't have choice with FTP & PCo MS Access method.

Kindly suggest any other approach can be followed to get the attachment through SAP MII workbench using action block .

Regards,

Adhikesh

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Paul Felsheim Oct 18, 2016 at 01:55 PM
0

Did you assign the Attachment Folder with a valid path in the action block? You may get more help if you can provide additional details on what you have tried.

Share
10 |10000 characters needed characters left characters exceeded
Adhikesh Annamalai Oct 20, 2016 at 06:56 AM
0

Hi Paul,

I needs to access attachment Folder details from outlook .

So trying to access outlook using web URL by passing user credentials on URL itself.

My question is possible to access outlook attachment from read mail action block ?

Thanks in advance.

Regards,

Adhikesh

Share
10 |10000 characters needed characters left characters exceeded
Paul Felsheim Nov 01, 2016 at 08:07 PM
0

The read mail action is used to read emails from a mail server, not from an email client. You'd need to setup a connection to your Exchange or other mail server (Data Services --> Connections) and the related credentails (Security Services --> Credential Stores) as required by the action block. Any attachments retrieved go to the path specified in the action block (db:\\Project\path or web:\\Project\path).

If you really want to automatically read attachments from Outlook, as you say, maybe someone else can comment...

Share
10 |10000 characters needed characters left characters exceeded
Adhikesh Annamalai Nov 28, 2016 at 09:32 AM
0

Hi Paul,

Thanks for your inputs . Let me put in other way ,

I needs to pick attachment specific to outlook account using read mail action block.

Tried with following methods

Updated data servers--> Connections

Server - Mail server details

port - port details

Protocol - tried with POP3 & imap4

On Read mail Action block updated below

Connection alias

Credential alias

Attachment path - https://outlook.office365.com/owa/XXXX.com/

Still on read mail action block getting error message "[ERROR] [Read_Mail_0]Unable to read mail Exception: [No provider for POP3]"

Same approch works fine with send mail action block . Any specific configuration are to be followed ??

Regards,

Adhikesh

Share
10 |10000 characters needed characters left characters exceeded