topic Re: FM - GUI_UPLOAD - Uploading Junk Data in Application Development and Automation Discussions

FM - GUI_UPLOAD - Uploading Junk Data

Former Member — Mon, 07 Jul 2008 13:33:27 GMT

Hi All,

I am using FM GUI_UPLOAD, and while upload its not recognising the character, Instead it shows some Junk values in the itab. Can anyone lemme know how can this be corrected.

Many Thanks,

Simin.

Re: FM - GUI_UPLOAD - Uploading Junk Data

bpawanchand — Mon, 07 Jul 2008 13:35:12 GMT

iam not clear with your question

might be you have used the file name parameter type as string instead of that use it as RLGRAP-FILENAME

Try it out

if possible can you just post the code

Regards

Pavan

Edited by: Pavan Bhamidipati on Jul 7, 2008 3:35 PM

Re: FM - GUI_UPLOAD - Uploading Junk Data

Former Member — Mon, 07 Jul 2008 13:37:47 GMT

U can use the CODEPAGE parameter of the FM. Pass the valid code page that supports ur character set.

Regards,

Joy.

Re: FM - GUI_UPLOAD - Uploading Junk Data

vinod_vemuru2 — Mon, 07 Jul 2008 13:38:43 GMT

Hi Simin,

Which type of file u r uploading. It will work for text file.

If it is excel file then use below code to upload the data.


PARAMETERS: po_file TYPE rlgrap-filename DEFAULT 'E:test.xls'.
TYPES: BEGIN OF t_final,
          empno(10) TYPE c,
          name(30) TYPE c,
          state(25) TYPE c,
       END OF t_final.

DATA: i_tab    TYPE STANDARD TABLE OF alsmex_tabline,
      i_final  TYPE STANDARD TABLE OF t_final,
      wa_tab   TYPE alsmex_tabline,
      wa_final TYPE t_final.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR po_file.
PERFORM open_folder.

START-OF-SELECTION.
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
     EXPORTING
          filename                = po_file
          i_begin_col             = 1
          i_begin_row             = 1
          i_end_col               = 3
          i_end_row               = 65256
     TABLES
          intern                  = i_tab
     EXCEPTIONS
          inconsistent_parameters = 1
          upload_ole              = 2
          OTHERS                  = 3.

CHECK NOT i_tab[] IS INITIAL.

LOOP AT i_tab INTO wa_tab.
  CASE wa_tab-col.
    WHEN 1.
      wa_final-empno = wa_tab-value.
    WHEN 2.
      wa_final-name = wa_tab-value.
    WHEN 3.
      wa_final-state = wa_tab-value.
  ENDCASE.
  AT END OF row.
    APPEND wa_final TO i_final.
    CLEAR wa_final.
  ENDAT.
ENDLOOP.

FORM open_folder .
  DATA: li_file  TYPE TABLE OF sdokpath,
        lwa_file TYPE sdokpath.
  CLEAR: po_file, lwa_file.
  REFRESH li_file[].
  CALL FUNCTION 'TMP_GUI_FILE_OPEN_DIALOG'
       TABLES
            file_table = li_file
       EXCEPTIONS
            cntl_error = 1
            OTHERS     = 2.
  IF sy-subrc IS INITIAL.
    READ TABLE li_file INTO lwa_file INDEX 1.
    IF sy-subrc IS INITIAL.
      po_file = lwa_file-pathname.
    ENDIF.
  ENDIF.

If it is text file let me know what data u r uploading. Paste the piece of file data.

Thanks,

Vinod.

Re: FM - GUI_UPLOAD - Uploading Junk Data

Former Member — Mon, 07 Jul 2008 13:41:16 GMT

Hi ,

Are you uploading an excel file? if yes then try to upload using FM ALSM_EXCEL_TO_INTERNAL_TABLE....

regards

padma

Re: FM - GUI_UPLOAD - Uploading Junk Data

Former Member — Mon, 07 Jul 2008 13:54:08 GMT

hi....

jut check the fil type in the function module You have to give it as 'DAT' or ASC

Alo check the number of fields in the internal table in which you which you are uploading the data and the file fields.the fields should nbe in the same order and same number..just check..may b thats thats the problem.