Sender "Mail" adapter - CSV file attachment

[Former Member]

Hi there

I'm looking for some help in configuring a sender mail adapter that receives ".csv" files. I did read some blogs that mention using the "PayloadSwapBean" module to read the mail attachment instead of the mail content. My problem is to now convert the ".csv" file into a message. Is there a module that I can use ( is it the "MessageTransfomBean" ) and how. Any help would be appreciated.

Thanks

Salil

[Former Member · Accepted solution]

Hi Salil,

If you want to send a mail with a body and attachments, the message sender HAS to provide an XI message with attachments. I doubt a CSV file does justice.

As Renjith said you need to convert CSV to XmL.

A short description about the Standard Modules:

MessageTransformationBean is a standard module used to apply the XSLT mapping to the adapter module by using <i>Transform.class</i> ( This xslt mapping is done to create a mail package, Dont confuse with the actual mapping in your case this is NOT for converting csv to xml).

Also this module can be used to change the name and type of payloads by using <i>Transform.contentType</i>, <i>Transform.contentDisposition</i>, <i>Transform.contentDescription</i>.

PayloadSwapbean is a standard module for replacing payloads with other payloads (SWAP)

If you want to give each attachment a certain name use Parameters, <i>swap.keyname</i> for name of the payload and <i>swap.keyvalue</i>.

I Hope the use of standard modules is understood.

[Former Member]

Hi all

Thanks for your suggestions. Will give then a try and let you know.

Regards

Salil

[Former Member]

Hi Salil -

A similar requirement was discussed in this thread:

If you don't want to use the MessageTransformBean to convert your CSV to an XML format, you can still use java mapping to do this. But since it's the attachment, you still would need to swap the attachment first (using PayloadSwapBean) to switch it to be the main payload that your java mapping would use as the source.

Regards,

Jin

[Former Member]

One way would be to use a java mapping/abap mapping to convert the csv data in the payload to an xml message...

There may be a better way to do this if some standrad adapter modules are available...

or speaking about modules you can alsi write an adapter module which does this required conversion....

Thanks,

Renjith.