Introducing “TestComplete Cookbook”

Hi,

I am happy to introduce the recently published “TestComplete Cookbook” and excited because I was one of the technical reviewer of this book.

This book lists features from TestComplete tool and describes it based on test automation scenarios and common requirements. It has lots of best practices and techniques to learn and will help you to improve your skills on TestComplete. I like the way the author explains to the reader throughout the book in a simple language. After finishing each section, you will better know where and how to apply it in addition to understanding the concepts.

To know more about the book, author or read sample chapters, follow this link http://goo.gl/0aPrgK

Offer:

Along with the publisher, we are pleased to announce that we are organizing a giveaway especially for you. All you need to do is just comment below the post and win a free e-book of ‘TestComplete Cookbook’. Two lucky winners stand a chance to win a copy of the book. Keep reading to find out how you can be one of the Lucky One.

How to Enter?

Simply post your expectations from this book in the comments section below. You could be one of the 2 lucky participants to win the copy.

Deadline:

The contest will close on 23rd January, 2014. Winners will be contacted by email, so be sure to use your real email address when you comment!

Believe!!! There are 101 ways to automate…

Thanks and Regards,

Giri Prasad

Data handling support in TestComplete – Part 3

Using Data Storages:

When I say “Data storages” here, it’s the data sources like Excel, CSV, ADO table or simple text files which lie outside Test complete. Yes. We can have our data (test data/ expected data) independent of our Test complete projects. Also Test Complete supports good interfaces to get/set these data stored else where in the system.

Mostly when we need to build a robust Test automation framework or asking for a data driven approach, the answer might be just separate the data and the code (scripts) which uses it.

Few advantages when choosing this approach are:

1. Dependability is less which eases the development and upgrades.
2. Since data is kept outside of any automation scripts/tools, even novice users who have minimum implementation knowledge can manipulate the data easily.
3. Just pile up the data as new test cases are written for same implementation.

Test Complete provides DDT object which has methods and properties to connect to a data source, read data, assign back the results and iterate through the collection or rows and columns.

I have written a post https://automate101.wordpress.com/2010/07/27/data-driven-testing-with-testcomplete-part-2/ which explains the DDT object and sample scripts to fetch data from data sources.

a) Scope

Since these data sources lie outside TestComplete we can access them in from of the scripts and even across multiple projects. For example, single excel workbook can hold data in separate worksheets for different projects.

b) Easy Accessible:

The previously discussed (Project variables/Stores) data storage options require the help of Test Complete editor to view or edit the data stores in them. But this option doesn’t require Test Complete to be opened. Provides easy viewable options if excel or ADO table are used. Supports multiple connections to the data source and have manipulation of data inside scripts can be done with few statements

c) Adapting to changes

The scripts will be robust enough until we are modifying the schema of the data storages. Any point of time we can change the data source itself ie., data from excel sheets can be migrated to Ado tables with just minor changes in the driver scripts. Because the DDT object provides similar approach (methods and properties) for all the supported data storages.

Using Storages Object

Using “Storages” object we can manipulate data from special or complex storages like INI, XML, BINARY and REGISTRY files. As you know we cannot directly access these files like text files and require good methods for the same.

Our implementation may have requirements to store data using these file types. Also more complex, system/configuration related data or hierarchical data can only be stored in these types of files. If you are committed to use these data sources, Test Complete supports you with object called “Storages”. This is an add-on support and you need to make sure whether your tool has it. Just navigate to “File -> Install extension” dialog and verify where it is checked as shown below.

 

Storages add-on as extension in TestComplete

To use this feature in Test Complete, store the data in any of the formats like INI, XML, BINARY and REGISTRY and save the file. Inside the scripts use Storages object and its methods to manipulate data. Below you can find a sample JScript to read data from an INI file and displays them in test log.

function ReadINI()
{
 var objSection = Storages.INI("D:\\Employee.ini");
 Log.Message("Total Sections : " + objSection.SectionCount);
 var section;
 for(var idx=0; idx
 {
 section = objSection.GetSubSectionByIndex(idx);

 Log.Message("Section : " + section.Name + " has :-");

 for(var idy=0; idy
 {
 Log.Message("*** " + section.GetOptionName(idy) + " = " + section.GetOptionByIndex(idy));
 }
 }
}

Similarly using corresponding drivers we can use XML, Registry and Binary files.

a) Scope

Storages object cannot be used inside Script Extensions. Inside test complete you can access this object anywhere in the script. Also you can open the file, store them in “FileSection” object and pass as parameter to different functions.

b) Easy Accessible:

One advantage of using this object is we can manipulate complex and hierarchical file structures. Also the “FileSection” and “Section” objects gets the file similar to the physical view. For example the when we open a registry file, it returns as sections which in turn has options, thus enabling us to view the exact view of the file data.

c) Adapting to changes

The files can be stored independent of project. The Storages object uses similar kind of methods for all the 4 supported types. These two features helps us to change data and its corresponding code independent to each other.

Hope there are 101 ways to Automate !!!

Thanks & Regards,

Giri Prasad

Data handling support in TestComplete – Part 2

2. Stores:

In TestComplete each project can have its own ‘Stores’ test item. It is a collection of various file types which can be accessed by project scripts. It can be directly added to any project by simply right clicking the <Project_Name> -> Add -> New Item -> Stores.

Stores_as_project_item

The advantage of having such collection is, it gives access to complete repository of required data in various data formats. Mostly it can be used for verification of expected results and data source for across AUT.

The stores collections can accommodate data in below formats,

• DBTables – To store tables and queries.
• Files – To store Text or Data files of any type.
• Objects – Used to store object properties in XML format
• Regions – Image formats like BMP, JPEG, PNG, TIFF or GIF.
• Tables – To store AUT control’s data that display information in a tabular form.
• WebTesting – Web page controls/items used to compare and verify web pages.
• XML – To store xml documents.

When you record a scenario and need verification point to test, you will recognize/compare object/properties. These items are in turn added to Stores object by the recorder while saving the scripts. Generally when you use ‘Checkpoints’ in your script, the expected data/files will be stored under stores collection.

Manually also we can add items to the collection thru right clicking the stores item, select ‘New Item/Existing Item’ option and browse for suitable item/file.

a) Scope:

‘Global’ to its project. The stores items are saved inside the project itself by default. We can also alter the location to store in different path. But this makes some dependability while moving the projects. Both the script units and keyword tests has access to this collection.

b) Easy Accessible:

The stores collection is accessible using object called ‘Stores’ inside ‘ScriptExtensions’ and using objects – DBTables, Files, Objects, Regions, Tables, WebTesting, XML inside scripts. Through these object we can refer its corresponding methods which helps us greatly in manipulation our data during execution.

The objects – Files, Objects, Regions and XML has general methods to add files, compare them, check for existence, get them by name/index and delete them. The remaining objects – DBTables, Tables, WebTesting have methods based on the instances in them.

These objects/files are independent of script languages and TestComplete supports all the methods and properties to access these files in any of its five scripting languages supported.

c) Adapting to changes:

The items/collections present in the project can be added/ updated/ deleted any time by with fewer mouse click actions. TestComplete provides easy wizard like forms to add/update the items and well informed UI to view the data in the files. For example let us see how the data in XML file is shown in TestComplete.

XMLViewer_in_Stores

Just like the screen shot it displays our files (expected, checkpoints) in well understanding manner and provides options to update the files. You can simply switch over to the ‘Source’ tab here to edit the XML file and save to update it. Similarly the many of the ‘Stores’ files can be easily updated right inside test complete.

One more advantage in using Stores is we can update the stores object/files in one click. If the AUT has gone for any change and the expected results/checkpoints need to be updated to the latest version of the product, simply we can ask TestComplete to update the object instead of checking/comparing it. So when the tests run, TestComplete will update its stored objects based on the mapping in the Stores. Use the Tools -> Options dialog to configure the compare/update setup as below in the figure.

Update_Stores_Collections

To be continued..

Hope there are 101 ways to Automate !!!

Thanks & Regards,

Giri Prasad

Data handling support in TestComplete – Part 1

Hi All,

In testing/automation we deal with different types of ‘Data’ say Test data, Expected data, Configuration data and execution data, etc,. The dependability on test data changes based on the framework chosen for automating the AUT. Data Driven Testing has more dependability with the Test data and Expected data than other approaches. Overall we need a good mechanism to store, configure, and use them in to the scripts to effective automation.

So when I ask data handling for Automation, I might get answers from 2 categories.

1. Using scripting language
2. Using Automation tool

Since most of the script languages have a programmatic approach (Initialize, Use and Destroy) in handling the data and mostly they are not persistent across executions, we will move and concentrate to second option and get clarify on the support provided from tool perspective.

We must understand that data handling plays a key role in determining the success of a test automation implementation before moving to handle it. A complete analysis of our data handing requirement must be done before choosing an approach.

TestComplete supports DDT and provides various options to store data through it. Some of them are,

1. ProjectSuite/Project variables
2. Stores
3. Using Data Storages
4. Storages Object

I am going to consider the following criteria for each facility:

a.      Scope

b.      Easy accessible

c.      Adapting to change

1. Project Suite / Project variables:

The project suite and project items created using the TestComplete was designed to store data in them apart from project related properties. To use it, we have a choice of few available data types (String, Integer, Double, Boolean, Object, Table) and give a meaningful variable name to it. From the scope perspective, these Project suite/Project variables can be classified as ‘Persistent’ and ‘Temporary’.

Simply, Persistent variables hold their value between the test executions whereas Temporary variables will not. And Persistent variables have some advantage over distributed automation where we can have separate value for each remote host thru ‘Local value’. Also when your script is accessing and updating both persistent and temporary variables, in the next execution persistent variable will have the updated one whereas the temporary will hold its default value.

The properties of these variables are,

Name – Name of the variable (should follow basic naming convention).

Type – Any one data type to choose from – [String, Integer, Double, Boolean]. The temporary variables can also be of type Object and Table

Default value – The default value if any for the variable.

Local value – This is available only for persistent variables.  Local value to be used for remote host on distributed execution

Description – Summary to explain the variable usage

Scope:

Global to the declared item. As per the name says the project suite variables can be accessed across the project inside the suite and project variables are accessible across the scripts inside the project

Adapting to change:

Yes. We can modify these variables anytime during the execution inside the scripts and always available to change. Mostly these can be used where we need to same set of information across script unit and where value set by one script need to be accessed by another.

Easy accessible:

Syntax:

Project.Variables.<variable name>

ProjectSuite.Variables.<variable name>

As mentioned above can be accessed anywhere to ‘set’ or to ‘get’ the values. The TestComplete will give you code snippets for the defined variables.

Using Stores and data sources will be continued in next post…

Hope there are 101 ways to Automate !!!

Thanks & Regards,

Giri Prasad

What is new in TestComplete 8 ? – Part 2

DDT enhancements

Data Driven testing is well supported in this version of TestComplete. The enhancement ‘Data-Driven loop’ is mainly useful for Keyword-driven testing. Usually keyword-driven test can be done with minimum programming/coding knowledge. This ‘Data-Driven loop’ feature still makes it easier to implement without much of technical knowledge.

If your keyword-driven test has repeated actions and differ only with test data, then you can opt for this feature.

To turn the repeated code as a loop with different data, simply select the set of actions (test steps or sub-actions) which you want to turn in to loop and right-click to get the pop up menu. Select ‘Make Data Loop’ option to get the data source configuration wizard.

Selecting or creating data source, configuring how and which data to be read, binding with test steps and much more can be done through this wizard itself.

Based on the data source (Excel, CSV, DB table), the configuring and data selection process (wizard options) will differ. But this wizard will be very useful and can use with minimum programming knowledge.

The good part is after specifying the data source file; it will be visualized inside the wizard itself.

• You can view the data in worksheets in case of Excel worksheet
• Comma separated values in case of CSV.
• Content of tables in case of DB tables

 

This wizard will reduce the typo errors, data source connection problems, test data range specification etc.,

Note: In the script based automation we can reap the above DDT advantages using its built-in drivers, methods and properties.

https://automate101.wordpress.com/2010/07/27/data-driven-testing-with-testcomplete-part-2/

Network suite enhancements

 

Networksuite has a good number of improvements in TestComplete 8. Among these I like automatic logging/Reboot on remote machines and visualizing the remote desktop screens.

Now you can write a script to login/reboot and remote machines which you treat as client and start test suites there.

Also the remote machines desktop screen can be viewed inside the network suite panel. This allows us to track the execution without manually log-in into those systems.

I have to really explore more on this feature because it is said that GUI tests run via the Remote Desktop do not fail if the Remote Desktop is minimized or closed during the test run. Need to know exact difference between TestComplete 7.52 and 8.

TestLog enhancements

 

If you have used test Visualizer while recoding the scripts, it will replay with synchronization to the recorded images while playing back.

We can view the actual image and expected images in the test log once the test were completed. These log items will show as an image comparison where we can analyze the image to find the root cause if it has the failure.

Comparison of Expected and Actual screen shot

 

Now the test logs can be exported as bugs to JIRA, OnTime and Software Planner. This feature minimizes the bug logging and tracking of it.

As we have methods and properties to access test log items using script, this version has new “LogItem.Status” property to determine its status of specified LogItem. These set of methods and properties will be useful when you want to parse the execution log and prepare/document the data that is interested for you.

Script Extension enhancements

1. The next version of WMI (1.1) scripts are added to Script Extensions to support most likely used functions. A total of 10 new functions were added in this version.
2. The bug reporting mechanism to JIRA, OnTime and Software Planner were implemented as script extensions

Still exception handling mechanism can be improved in Script Extension. Also more objects like Registry, Stores etc., can be given access inside script extensions.

Others

In the Toolbar -> options menu item, we can configure the TestComplete options.

• ‘Images’ and ‘When referring to an non-existence object’ items are moved from General list.

• ‘Debug Services’ option was removed

• New option “Java Bridge” is added to map the JVM (for supporting java classes)

• Under “Recording” option, the option to ‘Record text input into simple editors as’ will allow us to use “SetText” or “Keys” function. Also you can set to record only user action on TestedApps application and skip other actions.

• The option “Visualizer” is removed in this version.

• We can configure the sorting of categories displayed in object browser using the option Panels -> Object Browser -> Categories sorting

You can directly send error reports to AutomatedQA support using “Help -> Contact support team” menu option, which will open the new support form of TestComplete.

If you come across any differences/ enhancements in TestComplete 8, please share here…

 

Hope there is 101 ways to automate…

Thanks & Regards,
Giri Prasad