topic Re: Error generating Function Module 'TEXT_CONVERT_XLS_TO_SAP' in Application Development and Automation Discussions

Error generating Function Module 'TEXT_CONVERT_XLS_TO_SAP'

Former Member — Mon, 01 Dec 2008 11:06:36 GMT

Hi All,

When i am executing the FM 'TEXT_CONVERT_XLS_TO_SAP' i am getting the error Error generating the test frame.

Can you please tell me how to execute the FM.

Thanks & Regards,

Vivek Agarwal

Re: Error generating Function Module 'TEXT_CONVERT_XLS_TO_SAP'

Former Member — Mon, 01 Dec 2008 11:15:35 GMT

'i_tab_raw_data' should be of type 'truxs_t_text_data'. Please add 'TYPE-POOLS: truxs.' statement in your code. Structure of 'i_tab_converted_data' should match with your input excel file.

Regards,

Aparna.

Re: Error generating Function Module 'TEXT_CONVERT_XLS_TO_SAP'

Former Member — Mon, 01 Dec 2008 11:16:43 GMT

Refer This LInk

Ranga

Re: Error generating Function Module 'TEXT_CONVERT_XLS_TO_SAP'

Former Member — Mon, 01 Dec 2008 11:17:30 GMT

Hello...

Iam sending a sample code.

Hope it will helps U how to deal with FM : TEXT_CONVERT_XLS_TO_SAP.

TYPE-POOLS : TRUXS.

TYPES : BEGIN OF TY_TAB,

F1(10) TYPE C,

F2(10) TYPE C,

F3(10) TYPE C,

END OF TY_TAB.

DATA : WA_TAB TYPE TY_TAB,

LT_TAB LIKE STANDARD TABLE OF WA_TAB.

DATA : I_TAB_RAW_DATA TYPE TRUXS_T_TEXT_DATA.

DATA : FNAM TYPE IBIPPARMS-PATH.

PARAMETER : P_FNAM TYPE RLGRAP-FILENAME.

*****

AT SELECTION-SCREEN ON VALUE-REQUEST FOR P_FNAM.

CALL FUNCTION 'F4_FILENAME'

IMPORTING

FILE_NAME = FNAM

P_FNAM = FNAM.

*****

START-OF-SELECTION.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_TAB_RAW_DATA = I_TAB_RAW_DATA

I_FILENAME = FNAM

TABLES

I_TAB_CONVERTED_DATA = LT_TAB.

LOOP AT LT_TAB INTO WA_TAB.

WRITE 😕 WA_TAB-F1, WA_TAB-F2.

ENDLOOP.

**********

But my suggestion is why cant you use FM : ALSM_EXCEL_TO_INTERNAL_TABLE

instead of TEXT_CONVERT_XLS_TO_SAP.

The performance can be improved much by ALSM... FM.

Thanks and Regards

Sekhar.C

Re: Error generating Function Module 'TEXT_CONVERT_XLS_TO_SAP'

Former Member — Mon, 01 Dec 2008 11:18:59 GMT

TYPE-POOLS: truxs.

DATA: it_raw TYPE truxs_t_text_data.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_file.

CALL FUNCTION 'F4_FILENAME'

EXPORTING

field_name = 'P_FILE'

IMPORTING

file_name = p_file.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

I_FIELD_SEPERATOR =

i_line_header = 'X'

i_tab_raw_data = it_raw

i_filename = p_file

TABLES

i_tab_converted_data = i_XCEL[]

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.

Re: Error generating Function Module 'TEXT_CONVERT_XLS_TO_SAP'

Former Member — Mon, 01 Dec 2008 11:20:31 GMT

check this link

Regards,

Ajay

Re: Error generating Function Module 'TEXT_CONVERT_XLS_TO_SAP'

Former Member — Mon, 01 Dec 2008 11:32:53 GMT

HI Ajay,

Do not execute this function module directly through SE37. If you do so it will through error.

Call this functionmodule directly in the program. and make sure that number of fileds in excel sheet and internal tablefileds(i_xls internal table below) must be same.

DATA: l_c(4096) TYPE c OCCURS 0.

REFRESH i_xls.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

i_line_header = 'X'

i_tab_raw_data = l_c

i_filename = 'D:\test.xls'

TABLES

i_tab_converted_data = i_xls

EXCEPTIONS

conversion_failed = 1

OTHERS = 2.

Regards,

vinod

Re: Error generating Function Module 'TEXT_CONVERT_XLS_TO_SAP'

Former Member — Fri, 30 Jan 2009 04:52:53 GMT

Thank you all