topic Re: ecatt in Application Development and Automation Discussions

ecatt

Former Member — Mon, 25 Feb 2008 13:19:12 GMT

Hi experts,

I want to upload the data from excel file to ecatt.I can upload from notepad but i cant do in excel file.help me please.

Thank u,

Manjula devi.

Re: ecatt

Former Member — Mon, 25 Feb 2008 13:24:51 GMT

there is no procedure to upload data from excel file to ecatt... If u want to upload data from excel u need to use abap program and upload data and then post data using BDC.

better option is u need to convert the excel file to tab delimited file and then upload using ecatt.

or else just check whether u can use .csv file

Re: ecatt

Former Member — Mon, 25 Feb 2008 13:48:56 GMT

I think you are Step 2 of below blog,

http://www.sapdevelopment.co.uk/testing/ecatt.htm

Ok please find the code below,

DO (COUNT).

ABAP.


DATA : V_READINDX TYPE I,
FILE TYPE STRING,
INDX TYPE I VALUE 0.

DATA : BEGIN OF I_MARA OCCURS 0,
*** Prepare this internal table-----*
END OF I_MARA.

DATA : WA LIKE I_MARA.

FILE = FILE_V-PATH.

CALL FUNCTION 'GUI_UPLOAD'
EXPORTING
FILENAME = FILE
HAS_FIELD_SEPARATOR = 'X'
TABLES
DATA_TAB = I_MARA.

V_READINDX = INT_LOC.
READ TABLE I_MARA INDEX V_READINDX INTO WA.

* assigning work area values to the screen field values you created so far
*example I_CCODE = WA-I_CCODE. " Company Code

ENDABAP.

* Replace this line with your TCD statement TCD ( MM01 , MM01_1 )-----

INT_LOC = INT_LOC + 1.

ENDDO.

Code Formatted by: Alvaro Tejada Galindo on Feb 25, 2008 2:48 PM

Re: ecatt

Former Member — Wed, 19 Mar 2008 18:02:31 GMT

Hello,

with eCATT in NetWeaver releases from 6.40 on there is testdata download/upload functionality available. Such is also known as "external variants".

What you can do with it is:

- download the data of the variants of a test configuration or testdata conatiner to text file, the file beeing tab separated and in a predefined format

- upload from such files (requiring the correct format)

- the files can be opened with excel (converting at import from tab delimited txt), then in excel mark all cells (Ctrl+A) and doubleclick on any column seperator to get optimal column with

- edit the data rows in excel

- save the file but do not let excel convert it into xls

- thereafter the files can be imported into eCATT TDC or TC

- also upload at each start a test configuration can be configured

- a small limitation: all this is possible with simple parameters in ecatt but not with structured parameters

Best regards

Jens