topic Re: uploading file in Application Development and Automation Discussions

uploading file

syed_ibrahim5 — Thu, 06 May 2010 14:25:18 GMT

hi,

i have to upload data through bdc... i am doing it using gui_upload...... the file is a text file....

the fields are seperated by comma......... so it is not uploading to the internal table......but when it is given with tabs it is getting uploaded......i have tried using field seperator parameter as ',' .... but it is still not working....pls help me out..

thanks in advance,

syed

Re: uploading file

Former Member — Thu, 06 May 2010 14:48:27 GMT

Hi SYED_ibbu ,

dont use field seperator parameter- try command split

split each line of the file into a string table.

uploaded line:

1,2,3

string table:

then loop at the string table and assign each line to a work area

which is of the same line type like the records in your upload file.

Regards

REA

Edited by: Ramy EL-ARNAOUTY on May 6, 2010 5:10 PM

Re: uploading file

kesavadas_thekkillath — Thu, 06 May 2010 18:44:02 GMT

types:begin of ty_line,

line type char255, ( give the size as required)

end of ty_line.

data:i_line type table of ty_line.

data:wa_line type ty_line.

Using GUI_UPLOAD upload the file to internal table i_line.

loop at i_line into wa_line.

split wa_line at ',' into wa_itab-field1 wa_itab-field2 wa_itab-field3.

append wa_itab to i_tab.

endloop.

Now i_tab will hold the data.

Re: uploading file

Former Member — Fri, 07 May 2010 08:18:56 GMT

hi keshav,

your solution becoms unclear, if you habe a lot more than 3 columns.

try this

TYPES: BEGIN OF ty_tab,
        col1 TYPE string,
        col2 TYPE string,
        col3 TYPE string,
       END OF ty_tab.

DATA data_tab TYPE TABLE OF string.
DATA itab     TYPE TABLE OF string.

DATA lt_import TYPE TABLE OF ty_tab.
DATA ls_import TYPE ty_tab.

FIELD-SYMBOLS <data> TYPE string.
FIELD-SYMBOLS <wa>   TYPE string.
FIELD-SYMBOLS <comp> TYPE ANY.

CALL FUNCTION 'GUI_UPLOAD'
  EXPORTING
    filename = 'C:\Temp\upl.txt'
    filetype = 'ASC'
  TABLES
    data_tab = data_tab.

LOOP AT data_tab
  ASSIGNING <data>.

  SPLIT <data> AT ',' INTO TABLE itab.

  LOOP AT itab
     ASSIGNING <wa>.

    ASSIGN COMPONENT sy-tabix OF STRUCTURE ls_import
      TO <comp>.

    <comp> = <wa>.

  ENDLOOP.

  APPEND ls_import TO lt_import.

ENDLOOP.

lt_import stores the uploaded records.

Regards

REA

Edited by: Ramy EL-ARNAOUTY on May 7, 2010 10:19 AM