topic Re: GUI_UPLOAD in Application Development and Automation Discussions

GUI_UPLOAD

Former Member — Thu, 23 Feb 2006 01:28:12 GMT

Hi all,

I am trying to upload data from flat file to internal table using GUI_UPLOAD. The data in the file is tab delimited. what should I specify in the <b>HAS_FIELD_SEPARATOR</b>. I am forwarding my code too.

REPORT Z_FILE_READ.

data : begin of itab occurs 0,

carrid like sflight-carrid,

connid like sflight-connid,

end of itab.

data f_name type string value

'C:\Documents and Settings\Guest\Desktop\Book1'.

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = 'C:\BW\Book1.txt'

FILETYPE = 'ASC'

HAS_FIELD_SEPARATOR = ' '

READ_BY_LINE = 'X'

tables

data_tab = itab.

write 'vijay'.

Regards,

Varun.

Re: GUI_UPLOAD

RichHeilman — Thu, 23 Feb 2006 01:31:34 GMT

The value for that parameter is either space or "X". The system will handle the rest. Not sure if it will work on tab delimited or not.

Regards,

Rich Heilman

Re: GUI_UPLOAD

Former Member — Thu, 23 Feb 2006 01:34:05 GMT

Hi Rich,

Now I changed the value to X and in the input file I gave the seperator as ,(comma). But it still doesn't work properly.If not this FM what is the best way to upload data from file to internal table ?

Regards,

Varun.

Message was edited by: varun sonu

Re: GUI_UPLOAD

Former Member — Thu, 23 Feb 2006 01:37:26 GMT

Try this code -

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = gd_file

has_field_separator = 'X' "file is TAB delimited

TABLES

data_tab = it_record

EXCEPTIONS

file_open_error = 1

file_read_error = 2

no_batch = 3

gui_refuse_filetransfer = 4

invalid_type = 5

no_authority = 6

unknown_error = 7

bad_data_format = 8

header_not_allowed = 9

separator_not_allowed = 10

header_too_long = 11

unknown_dp_error = 12

access_denied = 13

dp_out_of_memory = 14

disk_full = 15

dp_timeout = 16

OTHERS = 17.

IF sy-subrc NE 0.

write: 'Error ', sy-subrc, 'returned from GUI_UPLOAD FM'.

skip.

endif.

Re: GUI_UPLOAD

Former Member — Thu, 23 Feb 2006 01:38:23 GMT

Hi Varun,

You can use FM WS_UPLOAD or UPLOAD.Though it says obselate,you can still use them.

Re: GUI_UPLOAD

RichHeilman — Thu, 23 Feb 2006 01:39:27 GMT

Hi, I have created an tab delimited file and a test program. I have set the parameter to "X". It is working good for me. Create a tab delimited text file in notepad and save as .txt file. It should work.

report  zrich_0001.

data: begin of itab occurs 0,
      fl1(10) type c,
      fl2(10) type c,
      fl3(10)  type c,
      end of itab.

call function 'GUI_UPLOAD'
  exporting
    filename            = 'C:test.txt'
    filetype            = 'ASC'
    has_field_separator = 'X'
  tables
    data_tab            = itab.

loop at itab.

  write:/ itab-fl1, itab-fl2, itab-fl3.
endloop.

Regards,

Rich Heilman

Re: GUI_UPLOAD

Former Member — Thu, 23 Feb 2006 01:45:43 GMT

Hi all,

The previous two did not work out for me. when I use ws_upload the result is same. But when Iused If sy-subrc is 0.Guys you might have worked in real time. When you do call transaction or session ow do you upload data from flat file to internal table ? My purpose is also same.

Regards,

Varun.

Re: GUI_UPLOAD

Former Member — Thu, 23 Feb 2006 01:48:23 GMT

Hi Rich,

Thank you Its working.

Regards,

Varun.

Re: GUI_UPLOAD

RichHeilman — Thu, 23 Feb 2006 01:49:42 GMT

Good, I'm glad that it worked out.

REgards,

Rich Heilman

Re: GUI_UPLOAD

Former Member — Mon, 27 Oct 2008 06:40:03 GMT

i test the program,but it can not upload files include chinese chararcter.how can i upload chinese characters?