Receiver Mail Adapter Module Parameters

[srikanthe_sapxi]

Hello PI Experts,

Can anyone pls provide me Mail adapter module parameter details for xml to txt file conversion. I have found a few but none of them are working, can you pls provide me some active links.

Thanks,

Sri

[srikanthe_sapxi]

Thanx alot guys

The issue was resolved with this link - the solution given by Gaurav Bhargava helped me in finding the solution.

Sri

[srikanthe_sapxi]

I need MAIL Adapter module transformation parameter for converting my attachment from xml to text file -

I have gone thro few forums and modified my comm channel, but still getting xml file as an output attachment  instead of a text file.

Can anyone please suggest me how to change the module parameters to covert from xml file to text.

I have added these module processing - please help.

Processing sequence

localejbs/AF_Modules/MessageTransformBean - Local Enterprise Bean - XML2Plain

sap.com/com.sap.aii.adapter.mail.app/XIMailAdapterBean - Local Enterprise Bean - Mail

Module configuration

XML2Plain - xml.endSeparator - 'nl'

XML2Plain - xml.fieldNames  - Field1,Field2,Field3

XML2Plain - xml.fieldSeparator - |                     |

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

XML2Plain - Transform.ContentDisposition - attachment;filename="extract_p.txt"

XML2Plain - Transform.ContentType - xml/plain;charset='UTF-8";name="extract_p.txt"

XML2Plain - xml.recordsetStructure - Details

Thanks,

Sri

[Former Member]

Hello,

Did u check sap help link which i have pasted above?

Cross check ur parameters i can few of the mandatory ones are missing for instance xml.conversionType?

Thanks

Amit Srivastava

[srikanthe_sapxi]

Hi Amit,

sorry for the delay. It was already mentioned in comm channel but forgot to mention it here.

[Former Member]

Hello,

>>I need to send text file as an attachment without xml strings.]

So in ur receiver adapter u are getting main message along with XML attachment and u want to pass attachment as a text file?

OR

u want to convert main xml document into text and then set the same as attachment?

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0964d7c-e66e-2910-24bb-ac535e4a5...

Thanks

Amit Srivastava

[srikanthe_sapxi]

Hi Amit,

I have to send the main xml document as a text attachment, I have done this.. but I'm getting the output attachment with xml strings, so I need to remove these strings n pass only the values..

Output what I'm getting in the attachment is:

<?xml version="1.0" encoding="UTF-8"?><ns0:MT_Emp_Rec xmlns:ns0="http://xxxxxx.com/Concur/CO/GL_EmpPay"><Record><Emp_Key>27673</Emp_Key><Emp_ID>X100170839</Emp_ID><Emp_LastName>Hardy</Emp_LastName><Emp_FirstName>Ian</Emp_FirstName><Emp_MiddleName></Emp_MiddleName><Emp_CurrencyCode>GBP</Emp_CurrencyCode>

Output what I need as an attachment is:

27673|X100170839|Handy|Ian| |GBP|UNITED KINGDOM|3600|UK08|||4002||2000|103|10|3600/100339|SPECIALIST8SALESCTSFIELD||||Astin Coups-UK Travelers||INTPROF|No|123|ABC|N|N||0001|X100170839|UK-MOLSON COORS|UK|PAYM||GB85LOYD30000200525621|LOYDGB2LCTY|GBP||

Thanks in advance,

Sri

[Former Member]

Use the module parameters.

Examples of Content Conversion Using MessageTransformBean (SAP Library - SAP Exchange Infrastructure...

Regards,

Pranav

[Former Member]

Hello,

Paste ur mail receiver channel screenshot here along with module tab?

Thanks

Amit Srivastava

[srikanthe_sapxi]

Hi,

this is what I have at present in module parameters, with this I can sent attachment but I'm getting xml stringx in output.

Can you pls help me with module parameters so that I can send the attachment without XML strings as paste in the above reply.

Thanks,

Sri

[Former Member]

Refer below link

receiver mail adapter - Payload as a Text attac... | SCN

[Former Member]

Hi ,

Use Message transformation bean  to convert from xml to csv .

http://help.sap.com/saphelp_nw04/helpdata/en/24/4cad3baabd4737bab64d0201bc0c6c/content.htm

Do you want to send the csv payload in mail body or as an attachment ?

Regards

Venkat

[srikanthe_sapxi]

Hi Venkat,

I need to send text file as an attachment without xml strings.

Thanks,

Sri

[Former Member]

Hello,

U can use Message Transform bean to convert XML into text

Examples of Content Conversion Using MessageTransformBean (SAP Library - SAP Exchange Infrastructure...

Thanks

Amit Srivastava

[Former Member]

Hi Srikanth,

Not clear with your requirement.

Can you explain your scenario detailed.

Thanks,

Satish.