Sender SFTP adapter configuration

[Former Member]

Dear Experts,

we have one requairement to convert CSV file to xml messages, we are using the sender SFTP adapter.

kindly let me kow, how to convert csv to xml messages.

Regards

kiran

[sahana_ps · Accepted solution]

Hi kiran kumar,

There is no FCC in SFTP.you need to use Message Transfoem Bean in Module to convert csv file to XML.Configure module parameter as below:

Transform.Class = com.sap.aii.messaging.adapter.Conversion

Transform.ContentType = text/xml;charset=utf-8

xml.conversionType = SimplePlain2XML / StructPlain2XML

xml.processFieldNames = fromConfiguration

xml.documentName = MyDocument

xml.documentNamespace = http://xi.com/DocumentTest

xml.documentNamespaceScope = root (default Value)

xml.structureTitle (SimplePlain2XML) = MyTitle

xml.recordsetName (StructPlain2XML) = MyRecordset

xml.recordsetNamespace (StructPlain2XML) = http://xi.com/RecordsetTest

xml.recordsetNamespaceScope (StructPlain2XML) = root (default Value)

xml.recordsetStructure (StructPlain2XML) = NameA,1,NameB,*,NameC,1

xml.recordsetStructureOrder (StructPlain2XML) = asc (for Ascending) / var (for Variable)

xml.allowEmptyRecordsets (StructPlain2XML) = YES / NO

xml.recordsetsPerMessage (StructPlain2XML) = * (default Value)

xml.documentSkipFirstRows (StructPlain2XML) = 0 (default Value)

xml.recordsetBeginSeparator (StructPlain2XML) = ~ (blank by default)

xml.recordsetEndSeparator (StructPlain2XML) = ~ (blank by default)

xml.keyFieldName (StructPlain2XML) = MyKey

xml.keyFieldType (StructPlain2XML) = CaseSensitiveString / Float / CaseInsensitiveString / Integer

xml.fieldNames (*) = MyKey,field-name1,field-name2

xml.fieldFixedLengths or xml.fieldSeparator (*) = 3,3,3 or ~

xml.endSeparator (*) = u2018nlu2019

xml.beginSeparator (*) = u2018nlu2019

xml. enclosureSign (*) = ~

xml.enclosureSignEnd (*) = ~

xml.enclosureSignEscape (*) = ,

xml.enclosureSignEndEscape (*) = ,

xml.enclosureConversion (*) = YES / NO

xml.checkForXMLPredefinedEntities (*) = YES / NO

xml.checkForISOControls (*) = YES / NO

xml.addBeginSeparatorAsField (*) = YES / NO

xml.addEndSeparatorAsField (*)  = YES / NO

xml.fieldContentFormatting (*) = trim (default Value), nothing

xml.keyFieldValue (*) = 001

xml. keyFieldInStructure (*) = add (default Value)

[Bhargavakrishna]

Hi Kiran,

We don't have option to use FCC in SFTP adapter, so you should use Message Transform Bean which can be configured on the module tab of communication channel to achieve your requirement.

Refer the below link for the same

Regards

Bhargava Krishna

[former_member220103]

Hi, you can refer this wiki page:

How To...Content conversion module with J2EE JMS adapter - Process Integration - SCN Wijavascript:;http://wiki.scn.sap.com/wiki/display/XI/How+To...Content+conversion+module+with+J2EE+JMS+adapterhttp://wiki.scn.sap.com/wiki/display/XI/How+To...Content+conversion+module+with+J2EE+JMS+adapter

[iaki_vila]

HI Kiran,

With SFTP i think you must use a module bean to make the conversions like MessageTransformBean (http://help.sap.com/saphelp_nw04/helpdata/en/24/4cad3baabd4737bab64d0201bc0c6c/content.htm)

Regards.

[Dimitri]

try file content conversion, but I'm not sure it is available on a SFTP adapter.