topic Re: Read csv file from other server in Application Development and Automation Discussions

Read csv file from other server

Former Member — Wed, 28 Jul 2010 09:45:15 GMT

Hi friends,

I am using FM GUI UPLOAD for reading data from non sap server when i manualy login to this server from my pc from command prompt and then use this file path in GU UPLOAD , I am able to read file stored in this path.

But Now I want to read this file without login to this server from my pc. I have tried it by FTP Connect but I am able to list this file there , but not able to read this file.

Please advise How can I do it.

Thnaks

Re: Read csv file from other server

Former Member — Wed, 28 Jul 2010 10:38:44 GMT

Hi ,

I am not sure what you are trying to do.

transfer the the file to R3 application server using FTP CONNECT and then try read it using open dataset.

I doubt you can read the file directly after connecting to the ftp.

Regds,

Re: Read csv file from other server

Former Member — Sat, 31 Jul 2010 03:49:58 GMT

Hi Friends,

Please suggest any other idea to read the files from other server.

Regards.

Re: Read csv file from other server

Sandra_Rossi — Sat, 31 Jul 2010 15:37:23 GMT

> I am using FM GUI UPLOAD for reading data from non sap server when i manualy login to this server from my pc from command prompt and then use this file path in GU UPLOAD , I am able to read file stored in this path.

Do you mean you have an ABAP program which runs GUI_UPLOAD function module, and it is able to read a file on your PC?

> But Now I want to read this file without login to this server from my pc. I have tried it by FTP Connect but I am able to list this file there , but not able to read this file.

Do you mean you want to run this same ABAP program in background?

Or do you want to do something completely different (then I don't understand why you talked about GUI_UPLOAD), for example, do you want to use FTP client on your PC, to read files from the SAP server?

I don't understand why you can run an FTP command to list files, but you are not able to get a file. Did you check the user authorizations on the FTP server? What command did you use? What return code did you get?