Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Upload File on Application Server

Former Member
0 Kudos

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

1 ACCEPTED SOLUTION

former_member188685
Active Contributor
0 Kudos

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.

8 REPLIES 8

former_member188685
Active Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

hi for the better performance use the open dataset for output

Clemenss
Active Contributor
0 Kudos

Hi Prasad,

please try function module ARCHIVFILE_CLIENT_TO_SERVER.

Regards,

Clemens

Former Member
0 Kudos

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
0 Kudos

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

0 Kudos

Hi

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

What should i do??

Madhu

Former Member
0 Kudos

Comment already posted recently.

Thanks a lot.

Best Regards,

Prasad