Upload File on Application Server

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

hi for the better performance use the open dataset for output

[Clemenss]

Hi Prasad,

please try function module ARCHIVFILE_CLIENT_TO_SERVER.

Regards,

Clemens

[Former Member]

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

[Former Member]

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

[Former Member]

Hi

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

What should i do??

Madhu

[Former Member]

Comment already posted recently.

Thanks a lot.

Best Regards,

Prasad