topic Re: Regarding Path Selection for Exporting File in Application Development and Automation Discussions

Regarding Path Selection for Exporting File

Former Member — Tue, 13 Jan 2009 09:35:23 GMT

Hi Experts..

I want to export my program output to EXCEL shett But I need to provide a parameter options for user selection. Means user can select his own path..

Reply soon...

BYe

Re: Regarding Path Selection for Exporting File

Former Member — Tue, 13 Jan 2009 09:40:18 GMT

Hi ,

U can use the following code.

data: v_rc type i.

data: lt_filetab type filetable.

data: ls_filetab like line of lt_filetab.

parameters: p_file type localfile.

at selection-screen on value-request for p_file.

call method cl_gui_frontend_services=>file_open_dialog

changing

file_table = lt_filetab

rc = v_rc

exceptions

file_open_dialog_failed = 1

cntl_error = 2

error_no_gui = 3

not_supported_by_gui = 4

others = 5.

read table lt_filetab into ls_filetab index 1.

if sy-subrc = 0.

p_file = ls_filetab-filename.

endif.

Now pass the file name to gui_upload method

Re: Regarding Path Selection for Exporting File

Former Member — Tue, 13 Jan 2009 09:40:49 GMT

Hi,

Try using the following code.

parameters: p_pcfile like rlgrap-filename default 'c:\test.xls'.

at selection-screen on value-request for p_pcfile.

call function 'KD_GET_FILENAME_ON_F4'

exporting

mask = '.'

static = 'X'

changing

file_name = p_pcfile.

Thanks,

Srilakshmi.

Re: Regarding Path Selection for Exporting File

SujeetMishra — Tue, 13 Jan 2009 09:40:53 GMT

Hello Ruchit,

Please try to use below code:.

PARAMETERS: p_file type RLGRAP-filename,

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

PROGRAM_NAME = SYST-CPROG

DYNPRO_NUMBER = SYST-DYNNR

IMPORTING

FILE_NAME = p_file

Hope it will solve your problem.

Have a Nice Day.

regards,

Sujeet

Re: Regarding Path Selection for Exporting File

Former Member — Tue, 13 Jan 2009 09:41:40 GMT

Define a parameter first:

PARAMETERS: INFILE like rlgrap-filename . " Input file

Then:

AT SELECTION-SCREEN ON VALUE-REQUEST FOR INFILE.

DATA: FILE LIKE RLGRAP-FILENAME.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

PROGRAM_NAME = SYST-CPROG

DYNPRO_NUMBER = SYST-DYNNR

FIELD_NAME = ' '

IMPORTING

FILE_NAME = FILE.

Re: Regarding Path Selection for Exporting File

Former Member — Tue, 13 Jan 2009 09:42:41 GMT

Hi,

Use this logic.


AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.
*CALL METHOD cl_gui_frontend_services=>file_open_dialog
  CHANGING
    file_table              = lt_filetab
    rc                      = l_rc
  EXCEPTIONS
    file_open_dialog_failed = 1
    cntl_error              = 2
    error_no_gui            = 3
    not_supported_by_gui    = 4
    OTHERS                  = 5

READ TABLE lt_filetab INTO lw_filetable INDEX 1.
if sy-subrc = 0.
  l_filename = lw_filetable-filename.  " file name.
endif.

regards,

Santosh

Re: Regarding Path Selection for Exporting File

Former Member — Tue, 13 Jan 2009 09:44:01 GMT

Hi,

See the following code.

selection-screen begin of block input with frame title text-000.

parameters :desktop radiobutton group rg_f user-command rg_f,

in_file type ibipparms-path modif id ps,

menu radiobutton group rg_f,

sys_file type ibipparms-path modif id as default '/sapia/iface/in/comm/sapfin/' .

selection-screen end of block input.

at selection-screen on value-request for in_file.

call function 'KD_GET_FILENAME_ON_F4'

exporting

mask = ',CSV,*.csv,'

changing

file_name = in_file.

in your fm gui_download give the filepath (here IN_FILE) as filename.

Hope this will help u.

Thanks.

Re: Regarding Path Selection for Exporting File

Former Member — Tue, 13 Jan 2009 09:45:01 GMT

use FM, KD_GET_FILENAME_ON_F4

Refer this link also,

Hope it helps you.

Re: Regarding Path Selection for Exporting File

Former Member — Tue, 13 Jan 2009 10:42:45 GMT

Hi Experts..

Thanks for your reply...... But in GUI_DOWNLAOD FM what should i write in field filename ?

Re: Regarding Path Selection for Exporting File

Mohamed_Mukhtar — Tue, 13 Jan 2009 10:56:02 GMT

hi,

PARAMETERS : p_upload TYPE rlgrap-filename.
DATA :  lv_path TYPE string.
AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_upload.
CALL FUNCTION 'F4_FILENAME'
    IMPORTING
      file_name = p_upload.

START-OF-SELECTION.
 lv_path = p_upload.

  CALL FUNCTION 'GUI_UPLOAD'
    EXPORTING
      filename                = lv_path "------> file name

Thanks & Regards