Skip to Content

SFTP advantco adapter output in excel sheet

Hi All,

I have proxy to SFTP file scenario and the output should just show in excel.

My definition is

MT_MonthlyReport

   Records

          AttendanceText

          Absence

          Attendance

However the output in the SFTP is coming as the attached image. Also the order is not maintained. And I only want the headers not like /Records/AttendanceText

What can fix this? We are using Advatnco SFTP adapter in SAP 7.31.

Regards,

Shaibayan

pic.jpg (11.8 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Apr 23, 2015 at 09:03 AM

    Hi

    Are you using any content conversions in ADVANTCO SFTP to create excel file?If so you can use the ignore headers by choosing the SAP standard parameters addHeaderLine value = 0

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Pavan,

      Yes it is Advantco. Currently I am using Non-Conversion as Message Protocol.

      Which Protocol should I use?

      XML-Plain

      XML-CSV Simple or Structural.

      The Recordset would be MT and inside it will be addHeaderLine 0?

      Can you elaborate a bit please?

      Thanks