topic Upload File on Application Server in Application Development and Automation Discussions

Upload File on Application Server

Former Member — Wed, 23 Jul 2008 14:57:07 GMT

Could anyone give me the TCode for upload Excel file from Presentation Server to Appication Server.

I have tried with 'CG3Z'; but, some garbage values gets uploaded due to this.

If I try to upload Tab delimited file instead of Excel, it uploads correctly.

So, cann't we upload Excel directly.

Please let me know. waiting for ur replies.

Best Regards,

Prasad

Re: Upload File on Application Server

Former Member — Wed, 23 Jul 2008 15:05:24 GMT

May be you can see some # 's isn't it.

Upload some commad delimited or Tab delimited file

Save the excel file as Tab delimited or Comma delimited file(CSV)

and upload.

Re: Upload File on Application Server

Former Member — Wed, 23 Jul 2008 15:16:01 GMT

Hi,

This is because the conversion to excel cannot be done when you store in the application server. So the only way you can store an excel file is by storing the file in the application server as a BIN file and not ASC file through CG3Z.

The reason for this is there is no application in the app server which can convert the OLE format to internal table. This will cause the program to dump.

Hope this clarifies your question.

Regards,

Hari

Re: Upload File on Application Server

Former Member — Wed, 23 Jul 2008 15:19:58 GMT

hi for the better performance use the open dataset for output

Re: Upload File on Application Server

Clemenss — Wed, 23 Jul 2008 16:18:06 GMT

Hi Prasad,

please try function module ARCHIVFILE_CLIENT_TO_SERVER.

Regards,

Clemens

Re: Upload File on Application Server

Former Member — Wed, 23 Jul 2008 21:16:41 GMT

Hi,

Save the excel file as Tab delimited, and use the FM: GUI_UPLOAD.

DATA: i_file like rlgrap-filename value '/usr/sap/tmp/file.txt'.

DATA: begin of it_datatab occurs 0,

row(500) type c,

end of it_datatab.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = i_file

filetype = 'ASC'

has_field_separator = 'X'

TABLES

data_tab = it_datatab "ITBL_IN_RECORD[]

EXCEPTIONS

file_open_error = 1

OTHERS = 2.

Regards,

Bhaskar

Re: Upload File on Application Server

Former Member — Tue, 05 Aug 2008 06:32:54 GMT

Dear all,

Many thanks for all ur replies.

I have saved the Excel as TAB delimited file and uploaed on Appl. Service using standard Transaction 'CG3Z'.

sO, my problem is solved.

Thanks a lot agaian.

Kind Regards,

Prasad

Re: Upload File on Application Server

Former Member — Tue, 05 Aug 2008 06:33:47 GMT

Comment already posted recently.

Thanks a lot.

Best Regards,

Prasad

Re: Upload File on Application Server

Former Member — Tue, 25 Mar 2014 05:02:52 GMT

I tried the T Code CG3Z but it says that T Code does not exists.

What should i do??

Madhu