Sender Mail Adapter - Module conversion issue.

[Former Member]

Hello all,

We had a issue in reading the details in Email body ( PS - Reading details from Email body. Not from Attachment )

Email from one of our customer looks like below . We use IMAP as Transport protocol

From: XXX XXXX XXXX [mailto:XXX_XXXX@XXXXX.com]
Sent: 21 October 2015 11:30
To: Rama
Subject: RE: ASN - 9999

Automated Email response:

Please find below the document number created in our system with reference to your ASN.

ASN: 9999

Customer Ref: 0009990011

Please quote the Customer Reference number in all correspondence.

***************************************************************
The contents of this Email and any files transmitted with it
are confidential and intended solely for the use of the
individual or entity to whom it is addressed. The views stated
herein do not necessarily represent the view of the company.
If you are not the intended recipient of this Email you may not
copy, forward, disclose or otherwise use it or any part of it
in any form whatsoever. If you have received this mail in
error please Email the sender.
***************************************************************

XYZ PLC.

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________

EXPECTED Output XML message ( Data types

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_TEST_ASNNO xmlns:ns0="http://abc/pi/test">

  <Recordset>

        <Vendor_ASN_NO>

           <Key>ASN: </Key>

            <VND_ASN_NO>9999</VND_ASN_NO>

       </Vendor_ASN_NO>

       <Cust_ASN_NO>

            <Key>Customer Ref: </Key>

            <Cust_ASN_NO>0009990011</Cust_ASN_NO>

       </Cust_ASN_NO>

  </Recordset>

</ns0:MT_TEST_ASNNO>

Please suggest the module configuration settings that we can use to achieve this scenario.

I have used below module configuration to read data from an csv attachment. But scenario I want to achieve is completely different now. 

Processing Sequence.

Number	Module Name	Type	Module Key
1	localejbs/AF_Modules/PayloadSwapBean	Local Enterprise Bean	TRANSFORM
2	localejbs/AF_Modules/MessageTransformBean	Local Enterprise Bean	set
3	localejbs/AF_Modules/MessageTransformBean	Local Enterprise Bean	txtxml
4	localejbs/sap.com/com.sap.aii.adapter.mail.app/XIMailAdapterBean	Local Enterprise Bean	mail

Module config

Module Key	Parameter Name	Parameter Value
TRANSFORM	swap.keyName	payload-name
TRANSFORM	swap.keyValue	MailAttachment-1
set	Transform.ContentDescription	MailAttachment-1
set	Transform.ContentDisposition	attachment;filename="MailAttachment-1.bin"
set	Transform.ContentType	application/octet-stream;charset="ISO-8859-1"
txtxml	Transform.Class com.sap.aii.messaging.adapter.Conversion
txtxml	xml.conversionType	SimplePlain2XML
txtxml	xml.documentName	MT_TEST2_ZVIP
txtxml	xml.documentNamespace	urn://XYZ.com/PI/TEST_2/00
txtxml	xml.fieldFixedLengths	3,1,5
txtxml	xml.fieldNames	Data_1,Data_2,Data_3
txtxml	xml.lastFieldsOptional	YES
txtxml	xml.processFieldNames	fromConfiguration

[radek_rucinski · Accepted solution]

Hi,

Instead of trying to convert the message using adapter module I would read the message using standard configuration and then extract required values in the message mapping (for example with UDF) or XSLT from the Content field.

You will need XSD for the mail message: https://websmp205.sap-ag.de/~sapidb/012006153200000361852004E/ximail30_xsd.txt

Communication Channel settings:

Message payload:

Regards,

Radek

[Former Member · Accepted solution]

Hi Radek,

Thanks your Idea helps me to achieve my results.