topic Re: Problem with FTP_R3_TO_SERVER function module while downloading excel sheet in background in Application Development and Automation Discussions

Problem with FTP_R3_TO_SERVER function module while downloading excel sheet in background

pbabitha — Tue, 11 Dec 2018 06:01:07 GMT

Hi All,

I have created a zreport to download equipment details into excel sheet while running background.I have used the following function modules to download excel file into FTP path

HTTP_SCRAMBLE

FTP_CONNECT

FTP_R3_TO_SERVER

FTP_DISCONNECT

RFC_CONNECTION_CLOSE

But it is downloading internal table row into single cell and also when i try to download multiple rows it is not downloading correct data. I have passed blob_length as 122 * 30 and blob as internal table.

Please help me out to solve this issue as it is an urgent requirement.

Thanks & Regards,

Babitha

Re: Problem with FTP_R3_TO_SERVER function module while downloading excel sheet in background

Tomas_Buryanek — Tue, 11 Dec 2018 07:58:11 GMT

1) I think you are not creating "Excel sheet" but simple text file? Is it tab delimited, or CSV, or...?

2) I recommend to use FTP_R3_TO_SERVER in its binary (default) mode. I.E. work with binary data. And every time you work with binary data in internal table (BLOB), you need to know its size (fill it into BLOB_LENGTH parameter).

Re: Problem with FTP_R3_TO_SERVER function module while downloading excel sheet in background

pbabitha — Thu, 13 Dec 2018 07:03:59 GMT

Thanks Tomas,

I have made it as tab delimited file and it got successfully downloaded into text file and i am working on excel file download following your points.

Regards,

Babitha

Re: Problem with FTP_R3_TO_SERVER function module while downloading excel sheet in background

srikanthnalluri — Thu, 13 Dec 2018 14:25:39 GMT

Check the standard program - RSFTP007, it may help you.