topic Re: upload function(gui_upload) in Application Development and Automation Discussions

upload function(gui_upload)

Former Member — Wed, 28 Nov 2007 04:24:04 GMT

Hi ,

I am a student using IDES 4.6c. In 4.6 c IDES , for the function module gui_upload there in no option for a field separator.(has_feild_separator) . where as higher version of IDES are havin it. how will i overcome this problem , bcos this upload function is not uploading seperate feilds resp. pls help me ...!

i tried using a loop with a 'split' but its not working properly , i m gettin a dump.

Re: upload function(gui_upload)

Former Member — Wed, 28 Nov 2007 06:26:56 GMT

if it is a tab limited then save that file as an EXCEL file and use this FM <b>ALSM_EXCEL_TO_INTERNAL_TABLE</b>

see this program

&----

*& Report ZSD_EXCEL_INT_APP

&----

REPORT ZSD_EXCEL_INT_APP.

parameter: file_nm type localfile.

types : begin of it_tab1,

f1(20),

f2(40),

f3(20),

end of it_tab1.

data : it_tab type table of ALSMEX_TABLINE with header line,

file type rlgrap-filename.

data : it_tab2 type it_tab1 occurs 1,

wa_tab2 type it_tab1,

w_message(100) TYPE c.

at selection-screen on value-request for file_nm.

CALL FUNCTION 'KD_GET_FILENAME_ON_F4'

EXPORTING

PROGRAM_NAME = SYST-REPID
DYNPRO_NUMBER = SYST-DYNNR
FIELD_NAME = ' '

STATIC = 'X'

MASK = ' '

CHANGING

file_name = file_nm

EXCEPTIONS

MASK_TOO_LONG = 1

OTHERS = 2

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

start-of-selection.

refresh it_tab2[].clear wa_tab2.

file = file_nm.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = file

i_begin_col = '1'

i_begin_row = '1'

i_end_col = '10'

i_end_row = '35'

tables

intern = it_tab

EXCEPTIONS

INCONSISTENT_PARAMETERS = 1

UPLOAD_OLE = 2

OTHERS = 3

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

loop at it_tab.

case it_tab-col.

when '002'.

wa_tab2-f1 = it_tab-value.

when '004'.

wa_tab2-f2 = it_tab-value.

when '008'.

wa_tab2-f3 = it_tab-value.

endcase.

at end of row.

append wa_tab2 to it_tab2.

clear wa_tab2.

endat.

endloop.

data : p_file TYPE rlgrap-filename value 'TEST3.txt'.

OPEN DATASET p_file FOR OUTPUT IN TEXT MODE ENCODING DEFAULT.

*--- Display error messages if any.

IF sy-subrc NE 0.

MESSAGE e001(zsd_mes).

EXIT.

ELSE.

*---Data is downloaded to the application server file path

LOOP AT it_tab2 INTO wa_tab2.

TRANSFER wa_tab2 TO p_file.

ENDLOOP.

ENDIF.

*--Close the Application server file (Mandatory).

CLOSE DATASET p_file.

loop at it_tab2 into wa_tab2.

write : / wa_tab2-f1,wa_tab2-f2,wa_tab2-f3.

endloop.

Re: upload function(gui_upload)

Former Member — Thu, 29 Nov 2007 08:41:55 GMT

hi,

You can use same FM. you use file type is DAT.it will take care of filed seprater. use TAB key in keyboard between the values.

L.Velu

Re: upload function(gui_upload)

Former Member — Thu, 29 Nov 2007 13:33:42 GMT

Hi..

Wil u pls specify ur seggestion. u suggested me to use filetype as DAT . did u mean to save the flag file as DAT or to specify inside the FM .( filetype = 'dat') .

Anyways i tried both , in first case i m getting the old result(all the feilds are taken together as a single feild , with # symbol in between the fields). In second case its goin to dump.

with regards

Ragesh