Flat file to XML using SAP SFTP adapter

[former_member185881]

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 · Accepted solution]

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	;

[former_member185881]

Hello Indrajit

This is fine now right

Thanks

Dheeraj Kumar

[former_member217283]

Hi Dheeraj,

I think you need other parameter : xml.FieldsNames

Regards

Mónica