cancel
Showing results for 
Search instead for 
Did you mean: 

Processing e-mail attachments (also more than 1) in a CSV format

Former Member
0 Kudos

Hi guys,

have you experience with processing e-mail attachments in a .csv format?

As far as I know it's possible, but only for 1 attachment and in XML format.

Is there any way how to process .csv mail attachments?

Thanks,

Peter

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member200962
Active Contributor
0 Kudos

Hi,

Check this blog...it does not mention any processing (mapping etc) on the message....just shows how a .txt file can be send as an attachment in File --> XI --> Mail scenario:

https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/1685 [original link is broken] [original link is broken] [original link is broken]

Regards,

Abhishek.

Former Member
0 Kudos

Hi Abhishek,

this doesn't solve my problem, because what I need to do is to do transformation XML->CSV and then email it as a attachment. What the bean does, is just adding another file as an attachment.

Thanks anyway,

Peter

former_member200962
Active Contributor
0 Kudos

Hi,

because what I need to do is to do transformation XML->CSV and then email it 
as a attachment.

In the Content_Type field of the receiver mail structure you need to write the appropriate value and your file will get converted to the desired format (xml,txt,excel)

To know what Content_Type suits your requirement use this link:

http://www.iangraham.org/books/html4ed/appb/mimetype.html

I thought you will be receiving a CSV file....

If you need the receiver mail structure then here is the link:(need S-user ID)

https://websmp205.sap-ag.de/~sapidb/012006153200000361852004E/ximail30_xsd.txt

So you just need to mention the content type..

Refer these two blogs and your problem will be solved:

/people/community.user/blog/2006/09/08/email-report-as-attachment-excelword

/people/community.user/blog/2006/09/07/email-reporting

Regards,

Abhishek

jyothi_anagani
Active Contributor
0 Kudos
Former Member
0 Kudos

Hi Jyothi,

This is about using SOAP adapter which invokes a web service for emailing the file. I need to use the PI mail adapter.

Thanks anyways,

Peter

former_member181962
Active Contributor
0 Kudos

Hi Peter,

This discussion looks similar to your requirement:

Regards,

Ravi Kanth Talagana