Sender SFTP adapter

[former_member327037]

Please tell me how to approach

I am getting .xls from bank and from that i need to change the date format and delete some unwanted columns and i need to send .xls to sap AL11 folders please tell me how to approach if you have done any...sender sftp and receiver sap al11...

[iaki_vila]

Hi Sai,

You can check the module bean implemented by the SCN member Eng: https://blogs.sap.com/2014/10/21/exceltransformbean-part-1-convert-various-excel-formats-to-simple-x...

https://blogs.sap.com/2015/03/25/formatconversionbean-one-bean-to-rule-them-all/

You can ask to Eng your doubts or to install his module and to check if you need to do some changes. At least, you will not start from the starting point.

Regards.

[former_member190293]

Hi Sai!

Custom adapter module is used for maintaining reusable tasks or it's used to implement a requirement that can't be implemented by usual way.

In your case you can use java mapping as Apu has already suggested.

Regards, Evgeniy.

[former_member327037]

Please suggest me any other process other than java mapping,

is this is the process for custom module to be followed

1.in Sender cc we should use file as transport protocol and message transformation bean .xls to xml

2.in receiver cc we should use file as protocol and mtb to convert xml to .xls

Please tell me the process for pass through scenario as well with out esr i.e., .xls to .xls

[apu_das2]

Using JAVA mapping using JExcel , read the xls and convert this to xml.

Create target xml accordingly after deleting the contents and create xls in the receiver end.

You can try with custom module as well.

Thanks,

Apu

[former_member327037]

Please suggest me any other process other than java mapping,

is this is the process for custom module to be followed

1.in Sender cc we should use file as transport protocol and message transformation bean .xls to xml

2.in receiver cc we should use file as protocol and mtb to convert xml to .xls

Please tell me the process for pass through scenario as well with out esr i.e., .xls to .xls