Browse Library
Sign In Start Free Trial
Close icon Search icon
Account
Browse Library Sign In Start Free Trial

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Advanced UFT 12 for Test Engineers Cookbook
  • Table Of Contents Toc
Advanced UFT 12 for Test Engineers Cookbook

Advanced UFT 12 for Test Engineers Cookbook

4 (3)
Buy this Book
close
close
Advanced UFT 12 for Test Engineers Cookbook

Advanced UFT 12 for Test Engineers Cookbook

4 (3)
Buy this Book

Overview of this book

This advanced cookbook is designed for software testers and engineers with previous automation experience and teaches UFT (QTP) developers advanced programming approaches. Knowledge of software testing and basic coding (with VBScript in particular) and familiarity with programming concepts are prerequisites.
Table of Contents (13 chapters)
close
close
close
Preface
Icon
Preface
Icon
What this book covers
Icon
What you will need for this book
Icon
Who this book is for
Icon
Conventions
Icon
Reader feedback
Icon
Customer support
Lock Free Chapter
1
1. Data-driven Tests
chevron up
Icon
1. Data-driven Tests
Icon
Introduction
Icon
Creating a DataTable parameter
Icon
Retrieving data from a DataTable
Icon
Storing data in a DataTable
Icon
Importing an Excel file to a test
Icon
Exporting a DataTable
Icon
Parameterizing Test Object properties
Icon
Defining test cases using a DataTable
Icon
Storing data in the Environment object
Icon
Retrieving data from the Environment object
Icon
Reading values from an INI file
Icon
Using a configuration file to manage test environments
Icon
Using a global dictionary for fast shared data access
Icon
Using a global dictionary for fast shared code access
2
2. Testing Web Pages
Icon
2. Testing Web Pages
Icon
Introduction
Icon
Checking whether page links are broken
Icon
Deleting cookies
Icon
Managing multiple browser windows
Icon
Handling pop-up dialogs
Icon
Downloading a file using XMLHttp
Icon
Checking whether a website is up
Icon
Uploading a file using FTP
Icon
Identifying elements based on anchors
Icon
Synchronizing a test with a web page loading
Icon
Accessing web elements through DOM
3
3. Testing XML and Database
Icon
3. Testing XML and Database
Icon
Introduction
Icon
Establishing and closing a database connection
Icon
Using SQL queries programmatically
Icon
Using a database checkpoint
Icon
Using an XML checkpoint
4
4. Method Overriding
Icon
4. Method Overriding
Icon
Introduction
Icon
Overriding a Test Object method
Icon
Registering a method to all classes
Icon
Using method overriding to support object subtypes
Icon
Adding a new method to a class
5
5. Object Identification
Icon
5. Object Identification
Icon
Introduction
Icon
Setting mandatory and assistive properties for a class
Icon
Using Descriptive Programming inline
Icon
Using the Description object
Icon
Using child objects
Icon
Using native properties for object identification
Icon
Identifying an object based on its parent
6
6. Event and Exception Handling
Icon
6. Event and Exception Handling
Icon
Introduction
Icon
Catching errors inside a function or subroutine
Icon
Creating and using a recovery scenario
Icon
Using a global dictionary for recovery
7
7. Using Classes
Icon
7. Using Classes
Icon
Introduction
Icon
Implementing a class
Icon
Implementing a simple search class
Icon
Implementing a generic Login class
Icon
Implementing function pointers
Icon
Implementing a generic Iterator
8
8. Utility and Reserved Objects
Icon
8. Utility and Reserved Objects
Icon
Introduction
Icon
Using global variables (Environment)
Icon
Customizing mouse operations (DeviceReplay)
Icon
Managing processes (SystemUtil)
Icon
Measuring time (MercuryTimers)
Icon
Resolving file locations (PathFinder)
Icon
Loading shared object repositories (RepositoriesCollection)
Icon
Loading and creating XML documents (XMLUtil)
Icon
Drawing a rectangle on the screen with Win32 API methods (Extern)
Icon
Verifying binary file contents (FileCompare)
Icon
Implementing a custom reserved object
Icon
Using remote objects
Icon
Utility statements
9
9. Windows Script Host
Icon
9. Windows Script Host
Icon
Introduction
Icon
Reading a key from the Windows® system registry
Icon
Writing a key to the Windows® system registry
Icon
Deleting a key from the Windows® system registry
Icon
Running a process using the Windows® system shell
10
10. Frameworks
Icon
10. Frameworks
Icon
Introduction to test automation frameworks
Icon
Designing a test automation framework
Icon
Building a test controller
Icon
Building a reusable component (action)
Icon
Building an event handler
Icon
Building a test reporter
11
A. Design Patterns
Icon
A. Design Patterns
Icon
Auxiliary classes and functions
Icon
Action patterns
Icon
Runtime data patterns
12
Index
Icon
Index

Importing an Excel file to a test

We can dynamically set the underlying Excel file that will serve as a data source for the whole run session, though this is probably a very rare case, and even switch between such files during the run session. It is possible to import a whole Excel workbook for a test or just a single worksheet for a specific action.

The classical case of importing an Excel file to a test is when the same flow needs to be executed on different environments, such as with multilingual systems. In such a case, the test would require an external parameter to identify the environment, and then load the correct Excel file. Another possibility is that the test identifies the language dynamically, for example, by retrieving the runtime property value of a Test Object (TO), which indicates the current language, or by retrieving the lang attribute of a web page or element.

Getting ready

Ensure that a new test is open and create a new action. Ensure that an external Excel sheet exists with one global worksheet and worksheets named after each action in the test. The Excel sheet will contain three worksheets, namely, Global, Action1, and Action2. The Action2 worksheet will contain data shown in the following screenshot. In our example, we will use the Excel sheet named MyDynamicallyLoadedExcel.xls, and to simplify matters, we will put it under the same test folder (it should be placed in a separate shared folder):

Getting ready

In the Flow pane, make sure that the Action Call properties are set to Run on all rows.

How to do it...

In order to load the MyDynamicallyLoadedExcel.xls file to the test, perform the following steps:

  1. We use the DataTable.Import method to load the Excel sheet. In Action1 (the first to be run), we use the following code to ensure that the Excel file is loaded only once (to avoid loading Excel for each iteration in case the test is set to Run on all rows):
    Print "Test Iteration #" & Environment("TestIteration") & " - " & Environment("ActionName") & " - Action Iteration #" & Environment("ActionIteration")
if cint(Environment("TestIteration")) = 1 then
    DataTable.Import("MyDynamicallyLoadedExcel.xls")    
end if
  2. In Action2, we use the following code to retrieve the values for all parameters defined in the local datasheet for Action2. We first print the number of the current action iteration, so that we may distinguish between the outputs in the console.
    Print Environment("ActionName") & " - Action Iteration #" & Environment("ActionIteration")
For p = 1 to DataTable.LocalSheet.GetParameterCount
    print DataTable.LocalSheet.GetParameter(p)
Next
  3. When a test is set to Run on all rows, it means that it will be executed repeatedly for each row having data in GlobalSheet.

    The output to the console looks like the following screenshot:

    How to do it...

How it works...

In Action1, the DataTable.Import method replaces Default.xls with the target Excel file. The code in Action2 retrieves and prints the values for each parameter, and as the action was set to Run on all rows, the code repeats this for all rows with data.

There's more...

To import just a worksheet for an action, use the DataTable.ImportSheet method as follows:

DataTable.ImportSheet("MyDynamicallyLoadedExcel.xls", "Action1", "Action1")

Here, the first parameter is the Excel filename and the last two are the source datasheet and target datasheet respectively.

See also

For information on saving values collected during a run session, refer to the next recipe, Exporting a DataTable.

CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Advanced UFT 12 for Test Engineers Cookbook
End of Section 1
Next Section
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected
Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful
Order Page Read Now

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon