on 07-08-2010 4:07 PM
Hi Guys,
I am working on Mail 2 CSV file interface. Can any one provide me information on Sender side MAIL transformation Bean to convert CSV file to XML.
Thnx,
Siva.
Are you sure you want to convert it to xml? You already want CSV at receiver side. So there doesn't seems to be much point in changing it to xml and then changing it again from xml to csv.
Regards,
Prateek
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Prateek,
Actual my requirement is
customer send us a CSV file format attached to the email and i have to extract it from the mail and put in the file location. No mapping or anything required.
Customer sends us orders via email. The email contains some text but the order details / requirements are contained within a CSV file attachment.
Customer sends emails to us which represent their orders
The emails always include a CSV file attachment
i need to extract file attachment
Extracted file should be saved to network share folder.
My doubt is in below wiki Mail 2 File Scenario attachment in the form of xml , but in my case attachment format is CSV.
Could you please help me on this how can i handle this CSV mail attachment.
http://wiki.sdn.sap.com/wiki/display/XI/StepbyStepMailToFileScenario u2013 Mail 2 File Scenario
/people/michal.krawczyk2/blog/2005/12/18/xi-sender-mail-adapter--payloadswapbean--step-by-step - Michael blog
http://help.sap.com/saphelp_nw04/helpdata/en/2e/bf37423cf7ab04e10000000a1550b0/content.htm - Payload swap bean
http://help.sap.com/saphelp_nw04/helpdata/en/23/c093409c663228e10000000a1550b0/content.htm - Sender MAIL Adapter parameters (Configuring the Sender Mail Adapter)
- Payload Swap bean module parameters
Thnx,
Siva
Hi Prateek,
Thanks for your inputs.
I have used below beans in MAIL Adapter module Tab
1 localejbs/AF_Modules/PayloadSwapBean Local Enterprise Bean 1
2 sap.com/com.sap.aii.adapter.mail.app/XIMailAdapterBean Local Enterprise Bean mail
1 swap.keyName Content-Description
1 swap.keyName Content-Disposition
1 swap.keyValue MailAttachment-1
1 swap.keyValue attachment;filename="MailAttachment-1.xml"
as per my requirement can i use attachment;filename="MailAttachment-1.xml" as xml or can i need to change instead of xml as csv ?
Thnx,
Siva.
Hi Siva,
Check this links
Check 5th page.
Regards
Ramesh
Hello!
You can refer to SAP help page:
Adding Modules to the Module Processor
http://help.sap.com/saphelp_nwpi71/helpdata/EN/cd/5af7c0c994e24fb0d0088443513de2/frameset.htm
Inserting MessageTransformBean in Module Processor
http://help.sap.com/saphelp_nwpi71/helpdata/EN/57/0b2c4142aef623e10000000a155106/frameset.htm
As the latest link says you can develop your own class to convert the csv to xml and make it works.
Best regards,
Franklin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
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.