topic Re: GUI_UPLOAD formats in Application Development and Automation Discussions

GUI_UPLOAD formats

Former Member — Wed, 03 Nov 2010 10:10:02 GMT

Hi,

GUI_UPLOAD function only works when the ASC file contains character (.) as a decimal separator. On the other hand, date format has to be aaaammdd.

I have to upload a file that contains (,) as a decimal separator and the date format is dd/mm/aaaa. Is it possible using GUI_UPLOAD function? With UPLOAD function it works, but it has become obsolete.

Thanks in advance,

Ricard.

Re: GUI_UPLOAD formats

Former Member — Wed, 03 Nov 2010 10:46:41 GMT

GUI_UPLOAD will take the date according to the user settings defined in your USER SETTINGS. You have to pass value 'X' to this import parameter DAT_MODE of GUI_UPLOAD.

Re: GUI_UPLOAD formats

roberto_vacca2 — Wed, 03 Nov 2010 10:59:47 GMT

I don't know if you're working in background mode but you can try this method

...you can change extension as you like BIN, ASC, TXT, XLS, Etc...

Call dialog to navigate to file

CALL METHOD cl_gui_frontend_services=>file_open_dialog

EXPORTING

default_extension = '.xlsx'

file_filter = '*.xlsx'

initial_directory = 'C:\'

CHANGING

file_table = t_files <= WILL CONTAIN YOUR DATA to ELABORATE AS YOU WANT

rc = v_rcode

user_action = v_action

EXCEPTIONS

file_open_dialog_failed = 1

cntl_error = 2

error_no_gui = 3

OTHERS = 4.

IF sy-subrc <> 0.

MESSAGE e208(00) WITH 'FILE_OPEN_DIALOG'.

ENDIF.