topic Re: Upload .CSV file from Application server to int. table. in Application Development and Automation Discussions

Upload .CSV file from Application server to int. table.

Former Member — Thu, 08 Oct 2009 12:28:17 GMT

Hi friends,

I am tring to upload the >CSV file from Application server to internal table using Open dataset. While reading the file from file path to character data type of length 1024, the entair record is not getting uploaded in to the varible but only upto the 423 characters are assigned in the varible.

Could any one please help me how to get entair record populated in to the varible.

Thanks,

Saya

Re: Upload .CSV file from Application server to int. table.

Former Member — Thu, 08 Oct 2009 12:30:54 GMT

Hi,

In the debugging mode did you check if the whole of the record is getting loaded into the variable?

Vikranth

Re: Upload .CSV file from Application server to int. table.

Former Member — Thu, 08 Oct 2009 12:50:57 GMT

Hi,

Please refer to this

Regards,

Aditya

Re: Upload .CSV file from Application server to int. table.

Former Member — Thu, 08 Oct 2009 13:23:26 GMT

Hi,

I have used same coding to upload the .CSV file and SPLIT function in my program. Please find the below coding.


Data: COL1(1000) TYPE C,
        lv_space TYPE C,
        mlen TYPE I.
  do.
    clear: COL1.
    read dataset w_legfle into COL1.
    if sy-subrc eq 0.
      if sy-index <> 1.
        SPLIT COL1 AT ','    " where comma is ur demiliter
            INTO wa_input-edate
                 lv_space
                 wa_input-refe
                 wa_input-comp
                 wa_input-seqe
                 wa_input-glacc
                 wa_input-credit
                 wa_input-amount
                 wa_input-desc
                 wa_input-glfolio
                 lv_space
                 lv_space
                 lv_space
                 wa_input-vendor
                 wa_input-desc1
                 wa_input-desc2
                 lv_space
                 wa_input-curry
                 lv_space
                 lv_space
                 lv_space
                 lv_space
                 lv_space
                 lv_space
                 wa_input-indate.

        append wa_input TO it_input.
      endif.
    else.
      exit.
    endif.
  enddo.

I have checked the value of COL1 in debug mode it has populated up the 423 character only even though the length of the records are having more that 483 char. I don't understand why it is limiting to only 423 character.

Please help me where I am missing.

Thanks,

Saya

Re: Upload .CSV file from Application server to int. table.

Former Member — Thu, 08 Oct 2009 13:28:06 GMT

May be in debugging mode there is a limitation for the total number of displayed characters in a instance. In the debugging mode give the variable as COL1(423) and check if the remaining value is wriiten or not

Re: Upload .CSV file from Application server to int. table.

Former Member — Fri, 09 Oct 2009 13:10:00 GMT

u can use

CALL FUNCTION 'KD_GET_FILENAME_ON_F4'

EXPORTING
PROGRAM_NAME = SYST-REPID
DYNPRO_NUMBER = SYST-DYNNR
FIELD_NAME = ' '
STATIC = ' '
MASK = ' '

CHANGING

file_name = P_FILE

EXCEPTIONS
MASK_TOO_LONG = 1
OTHERS = 2

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = p_file

i_begin_col = '1'

i_begin_row = '2'

i_end_col = '256'

i_end_row = '10000'

TABLES

intern = l_intern

EXCEPTIONS

inconsistent_parameters = 1

upload_ole = 2

OTHERS = 3.

IF sy-subrc NE 0.

FORMAT COLOR COL_BACKGROUND INTENSIFIED.

WRITE : / 'File Error'.

EXIT.

ENDIF.