topic Re: Writing File into Application Server in Application Development and Automation Discussions

Writing File into Application Server

Former Member — Tue, 29 Jul 2008 14:24:23 GMT

Hello,

In one scenario i ve to upload a text file into the Application Server.

I know to upload the file through tcode CG3Z, but i have to upload the file through the code.

How to do that?

Please reply.

Regards,

Rahul

Re: Writing File into Application Server

Former Member — Tue, 29 Jul 2008 14:26:20 GMT

hi,

check the links,

https://www.sdn.sap.com/irj/sdn/forums

Re: Writing File into Application Server

Former Member — Tue, 29 Jul 2008 14:27:06 GMT

Firs Load the FIle to Intenal table using the Function GUI_UPLOAD.

Second :

Using

open the app file for writing using

OPEN DATASET

Now Loop the internal table

and transfer each record

Now close the File using the Close dataset.

Re: Writing File into Application Server

former_member182354 — Tue, 29 Jul 2008 14:28:22 GMT

Hi,

Open dataset, transfer file to dataset and close dataset statements will solve your purpose.

Raghav

Re: Writing File into Application Server

Former Member — Tue, 29 Jul 2008 14:28:30 GMT

if you have the data in an internal table itab, do as follows

open dataset <filename> for output in text mode.

if sy-subrc = 0.
loop at itab.
concatenate itab-field1 itab-field2 itab-field3...into v_text.
tranfer v_text to <filename>.
endloop.
close dataset <filename>.
endif.

Re: Writing File into Application Server

Former Member — Tue, 29 Jul 2008 14:29:56 GMT

Hi Rahul,

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.

Hope this helps you.

Regards,

Chandra Sekhar

Re: Writing File into Application Server

Former Member — Tue, 29 Jul 2008 14:35:56 GMT

hi check this..

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

open dataset e_file for output in text mode.

lOOP AT it_datatab......

transfer it_datatab to e_file.

ENDLOOP.

close dataset e_file.

Re: Writing File into Application Server

Former Member — Tue, 29 Jul 2008 14:39:21 GMT

Hi Rahul.

I would like to suggest a few,

UPLOAD_FILES.

This function module is usefull for both Application server as well as Presentation server.

Hope that's usefull.

Good Luck & Regards.

Harsh Dave

Re: Writing File into Application Server

Former Member — Tue, 29 Jul 2008 14:50:39 GMT

Thanks