Payload attachment

[former_member194677]

Hi,

Can we read payload attachement in PI 7.0.

I am using payloadswapbean and i am getting the excel attachment in MailAttachment-1 in Payload.

is there any way to read the payload and get the content of Xls using javamapping. I dont want to use adapter module.

Thanks

[baskar_gopalakrishnan2]

It is possible with java mapping. You might want to check Jakarta POI API. Please search online for to understand this API and to do coding.  Below are sample links...

http://www.javaworld.com/javaworld/jw-03-2004/jw-0322-poi.html

http://sanjaal.com/java/100/java-file/reading-excel-file-using-java-and-apache-poi/

http://www.vogella.com/articles/JavaExcel/article.html

[former_member194677]

Hi,

Excel to XML not an issue.

Please let me know how to read attachement(excel) from payload since i am using PI 7.0.

Is there any specific jars to be used for PI 7.0.

THanks

[Former Member]

Hi .

You can read Excel Attachment with JavaMapping.

one example

https://wiki.sdn.sap.com/wiki/display/XI/CODE%20-%20Create%20an%20Excel%20File%20via%20the%20JExcel%...

http://wiki.sdn.sap.com/wiki/display/XI/Dynamic+file+name+for+pass-through+scenario