topic Re: csv file in Application Development and Automation Discussions

csv file

Former Member — Thu, 23 Oct 2008 14:43:03 GMT

Hi ,

Can any one let me know how to upload data from CSV file.

thnks

abdul.

Re: csv file

Former Member — Thu, 23 Oct 2008 14:44:38 GMT

search before, if you know the way to upload data for another file, it will be the same. check the way youc an upload any other file, and see what you can do there to upload csv file

Re: csv file

Former Member — Thu, 23 Oct 2008 21:29:25 GMT

Maybe u can use the FM GUI_UPLOAD

Search others forums if u need more help

Regards

Gregory

Re: csv file

Former Member — Thu, 23 Oct 2008 23:00:34 GMT

You could use the function GUI_UPLOAD to fill a table with only one field like a line. Then use SPLIT to pass the data to other table, like that:


DATA: BEGIN OF t_line OCCURS 0,
        line(200),
      END OF t_line.

  call function 'GUI_UPLOAD'
  exporting
    filename                = p_path
    filetype                = 'ASC'
  tables
    data_tab                = t_line[].

LOOP AT t_line.
SPLIT t_line-line AT ','
INTO field1,
     field2,
     ...,
     fieldn.
ENDLOOP.

Re: csv file

Former Member — Thu, 23 Oct 2008 23:01:06 GMT

Hi!

Try this code, I used it in a program

PARAMETERS:

PATHFILE(128) OBLIGATORY DEFAULT 'C:\vendors.csv'.

CALL FUNCTION 'UPLOAD'

EXPORTING

FILENAME = pathfile

TABLES

DATA_TAB = i_reg

EXCEPTIONS

OTHERS = 1.

vendors.cvs ---> Is .xls file (excel)

I hope this help you.

Regards