Skip to main content

QTP Parameterization

QTP Parameterization


Parameterization is nothing but giving multiple Input/Test data to the test script.

Different ways to Parameterize:
1.  Input the Test data from External files.

2.  Input the Test data through Datatable.

3.  Input Test data through loop statements.

4.  Input Test data dynamically through interactive submission.

Input the Test data from External files:
Set myxl = createobject("excel.application") 
 
'Make sure that you have created an excel file before executing the script . 
'Use the path of excel file in the below code.
'Also make sure that your excel file is in Closed state.
 
myxl.Workbooks.Open "D:\parameter.xls"
myxl.Application.Visible = true 
 
'"Sheet1" is the name of Sheet in Excel file "qtp.xls" where data needs to be entered .
set mysheet = myxl.ActiveWorkbook.Worksheets("Sheet1")
 
'contents of sheet1
'Uname              Pwd
'------------     ------------
'qtpworld.com       qtp
'admin              qtp
'                   qtp
'admin 
'abcd              abcd
 
'Launch Gmail
Systemutil.Run "iexplore.exe","http:\\www.gmail.com"
 
Browser("title:=Gmail: Email from Google").Page("title:=Gmail: Email from Google").Sync
 
'Get the max row occupied in the excel file 
Row=mysheet.UsedRange.Rows.Count 
 
'To read the data from the entire Excel file
For i= 2 to Row
 
Username=mysheet.cells(i,1).value
Password=mysheet.cells(i,2).value
 
' Enter Email id in Username Field
Browser("title:=Gmail: Email from Google").Page("title:=Gmail: Email from Google").WebEdit("name:=Email").Set Username
 
'Enter password in Passowrd Field
Browser("title:=Gmail: Email from Google").Page("title:=Gmail: Email from Google").WebEdit("name:= Passwd").Set Password
 
wait 1
 
Next
 
'Close the Workbook
myxl.ActiveWorkbook.Close
 
'Close Excel
myxl.Application.Quit
 
'Release the objects
Set mysheet =nothing
Set myxl = nothing

 
Input the Test data through Datatable:
'Insert  username and Password in the datatable sheet "Global"   under column  "Username" and "Password" 
 
'contents of  Global Sheet
'Username         Password
'-------------   ------------
'qtpworld.com     qtp
'admin            qtp
'                 qtp
'admin 
'abcd             abcd
 
'Get the max used range of the datasheet "Global"
row=datatable.GetSheet("Global").GetRowCount
 
'Launch gmail.com
Systemutil.Run  "iexplore.exe","http:\\www.gmail.com"
 
Browser("title:=Gmail: Email from Google").Page("title:=Gmail: Email from Google").Sync
 
'Make sure whenever you parameterize through datatable you do the following ,
'1. go to File ->Settings ->Run
'2.On the right side panel , Under  "Data Table iterations"   select the first option that is  "Run one iteration only"
 
'Loop to read all the data in the datasheet "Global"
For   Drow= 1 to row
 
datatable.GetSheet("Global").SetCurrentRow(Drow)
Username=datatable.Value("Username","Global")
Password=datatable.Value("Password","Global")
 
' Enter  Email id in Username Field
Browser("title:=Gmail: Email from Google").Page("title:=Gmail: Email from Google").WebEdit("name:=Email").Set Username
 
'Enter password in Passowrd Field
Browser("title:=Gmail: Email from Google").Page("title:=Gmail: Email from Google").WebEdit("name:= Passwd").Set  Password
 
Wait 1
 
Next


Input Test data through loop statements:
'parameterize using loop value
For orderno=1 to 10
 
'Login to sample Qtp flight application and keep the main window open.
Window("Flight Reservation").WinButton("Button").Click
Window("Flight Reservation").Dialog("Open Order").WinCheckBox("Order No.").Set "ON"
 
'Parameterize orderno using the loop value
Window("Flight Reservation").Dialog("Open Order").WinEdit("Edit").Set orderno
Window("Flight Reservation").Dialog("Open Order").WinButton("OK").Click
 
Next


Input Test data dynamically through interactive submission:
'Launch gmail.com
Systemutil.Run  "iexplore.exe","http:\\www.gmail.com"
 
Browser("title:=Gmail: Email from Google").Page("title:=Gmail: Email from Google").Sync
 
'Allowing user to enter  User name and  Password  three times during run time
 
For  i = 1 to 3 
 
'Allowing user to enter  User name and  Password
Username=Inputbox("Enter username")
Password=InputBox("Enter Password")
 
' Enter  Email id in Username Field
Browser("title:=Gmail: Email from Google").Page("title:=Gmail: Email from Google").WebEdit("name:=Email").Set Username
 
'Enter password in Passowrd Field
Browser("title:=Gmail: Email from Google").Page("title:=Gmail: Email from Google").WebEdit("name:= Passwd").Set  Password
 
Next
Labels:

Comments

Post a Comment

Popular posts from this blog

Performance Testing in the Cloud with JMeter & AWS

JMeter is a wonderful tool  to stress test your website and  your application architecture , however if you are trying to simulate many users (>1000) one JMeter instance (=pc) will not be sufficient. You will have to set up a JMeter cluster with multiple machines. JMeter is capable or running  distributed tests , but it comes with limitations. Since most of us don’t have multiple servers laying around somewhere, we usually go to cloud service providers like  AWS , spin up a couple of  EC2 instances  and turn them off whenever we’re done. Here is the problem, JMeter uses  Java RMI (Remote Method Invocation)  to communicate to its slaves, but these connections require all machines to be on the same subnet and this is not feasible with EC2 instances. Below, I explain how to get around this problem using a 3 node configuration in AWS to execute tests. I assume that you have a written the test already and have the .jmx file r...
Post a Comment
Read more

JMeter Exceeded Maximum Number of Redirects Error Solution

While running performance test, JMeter allows maximum 5 redirects by default. However, if your system demands more than 5 redirects, it may result in JMeter exceeded maximum number of redirects error. In this post, we have listed down steps to overcome this error. Actual error in JMeter: Response code: “Non HTTP response code: java.io.IOException” Response message: “Non HTTP response message: Exceeded maximum number of redirects: 5” This error is noticed because  JMeter  allows maximum 5 redirects by default and your system may be using more than 5 redirects. You need to increase this count to more than 5 in jmeter.properties file. Follow below steps to achieve this. Navigate to /bin directory of your JMeter installation. Locate jmeter.properties file and open it in any editor. Search for “httpsampler.max_redirects” property in opened file. Uncomment the above property by removing # before it. Change to value to more than 5 Eg. 20. Save the file and restart JMet...
Post a Comment
Read more

SSO with SAML login scenario in JMeter

SAML(Security Assertion Markup Language) is increasingly being used to perform single sign-on(SSO) operations. As WikiPedia puts it, SAML is an XML-based open standard data format for exchanging authentication and authorization data between parties, in particular, between an identity provider and a service provider. With the rise in use of SAML in web applications, we may need to handle this in JMeter. This step-by-step tutorial shows SAML JMeter scenario to perform login operation. First request from JMeter is a GET request to fetch Login page. We need to fetch two values ‘SAMLRequest’ and ‘RelayState’ from the Login page response data. We can do this by using  Regular Expression Extractor . These two values need to be sent in POST request to service provider. Refer below image to see how to do this. We will get an HTML login page as a response to the request sent in 1st step. We need to fetch values of some hidden elements to pass it in the next request. We...
Post a Comment
Read more