12-08-2008 9:43 AM
Hi,
Getting 'Message_Type_Unknown' error when using 'ALSM_EXCEL_TO_INTERNAL_TABLE' function module for data upload thro' excel sheet.
Why I get this error & what need to be done to rectify it?
12-08-2008 10:15 AM
can you try this
TYPE-POOLS: truxs .
DATA: it_raw TYPE truxs_t_text_data.
PARAMETER: pfile LIKE rlgrap-filename MODIF ID sc1." OBLIGATORY.
CALL FUNCTION 'F4_FILENAME'
EXPORTING
program_name = syst-cprog
dynpro_number = syst-dynnr
field_name = ' '
IMPORTING
file_name = pfile.
CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
EXPORTING
I_FIELD_SEPERATOR =
i_line_header = 'X'
i_tab_raw_data = it_raw
i_filename = pfile
TABLES
i_tab_converted_data = lt_excel[].
EXCEPTIONS
CONVERSION_FAILED = 1
OTHERS = 2
.
IF sy-subrc = 0.
MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.
12-08-2008 10:25 AM
Hi Kavitha,
When you are getting this message. Have you passed the parameters like this:
CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
EXPORTING
FILENAME = P_FILE "name of file
I_BEGIN_COL = 1 "Starting column
I_BEGIN_ROW = 2 "Starting row
I_END_COL = 17 "Ending coloumn
I_END_ROW = 3000 "Ending row
TABLES
INTERN = itab "Internal table
EXCEPTIONS
INCONSISTENT_PARAMETERS = 1
UPLOAD_OLE = 2
OTHERS = 3 .
Can you paste the code where you are getting the error. You can check the error details in ST22. might be you are assiging the wrong data type.
Sachin
12-22-2008 7:11 AM
03-03-2009 5:17 PM
Hi Kavitha,
Can you please let me know how did you resolved this issue.
i am also getting the same kind of error. Working fine for some Excel files and for some excel files it is giving the same erroe 'MESSAGE UNKNOWN"
Thanks in advance.
Regards,
Lakshma.