2009 Mar 02 7:09 AM
Hi All,
I am using class cl_gui_frontend_services=>gui_upload, to upload an excel file for ASCII as well as for DAT format.
I am passing the following parameters to the method :
IF ascii EQ 'X'.
CALL METHOD cl_gui_frontend_services=>gui_upload
EXPORTING
filename = gv_filename
filetype = 'ASC'
has_field_separator = space
CHANGING
data_tab = inputdata_itab
EXCEPTIONS
file_open_error = 1
file_read_error = 2
no_batch = 3
gui_refuse_filetransfer = 4
invalid_type = 5
no_authority = 6
unknown_error = 7
bad_data_format = 8
header_not_allowed = 9
separator_not_allowed = 10
header_too_long = 11
unknown_dp_error = 12
access_denied = 13
dp_out_of_memory = 14
disk_full = 15
dp_timeout = 16
not_supported_by_gui = 17
error_no_gui = 18
others = 19
ELSEIF dat EQ 'X'.
CALL METHOD cl_gui_frontend_services=>gui_upload
EXPORTING
filename = gv_filename
filetype = 'DAT'
has_field_separator = 'X'
CHANGING
data_tab = inputdata_itab
EXCEPTIONS
file_open_error = 1
file_read_error = 2
no_batch = 3
gui_refuse_filetransfer = 4
invalid_type = 5
no_authority = 6
unknown_error = 7
bad_data_format = 8
header_not_allowed = 9
separator_not_allowed = 10
header_too_long = 11
unknown_dp_error = 12
access_denied = 13
dp_out_of_memory = 14
disk_full = 15
dp_timeout = 16
not_supported_by_gui = 17
error_no_gui = 18
others = 19.
endif.
In both the cases it is giving junk characters in the inetrnal table 'inputdata_tab'.
I tried without using the separator also but still sam eerror.
Can anyone please help me out of this.
Thanks in Advance.
Sunanda.
check the strucure of ur internal table,
the input file structure must same as the internal table
2009 Mar 02 7:13 AM
Hi Sunanda,
Kindly go through this link below link, have posted one wiki on this topic:
Hope it helps
Regrds
Mansi
2009 Mar 02 7:15 AM
hi,
You an convert data to ASCII using the function module QADB_DOCU_CONVERT_TO_ASCII.
CALL METHOD cl_gui_frontend_services=>gui_upload
EXPORTING
filename = 'C:\temp\text.xls'
filetype = 'ASC'
has_field_separator = '|'
CHANGING
data_tab = itab
IF sy-subrc = 0.
WRITE:/ 'success'.
ENDIF.
thanks
2009 Mar 02 7:22 AM
check the strucure of ur internal table,
the input file structure must same as the internal table
| User | Count |
|---|---|
| 6 | |
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |