Content Conversion for SFTP Seeburger Sender Channel

[susan_pfab]

I have a SFTP (Seeburger) SENDER channel configured, and I'm trying to convert a plain text file to XML. I know my parameters must be wrong because it's not generating anything.

I need this structure:

FileContent

-

---

FileContent (1 to unbounded)

-

---

ROW

I will have 1 FileContent->ROW for each line in the file. ROW will hold the contents of the entire file line...no separate fields. I am not using SAP's file adapter, so I don't have the Content Conversion tab. I have to do everything from the Module tab.

Processing Sequence:

1 localejbs/AF_Modules/MessageTransformBean Local Enterprise Bean mtb

2 localejbs/Seeburger/solution/sftp Local Enterprise Bean 1

Module Configuration:

mtb Transform.Class com.sap.aii.af.sdk.xi.adapter.Conversion

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

mtb xml.conversionType SimplePlain2XML

mtb xml.documentName FileContent

mtb xml.documentNamespace http://roche.com/rd/GL/PI/GE_CI002-GL/ProxyGeneric/10

mtb xml.fieldNames ROW

mtb xml.fieldSeparator '0x0D','0x0A'

mtb xml.ignoreRecordsetName true

mtb xml.missingLastFields ignore

mtb xml.processFieldNames fromConfiguration

mtb xml.recordsetStructure FileContent,*

I'm getting really confused. Is this considered a SimplePlain2XML? What do you see wrong in this configuration?

[Former Member]

Hi Susan

You need to put structure Node like xml.Row.fieldNames , xml.ROW.fieldSeparator.

Check this blog for more details.

/people/sobhithalaxmi.kata/blog/2009/07/21/cost-free-edi-integration-using-message-transformation-bean

[susan_pfab]

Structure nodes are only added to these paramters if xml.conversionType=StructPlain2XML. Are you saying I need to change this?

[susan_pfab]

I solved my own issue. I needed the following in my processing sequence:

3 localejbs/CallSapAdapter Local Enterprise Bean exit

[former_member223761]

I was also struck with strange errors after adding the module.

Errors were:

Message could not be forwarded to the JCA adapter. Reason: Channel configuration error

As the next step after the module, data has to be transferred to SAP for processing. Hence we need to end the Module sequence with

2     localejbs/CallSapAdapter     Local Enterprise Bean     entry

(this step actually comes when you create a new SFTP sender, just need to add module before this)

When it comes to SFTP receiver, after you write module you need to put

localejbs/ModuleProcessorExitBean     Local Enterprise Bean exit

and in Module Configuration,

exit     JNDIName     deployedAdapters/com.sap.aii.adapter.sftp.ra/shareable/com.sap.aii.adapter.sftp.ra    

2. Also I was very irritated now matter what I do the Recordstructure was getting created with the name "row"

for this you can use
xml.structureTitle instead of xml.recordStructure