on 04-04-2013 11:28 AM
Hi,
This is MAIL-FILE scenario.
Is it possible to convert an excel file attachment of an e-mail to .csv file format through mail adapter.
Should we use conversion agent only (or) Are there any existing solutions that I can use.
Thanks,
Lakshmi.
Hi,
you can use Conversion Agent, here is a nice blog of Alex Ong.
But there are some alternatives, Michal described them and eloborated a much easier method: PI/XI: Reading MS Excel's XLSX and XLSM files with standard PI modules - easily...
/Udo
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Lakshmi,
I think you can achive this using PayloadSwapBean and PayloadZipBean
check the below link that may help you
http://scn.sap.com/community/pi-and-soa-middleware/blog/2010/12/06/pixi-
reading-ms-excels-xlsx-and-xlsm-files-with-standard-pi-modules--easily
Regards
Gagan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Gagan,
I have tried using the option you suggested.But I receiv following error during FCC and I cannot see XML file in any of the monitoring tools.So, I am not sure if the fcc parameters are correct. Following are my excel attachment and fcc details.
I receive this error "File processing failed with java.lang.Exception: Exception in XML Parser (format problem?):'org.xml.sax.SAXParseException: Content is not allowed in prolog.'
Thanks,
Lakshmi
hi ,
i think it's not converting the excel file in xml in proper way, first try without fcc and check whether XML is created or not then do for FCC
check below blog for more information:
Regards
gagan
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.