email xls to text as email

[Former Member]

Hi,

has anybody done this?

• Can PI read specific outlook emails based on a user

• Can PI read the Excel attachment (in outlook email) and convert to text file

• Can PI email the text file to SAP user Inbox (ECC)

Thanks!

[Former Member · Accepted solution]

Hi Prema,

First of All for mail Adapter please have a look at the following scenario:

Step by Step Mail To File Scenario - Process Integration - SCN Wiki

• Can PI read specific outlook emails based on a user

Yes -  Since the Data Type has "From" and "To", we can very well use these fields in Mapping to filter and process only those mails which are from a specific user as required.

• Can PI read the Excel attachment (in outlook email) and convert to text file

Yes - you would require Custom Adapter Module or Java Mapping to Achieve the Same.

Have a look -

• Can PI email the text file to SAP user Inbox (ECC)

I am not sure about this one but if its a single user, you can configure a particular folder to drop the file and run a Abap program within ECC to deliver it to a particular User. If its multiple user, probably adding some prefix/Suffix on the file to determine the user will help.

Hope it helps.

Thanks &  Regards,

Tejas Bisen