t-code upload excel file to the application server

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

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?

[Former Member]

?

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

Max

[former_member156446]

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

[Former Member]

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!

[Former Member]

Hi

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

Have you all authorization to write a file there?

Max

[Former Member]

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!

[Former Member]

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

Max

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

So

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

Max