topic Re: t-code upload excel file to the application server in Application Development and Automation Discussions

t-code upload excel file to the application server

Former Member — Mon, 21 Dec 2009 17:52:28 GMT

Hi,

I want to upload excel file from desktop to application in a specific folder. Is there any tcode to do that? Thanks!

Best Regards,

Anthony

Edited by: Anthony Pham on Dec 21, 2009 6:52 PM

Re: t-code upload excel file to the application server

Former Member — Mon, 21 Dec 2009 18:00:08 GMT

It depends on which your realese is, there are the trx CG3Y and CG3Z in order to copy a file from/to Presentation/Application,

Max

Re: t-code upload excel file to the application server

Former Member — Mon, 21 Dec 2009 18:25:37 GMT

Thanks for reply!

When I use the t-code CG3Z, it always asked for file in the application, I just want to upload file from presentation server to App. server, not override a file in application server. How does this work?

Re: t-code upload excel file to the application server

Former Member — Mon, 21 Dec 2009 18:30:21 GMT

CG3Z is to upload a file to Application from Presentation, anyway if the file just exists in Application: it'll be overwritten.

Max

Re: t-code upload excel file to the application server

former_member156446 — Mon, 21 Dec 2009 18:30:22 GMT

use cg3y :

application source :

D:\usr\sap\ECC\SYS\global\substanc\file.xls

target:

c:\temp\filename.xls

do not check the over write file checkbox

Re: t-code upload excel file to the application server

Former Member — Mon, 21 Dec 2009 18:43:10 GMT

It seem to by simple I specified the file as follows:

Source file on front-end:

c:\temp\file.xls

Target file on application server:

/usr/sap/dev/file.xls

It says: "Cannot open file /usr/sap/dev/file.xls"

If I remove the file name from the Target file on application server: it says the same: "Cannot open file /usr/sap/dev/()"

Do I need to do anything else? Thanks!

Re: t-code upload excel file to the application server

Former Member — Mon, 21 Dec 2009 18:54:07 GMT

Are you sure the path /usr/sap/dev/ exists?

Have you all authorization to write a file there?

Max

Re: t-code upload excel file to the application server

Former Member — Mon, 21 Dec 2009 19:22:19 GMT

I can confirm that the directory exists because when i use the tcode AL11 I can see it browse it and see the files there.

For the authorization issue, how do I check it whether I have authorization to write a file to that folder or not? Thanks!

Re: t-code upload excel file to the application server

Former Member — Mon, 21 Dec 2009 19:26:16 GMT

After running the trx CG3Z, run the trx SU53 in order to get the autorization missing

Max

Re: t-code upload excel file to the application server

Former Member — Mon, 21 Dec 2009 19:29:41 GMT

Yes I have no authorization issue because in the section "authorization check failed" there is nothing there. What else should I check? Thanks!

Re: t-code upload excel file to the application server

Former Member — Mon, 21 Dec 2009 19:39:59 GMT

Uhm.....

Have u try to write a little report in order to write a file there? just only few lines:

OPEN DATASET...........................

WRITE SY-SUBRC.

Just only to check the value of SY-SUBRC....u can try to check it in debug of course, because it's strange your situation.

Max

Re: t-code upload excel file to the application server

Former Member — Mon, 21 Dec 2009 21:03:08 GMT

Thank you for your helps! I changed to another folder and it works.

Re: t-code upload excel file to the application server

Former Member — Mon, 21 Dec 2009 21:08:57 GMT

It means it can write a file there....

Max