Skip to Content
avatar image
Former Member

Sender SFTP adapter

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Mar 24, 2017 at 12:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Mar 26, 2017 at 10:06 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Mar 27, 2017 at 11:39 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded