Mail to File with CSV or XML attachment

[Former Member]

Hi Experts,

I have a scenario where vendors will send the order details thru' mail attachment. this can be a xml or csv attachment. the content of the attachment will be transfer to the receiver.

Now I need help on -

1) can we use swapbean for CSV file or shall I need to convert the csv file to xml ? can we use the message transform bean here?

2) as the different vendors can send attachment either in XML or CSV format , is ther any way to check the attachment type in the adapter module level?

Thanks a Lot

Viny

[Former Member]

Hi Goyel,

You need to use both the modules if you get a csv file. If you have xml then only swap module is ok. Please check this threads which you have the necessary steps for both the inputs:

Regards,

---Satish

[Former Member]

Hi Satish,

Thanks a lot for the prompt reply.

But can you please tell me is there any way to check the attachment type in the adapter level using some module?

Thanks

Vinny

[Former Member]

Hi Vineet,

Try using getContentType () as mentioned in this blog:

/people/yugapreetha.t/blog/2009/08/24/read-the-attachments-of-the-input-xi-message-in-the-message-mapping

Regards,

---Satish