eCATT -External file

[Former Member]

Hi All,

I want to get the data from the external excel file or notepad file.

What should be the format of the excel file.should it be like the test script or test data.

From where can i get upload this excel or notepad file?Is it from Test data or from Test configuration?

Kindly provide the solution with some example and also with the related blogs.

Thanks&Regards

Siva

[Former Member]

Hi All,

I want to get the data from the external excel file or notepad file.

What should be the format of the excel file.should it be like the test script or test data.

From where can i get upload this excel or notepad file?Is it from Test data or from Test configuration?

Kindly provide the solution with some example and also with the related blogs.

Thanks&Regards

Siva

[Former Member]

Hi

See the related links

check these link,

eCATT- An Introduction

/people/sumeet.kaul/blog/2005/07/26/ecatt-an-introduction

Creating Test Scripts

/people/sumeet.kaul/blog/2005/08/10/ecatt-creating-test-scripts

eCATT Logs

/people/sapna.modi/blog/2006/04/18/ecatt-logs-part-vi

eCATT Scripts Creation – TCD Mode

/people/sapna.modi/blog/2006/04/10/ecatt-scripts-creation-150-tcd-mode-part-ii

Creation of Test Data Container

/people/sumeet.kaul/blog/2005/08/24/ecatt-creation-of-test-data-container

eCATT Scripts Creation - SAPGUI Mode

/people/sapna.modi/blog/2006/04/10/ecatt-scripts-creation--sapgui-mode-part-iii

Integrating ECATT & MERCURY QTP Part -1

/people/community.user/blog/2007/01/02/integrating-ecatt-mercury-qtp-part-1

Using eCatt to Test Web Dynpro ABAP

/people/thomas.jung/blog/2006/03/21/using-ecatt-to-test-web-dynpro-abap

and

-command reference

http://help.sap.com/saphelp_nw04/helpdata/en/c6/3c333b40389c46e10000000a114084/content.htm

/people/sapna.modi/blog/2006/04/10/ecatt--an-introduction-part-i

http://prasadbabu.blogspot.com

https://www.sdn.sap.com/sdn/developerareas/was.sdn?page=test_tool_integration_for_sap_e-catt.htm

http://help.sap.com/saphelp_nw04/helpdata/en/1b/e81c3b84e65e7be10000000a11402f/frameset.htm

http://www.erpgenie.com/ecatt/index.htm

hope this helps.

Reward points if useful

Regards

Anji

[Former Member]

Hello Siva,

Please check in test data container whether you have the option for loading the test data from the external file. If u have thins option you cal load the test data into the test data container as variants.

But if its not there,

Then you need to write a ABAP logic in eCATT script to read the Excel sheet. My suggestion better you convert the Excel sheet into CSV (text) file then you can upload the test data easily as already some blogs avilable on it. Please go tru the following link below,

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

If not that is the case

for reading the excel file please check below blog,

http://www.erpgenie.com/sap/abap/code/abap42.htm

try to develop some prototype from the above code,

if u thinks its working fine then copy the same code in eCATT script and place in between ABAP...ENDABAP command.

i am sure it will work.

Let me know if you need anything furhter.

Hope this helps.

-Manjula P

Message was edited by:

Manjula Pasala