Skip to Content
avatar image
Former Member

Flat file to XML using SAP SFTP adapter

Hello All

I am trying to convert flat file to xml using SAP SFTP adapter.

Flat File is like below:

AABEN;20141106;20141106;45;0.00

AABOL;20141106;20141106;45;0.00

ABGRI;20141106;20141106;45;0.00

ADDEA;20141106;20141106;45;0.00

ALADA;20141106;20141106;45;58.43

AMSCH;20141106;20141106;45;0.00

ANOLV;20141106;20141106;45;0.00

ANROY;20141106;20141106;45;0.00

AVMCD;20141106;20141106;45;0.00

Message Type structure I created like below

In Server SFTP adapter in Module tab I am using "AF_Modules/MessageTransformBean" and conversion type ="StructPlain2XML"

I am getting error = "Error: com.sap.aii.af.sdk.xi.adapter.trans.TransformException: Transformer Conversion3.0.5226 Error initializing Class: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found (4408) Parameter 'xml.keyFieldName' is missing (4403) Parameter 'xml.keyFieldType' is missing (4403) ; nested exception caused by: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found (4408) Parameter 'xml.keyFieldName' is missing (4403) Parameter 'xml.keyFieldType' is missing (4403) "

I am not using any key field then please let me know how to overcome this issue.

I searched on SDN but did not get any perfect answer.

Thanks

Dheeraj Kumar

1a.PNG (5.0 kB)
1b.PNG (7.4 kB)
1c.PNG (19.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 08, 2015 at 12:03 PM

    Hi Dheeraj

    First of all do not mark this post as assumed answered because people will think that it is already

    resolved.

    Instead of struct plain to xml use simple plain xml

    input file example

    AAA;BBB;CCC

    111;222;333

    ouput xml

    <ns:Document xmlns:ns="http://xi.com/test">

    <Title>

    <field-name1>AAA</field-name1>

    <field-name2>BBB</field-name2>

    <field-name3>CCC</field-name3>

    </Title>

    <Title>

    <field-name1>111</field-name1>

    <field-name2>222</field-name2>

    <field-name3>333</field-name3>

    </Title>

    </ns:Document>

    Specifications in the Module Configuration of Module Pocessor

    Module Key

    Parameter Name

    Parameter Value

    Plain2XML

    Transform.Class

    com.sap.aii.messaging.adapter.Conversion

    Plain2XML

    Transform.ContentType

    text/xml;charset=utf-8

    Plain2XML

    xml.conversionType

    SimplePlain2XML

    Plain2XML

    xml.processFieldNames

    fromConfiguration

    Plain2XML

    xml.documentName

    Document

    Plain2XML

    xml.documentNamespace

    http://xi.com/test

    Plain2XML

    xml.structureTitle

    Title

    Plain2XML

    xml.fieldNames

    field-name1,field-name2,field-name3

    Plain2XML

    xml.fieldSeparator

    ;

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 12:08 PM

    Hi Dheeraj,

    I think you need other parameter : xml.FieldsNames

    Regards

    Mónica


    Captura.JPG (25.1 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 08, 2015 at 12:15 PM

    Hello Indrajit

    This is fine now right 😊

    Thanks

    Dheeraj Kumar

    Add comment
    10|10000 characters needed characters exceeded