topic Re: Getting ECATT script to loop through input file in Application Development and Automation Discussions

Getting ECATT script to loop through input file

Former Member — Wed, 07 Jun 2006 15:45:29 GMT

Hi,

I need to do a lot of repetitive HCM configuration (transaction SPRO), and I've managed to design an ECATT script (using SAPGUI mode) that works fine for creating the first entry in the input file. The script stops after that. What specifically do I need to do to get the script to keep looping through all the records in the input file?

Thanks in advance!

Vlad

Re: Getting ECATT script to loop through input file

Former Member — Thu, 22 Jun 2006 16:53:58 GMT

Dear Vlad,

Did you ever get your Script not looping problem fixed? I am having the same (or similar) problem: My scripts seems to loop thru but the Key value is blank on every iteration other than the first.

Thanks for any info you may have on this!

Julie

Re: Getting ECATT script to loop through input file

Former Member — Thu, 22 Jun 2006 17:53:54 GMT

Julie,

I did find some ABAP code to perform the looping. If you post your email I can send you the code. Ultimately I abandoned ECATT altogether and opted for LSMW. LSMW, while not as feature rich as ECATT, is far more intuitive and easy to use, and it has the looping functionality already built in.

Vlad

Re: Getting ECATT script to loop through input file

Former Member — Thu, 22 Jun 2006 17:55:10 GMT

Actually, here is the URL to the code I was talking about:

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

- Vlad

Re: Getting ECATT script to loop through input file

Former Member — Fri, 23 Jun 2006 15:26:14 GMT

Thank you! for your information, Vlad!

What release were you running in? I am 6.40 (and I thought the looping was available, now) trying to upload entries into a table with SM30. I wonder if LSMW is available for that Transaction? Best Regards, Julie

Re: Getting ECATT script to loop through input file

Former Member — Fri, 23 Jun 2006 19:22:40 GMT

Also on 6.4

LSMW works with any transaction.

Vlad

Re: Getting ECATT script to loop through input file

Former Member — Tue, 27 Jun 2006 14:21:00 GMT

Vlad, I used the above mentioned ABAP code and got my Script to process all records successfully. So, what we have, then, is a solution that uses only a Script and bypasses the Test Data Container and Test Configuration requirements. Correct?

Have you been to the CA611 training - do they address this type of processing?

I still am wondering if there isn't a way to get the Test configuration and Test Data Container to do this without ABAP code!

Sincerely, Julie

Re: Getting ECATT script to loop through input file

Former Member — Wed, 28 Jun 2006 20:18:47 GMT

UPDATE: I got eCATT to loop thru a file and do the recording without ABAP CODE!!!! I eliminated the Test Data container! I now have a Test Script (SM30 recorded with fields parameterized) and created a Test configuration (from within that: Utilities > Test Configuration > Create), Downloaded a "template" file (Edit > Variants > Download), filled that with Excel (Rows 1-3 are reserved, the other rows MUST have A UNIQUE Text name in the 1st column and then the parameter data accordingly - saved as Tab Delimited), back in the Test configuration choose External Variants mode, point to the file, and Execute!

Re: Getting ECATT script to loop through input file

Former Member — Thu, 03 Aug 2006 08:03:11 GMT

We are using eCATT parametrized script which picks data from an external template file.

The question is what is the ideal place to pick this file from? This will be used by many people with various application servers & clients. Now the issue is where should this file be placed such that it can be used by all users.

Any ideas?

Regards

Rajesh

Re: Getting ECATT script to loop through input file

Former Member — Mon, 19 Feb 2007 23:44:45 GMT

Dear Julie,

I wanted to let you know that the information you noted was critical in solving the problem I was having runing eCATT with an external file. I needed to add TWO columns: one for variant name, one for description. That was the only way I could my data to align properly with the parameters. I'm disappointed that I was not able to find this documented anywhere, but thankful that you figured it out.

Thanks again!

Rex L. Farris

Re: Getting ECATT script to loop through input file

Former Member — Mon, 12 Mar 2007 16:28:37 GMT

Julie -

I am having issues with running eCATT with external file and have read your notes. They are very helpful. Could you provide a sample of what your external file (tab-delimited or Excel) looks like? I only have one parameter value for a vendor number that I need to read in from this file. Does the parameter name need to be in the first row (row# 4) of file?

Thanks,

Steve