Proxy to SFTP in 7.4

[Former Member]

Hi experts

I am doing proxy to SFTP (TEXT)scenario in 7.4 singlestack

Receiver side SFTP I have used message transform bean for text format, Channel is green, files send to the SFTP server

Receiver side it is in xml instead of TEXT, Can you please help me  .

Regards,

suresh

[Former Member]

Hi experts

Thanks for ur support finally at target ,structure is in txet

Regards,

Suresh

[former_member186851]

Nice to Hear Suresh,

Please close the thread..

[former_member183908]

Hi

i am not sure if you aware of this.You no need to use additional transformation module for the FCC.If you struggle with the module please deploy the latest SFTP patch which can have standard FCC option similar to our normal FILE adapter.Please find below screens for reference.If you are on PO and has admin access you can deploy directly in java engine using deployment perspective.

Cheers

[Former Member]

[Former Member]

hi experts,

i have change according to you experts,

but at receiver side only first field is coming,idont the FIXED FIELD LENGTH,what i want to mention in place of fixed field length please advice me

Thanks,

Suresh

[Former Member]

Hello Suresh,

One mistake which I observed in your configuration is that, you need to use Module parameter as XML2Plain in case of JNDIName.

Regards,

Souvik

[vishnu_pallamreddy]

Hi Suresh,

you need to use either field fixed lengths or field separator.

[Former Member]

JNDIname is default

[Former Member]

Hi vishnu,

i have place pipe delimited in place of  field lengths other than i want change any other

[Former Member]

Yes but the module parameter used should be XML2Plain and not exit.

[vishnu_pallamreddy]

Hi Suresh,

just mention only one option xml.field Fixedlengths or xml.fieldSeperator.

if u mention xml.field Fixedlengths then pass field lengths

else

mention xml.fieldSeperator and pass value as |.

[vishnu_pallamreddy]

Suresh

did u place this parameter in CC:

Parameter value is "deployedAdapters/com.sap.aii.adapter.sftp.ra/shareable/com.sap.aii.adapter.sftp.ra"

[Former Member]

sorry vishu

can you tel clearly

[vishnu_pallamreddy]

Hi Suresh,

Sorry For what?

for JNDI ? or filed lengths?

please find the attached screen shot.

[Former Member]

only first field is coming in target

[Former Member]

Hi vishnu,

i have  place this parameter in CC:

Parameter value is "deployedAdapters/com.sap.aii.adapter.sftp.ra/shareable/com.sap.aii.adapter.sftp.ra"

[Former Member]

Hello Suresh,

Please remove ",1" from xml.recordsetStructure in "Row,1".

The reason is Row,1 means for every Row element there will be one line of all the fields mentioned in xml.Row.fieldNames. But again this implies for Row being used as a header for all those fields at every line, which means an XML format. So please remove ",1".

Regards,

Souvik

[Former Member]

I have remove"1" but faceing the same issue

[vishnu_pallamreddy]

Hi Suresh,

Please go through the below link:

[Former Member]

Hi Suresh,

one little hint in addition to Vishnu's link:

if you want to convert XML to text, you are trying it the wrong way round, as Ramkumar wrote.

You got to use conversionType StructXML2Plain.

[former_member186851]

I guess the transformation class is wrong

Try this transformation class - com.sap.aii.messaging.adapter.Conversion

[Former Member]

i have used this transformation class but faceing the same issuse ,output file in xlm not in text.

[Former Member]

kindly provide your channel configuration/module screenshot details..

[Former Member]

[Former Member]

Module being used is not correct you have to use StrictXml2PlainBean

Refer the below

Converting XML in the Receiver File/FTP Adapter to Text Format - Advanced Adapter Engine - SAP Libra...

https://help.sap.com/saphelp_nw73/helpdata/en/44/748d595dab6fb5e10000000a155369/frameset.htm

[Former Member]

SimplePlain2XML will convert text to XML