cancel
Showing results for 
Search instead for 
Did you mean: 

SFTP advantco adapter output in excel sheet

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member183908
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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