topic Re: Error-while executing Standard FM 'TEXT_CONVERT_XLS_TO_SAP' in Application Development and Automation Discussions

Error-while executing Standard FM 'TEXT_CONVERT_XLS_TO_SAP'

Former Member — Thu, 13 Nov 2008 09:08:12 GMT

Hi Gurus,

I'm using Standard FM 'TEXT_CONVERT_XLS_TO_SAP' ,

while executing i got an Error " Error generating test Frame'



Description:
-

Error generating the test frame
Message no. FL819

Diagnosis

The system could not generate a syntactically correct test frame for function module TEXT_CONVERT_XLS_TO_SAP. You therefore cannot test the function module using the test environment. You have probably used an ABAP feature in the interface definition that is not yet supported in the test environment.

The error message is:

"OF" expected after "TABLE".


System Response


Procedure

Check whether you can change the interface of the function module so that it is possible to generate the test frame. If this is not possible,you will have to write your own utility for testing the function module.

Procedure for System Administration

Re: Error-while executing Standard FM 'TEXT_CONVERT_XLS_TO_SAP'

Former Member — Thu, 13 Nov 2008 09:22:49 GMT

Hi,

An example of usage of fm TEXT_CONVERT_XLS_TO_SAP:


TYPE-POOLS: TRUXS.
data: trd type TRUXS_T_TEXT_DATA,
      fnm like RLGRAP-FILENAME.

data: BEGIN OF tcd OCCURS 0,
        col1(255),
        col2(255),
      END OF tcd.

fnm = 'c:\test.xls'.
CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
  EXPORTING
    i_tab_raw_data             = trd
    i_filename                 = fnm
  tables
    i_tab_converted_data       = tcd
 EXCEPTIONS
   CONVERSION_FAILED          = 1
   OTHERS                     = 2.

In the example above we get datas from two columns. You can add more to the i_tab_converted_data if required.

Regards,

Ali

Re: Error-while executing Standard FM 'TEXT_CONVERT_XLS_TO_SAP'

Former Member — Fri, 14 Nov 2008 04:44:42 GMT

Thanq Anli,

I'm using what u said senario but still i got an Error" THE TYPE TRUXS_T_TEXT_DATA UNKNOWN"

Even i declared TYPE-POOLS: TRUXS.

could u help me.

sivakumar

Re: Error-while executing Standard FM 'TEXT_CONVERT_XLS_TO_SAP'

Former Member — Fri, 14 Nov 2008 05:23:18 GMT

hai siva..

iam sending a sample prg. check it out.

it will be helpful for U to solve the problem.

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.

Re: Error-while executing Standard FM 'TEXT_CONVERT_XLS_TO_SAP'

Former Member — Tue, 02 Sep 2014 05:59:56 GMT

hi siva,

How to did u solved the problem.. i am alo getting the same problem

truxs_t_text_data is unknown...

Re: Error-while executing Standard FM 'TEXT_CONVERT_XLS_TO_SAP'

Sidhant-Acharya — Tue, 02 Sep 2014 08:55:39 GMT

declare truxs_t_text_data and pass it in FM like mentioned below.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
EXPORTING
*       I_FIELD_SEPERATOR    =
i_line_header        = abap_true
i_tab_raw_data       = lt_raw
i_filename           = p_file
TABLES
i_tab_converted_data = lt_file_data   " Data from excel file
EXCEPTIONS
conversion_failed    = 1
OTHERS               = 2.