Skip to Content
0

Sender SFTP adapter

Mar 24, 2017 at 06:02 AM

97

avatar image

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...

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Apu Das Mar 24, 2017 at 12:51 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Evgeniy Kolmakov Mar 26, 2017 at 10:06 AM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0
Iñaki Vila Mar 27, 2017 at 11:39 AM
0

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-xml-easily/

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.

Share
10 |10000 characters needed characters left characters exceeded