Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

Former Member
Former Member replied

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

;

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question