Read excel file Mail adapter

[former_member194677]

Hi Experts,

I have used Custom module to read Excel and the message is successful in CC. but failed in Moni.

The mail attachment is coming as excel in moni but when tried to open i can see the message in XML tags.

My mapping is getting failed . Please help with your value inputs.

[anupam_ghosh2]

Hi Santosh,

                     Excel file ------> adapter modele------> XML message-----> Integration engine.

This should be the process.If the adapter module is  not producing valid XML then mappings will fail.

If you post the exact error message you are receiving, then perhaps forum memebers will be able to suggest solution to the issue.

Regards

Anupam

[former_member194677]

Hi Anupam,

Thanks for the response.

It seems the custom module is working fine since the message is successful in CC and the audit log says the message is converted to XML message.

In the payload the Mail Attachment-1 is with the excel attachement.

The exact issues is the XML message is generated in the excel file and i am getting mapping exception in Moni.

I am using the below setting in module configuration.

swap.keyName  Content-Disposition

  swap.keyName  Content-Description

  swap.keyValue  attachment,filename="MailAttachment-1.xls"

  swap.keyValue  MailAttachment-1

msgtype          ***

namespace          ******

Please let me know  if there is any change.

[anupam_ghosh2]

Hi Santosh,

                    Please extarct the inbound xml payload to sxmb_moni.

Try opening the xml payload in web browser. Check if this gives you any error.

Regards

Anupam