Convert csv mail-attachement to xml

[former_member246510]

Hi,

I have to process a csv-file which I get via mail-attachement. I get the attachement to XI using "PayloadSwapBean". But now I have to convert the csv-file to xml.

Can I do this using the "MessageTransformBean". If yes, how do I have to configure the module (Parameters etc.). If not, what else to I have to use?

My file looks like this:

================

HDR;ORD;2.0;NOID;tyrolit;BDE999999;Dirk.Brundelius;999999;;Meine Bestellnummer;2007-08-23T12:06;NORML;;;;;;;;;;;dirk.brundelius@nexmart.de;900952314;

ADR;SND;Jens.Stahl;Admin;nexMart GmbH & Co. KG;Gropiusplatz 10;70563;Stuttgart;DE;

ADR;DEL;nexMart GmbH;;;Gropiusplatz 10;70563;Stuttgart;DE;

TXT;RCV;Testbestellung mit CSV2-Attachment;

POS;4;;;4267;4267;tyrolit;3.0;;;;;;

QNT;SETU;PCE;

QNT;LOGT;1;

PRI;PCE;14.76;EUR;

PRI;SUM;44.28;EUR;

POS;4;;;27420;27420;tyrolit;1.0;;;;;;

QNT;SETU;PCE;

QNT;LOGT;1;

PRI;PCE;283.59;EUR;

PRI;SUM;283.59;EUR;

POS;4;;;351767;351767;tyrolit;1.0;;;;;;

QNT;SETU;PCE;

QNT;LOGT;1;

PRI;PCE;13.96;EUR;

PRI;SUM;13.96;EUR;

THANKS A LOT !!!! - werner knapp

[former_member246510]

Hi,

thanks to all the problem is solved.

werner

[Former Member]

Hi Werner

Check this blog to see how to <b>use the payload swap bean</b> of the mail adapter.

/people/michal.krawczyk2/blog/2005/12/18/xi-sender-mail-adapter--payloadswapbean--step-by-step

refer this

https://websmp102.sap-ag.de/~form/sapnet?_SHORTKEY=01100035870000582377&;

<b>XI: Sender mail adapter - PayloadSwapBean - Step by step</b>

/people/michal.krawczyk2/blog/2005/12/18/xi-sender-mail-adapter--payloadswapbean--step-by-step

<b>Have a look at these..</b>

http://help.sap.com/saphelp_nw2004s/helpdata/en/2e/bf37423cf7ab04e10000000a1550b0/frameset.htm

https://websmp109.sap-ag.de/~form/sapnet?_SHORTKEY=01200252310000071155&_SCENARIO=011000358700000002...

/people/sravya.talanki2/blog/2006/11/28/e-mail-xml-messages-in-pdf-format-from-sap-xi

Thanks!!

[former_member246510]

Thanks for your tips, but I'm still facing the problem how I should configure the "MessageTransformBean" module in my case. The SAP-documentation doesn't tell me enough of how to use the module in the mail adapter

I configured the module like this (in XI 3.0):

===============================

Parametername Parametervalue

Transform.Class com.sap.aii.messaging.adapter.Conversion

xml.conversionType SimplePlain2XML

xml.processFieldNames fromConfiguration

xml.fieldSeparator ;

But the transformation doesn't work. It ssems to do nothing. Which parameters are wrong or missing ??

Thanks - werner

[former_member267355]

Hi,

Check this thread, do configurations accordingly it ll work.

Regards,

Sakthi

[former_member267355]

Hi,

Yes, you can do using MessageTransformBean.

check this link

http://help.sap.com/saphelp_nw04/helpdata/en/57/0b2c4142aef623e10000000a155106/frameset.htm

Regards,

Sakthi

[Former Member]

Hi

Use adapter module development.

Check this for mail also same.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3bdc14e1-0901-0010-b5a9-a01...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/e21106cc-0c01-0010-db95-dbfc0ffd...

http://help.sap.com/saphelp_nw70/helpdata/en/4d/a3bc97ff55c742af7faed661635baf/content.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/96/f04142099eb76be10000000a155106/frameset.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/32/43d84072378031e10000000a1550b0/frameset.htm