Page Comparison

This page contains actions that are specific to automate Desktop applications. Also, you can use all the actions defined for General Web Actions.

...

Ensure that you have enabled UFT on your execution browsers (IE, Firefox, and Google Chrome).
Ensure the browser version installed on your execution device is compatible with UFT.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Browser Type	Enter the browser name in which you want to open the URL. Parameters can be as follows: IE: This will open URL in Internet Explorer. Firefox: This will open URL in Mozilla Firefox. Chrome: This will open URL in Google Chrome.	Yes	String
URL	Enter the URL to be opened.	Yes	String
Browser version	Enter the major and minor version of the browser installed on testing machine. For example, if browser version is 54.9.0.3323, then enter only 54.9.	No	String
Path	This parameter is applicable only when using Google Chrome browser. Enter the absolute path of the chrome.exe from the Google Chrome installed location.	No	String

Example:

OpenURL “Chrome” “http://www.google.com” “53.8” “C:\Program Files\Google\Chrome\Application\chrome.exe”

...

This action closes the specified application.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Processname	Process Name of the application that is to be closed.	Yes	String

Example:
CloseApplication "notepad.exe"

...

Driver - "Oracle in OraDb10g_home1".
You would need to know the following details as well.
Database Name- is the oracle database to which the user wishes to connect.
User ID – The username to connect to the database
Password - The password to connect to the database

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
driver	The driver for the database	Yes	String
dB	The database name on which the query will be fired	Yes	String
username	The user name to connect to the database	Yes	String
password	The password to connect to the database	Yes	String
query	The query that needs to be executed. This keyword is design such that it can store result set. Hence this keyword is beneficial for SQL queries that can return result set	Yes	String
filename	The complete path of the file in which the results of the database query is to be stored	Yes	String

Example:
ExecuteDDLQueryAndStoreInFile "Oracle in OraDb10g_home1" "ORCL" "system" "admin" "Select * from sales_master where id=100" "{Key_SQL13_InwardRegisterControl_ActData_FilePath}"

...

Driver - "Oracle in OraDb10g_home1".
You would need to know the following details as well.
Database Name- is the oracle database to which the user wishes to connect.
User ID – The username to connect to the database
Password - The password to connect to the database

Input Parameters

Parameter Name	Parameter Description	Mandatory	Data Type
driverString	The driver for the database	Yes	String
url	The connection string to connect to the database, basically the server address	Yes	String
username	The user name to connect to the database	Yes	String
password	The password to connect to the database	Yes	String
query	The dml query that needs to be executed	Yes	String
key	The key in which the result of the database query need to be stored	Yes	String

Example:

ExecuteDMLQueryAndStoreInKey "Microsoft ODBC for Oracle" "Server=localhost" "system" "admin" "Update sales_master set sales='1000' where id=100;"

...

This action stores the difference between two specified dates under the specified key. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
strKey	The key in which the difference will be stored.	Yes	String
interval	It is the expression that you want to use to calculate the differences between from date and to date. Please refer to the Interval section below for more examples of it.	Yes	String
fromDate	Enter the date from.	Yes	Integer
toDate	Enter the date to.	Yes	Integer

...

Info
Interval: The interval parameter can have the following values:

Parameter	Description
YYYY	Year
Q	Quarter
M	Month
Y	Day of year
D	Day
W	Weekday
WW	Week of year
H	Hour
N	Minute
S	seconds

Example:
CalculateDifferenceInDateAndStore "Key" "D" "12-Dec-2016" "12-Dec-2027"

...

This action opens the specified URL in the Mozilla Firefox browser. If there is any blank firefox browser on the desktop, uses the same browser, otherwise Qualitia opens a new blank browser and navigates to the URL.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
strURL	Enter the URL to open.	Yes	String

Example:

NavigateFireFoxBrowser "http://www.google.com"

...

This browser can be used in conjunction with OpenIEBrowser action.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
strURL	Enter the URL to open.	Yes	String

Example:

NavigateIEBrowser "http://www.google.com"

...

This action opens the application with specified path.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
strPath	Enter the absolute path of the application to be opened.	Yes	String

Example:

OpenApplication "C:\WINDOWS\system32\notepad.exe"

...

This action sends one or more keystrokes to the active window (as if typed on the keyboard).

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
strKey	Enter the key which you want to press from the

key board

keyboard.

Yes

String

Example:

You can use PressKeys action to open the Find dialog on the browser, which is done manually using Ctrl + F. While using the PressKeys action, the data to be passed is ~^F where ^ means Control. See the list below for the keys and their meaning).The action returns 0, if the key is pressed successfully else it will return 1 in any other case.

Note: If a PressKeys action does not execute on an Inactive Screen, refer to PressKeys Action does not Execute on an Inactive Screen.

...

The data to be passed here is only ^F. However ^ has a special meaning in QAS, it must be preceded with an escape sequence ~. Hence the data passed is written as ~^F.
Make sure to prefix an escape sequence which is a tilda for the following characters which has a special meaning in Qualitia. The characters are {,}, ^, ~
Example:

Code Block
If key to be sent is {F1}, enter data as ~{F1~}.

Code Block
To send {TAB}, enter data as ~{TAB~}.

Code Block
To send {ENTER}, enter data as ~{ENTER~}.

Use the PressKeys action to send keystrokes to applications that have no automation interface. Most keyboard characters are represented by a single keystroke. Some keyboard characters are made up of combinations of keystrokes (CTRL+SHIFT+HOME, for example). To send a single keyboard character, send the character itself as the string argument. For example, to send the letter x, send the string argument "x".

...

Some keystrokes do not generate characters (such as ENTER and TAB). Some keystrokes represent actions (such as BACKSPACE and BREAK). To send these kinds of keystrokes, enter the associated arguments as shown in the following table:

Key	Argument
BACKSPACE	~{BACKSPACE~}, ~{BS~}, or ~{BKSP~}
BREAK	~{BREAK~}
CAPS LOCK	~{CAPSLOCK~}
DEL or DELETE	~{DELETE} or ~{DEL~}
DOWN ARROW	~{DOWN~}
END	~{END~}
ENTER	~{ENTER~} or ~
ESC	~{ESC~}
HELP	~{HELP~}
HOME	~{HOME~}
INS or INSERT	~{INSERT~} or ~{INS~}
LEFT ARROW	~{LEFT~}
NUM LOCK	~{NUMLOCK~}
PAGE DOWN	~{PGDN~}
PAGE UP	~{PGUP~}
PRINT SCREEN	~{PRTSC~}
RIGHT ARROW	~{RIGHT~}
SCROLL LOCK	~{SCROLLLOCK~}
TAB	~{TAB~}
UP ARROW	~{UP~}
F1	~{F1~}
F2	~{F2~}
F3	~{F3~}
F4	~{F4~}
F5	~{F5~}
F6	~{F6~}
F7	~{F7~}
F8	~{F8~}
F9	~{F9~}
F10	~{F10~}
F11	~{F11~}
F12	~{F12~}
F13	~{F13~}
F14	~{F14~}
F15	~{F15~}
F16	~{F16~}

To send keyboard characters that are comprised of a regular keystroke in combination with a SHIFT, CTRL, or ALT, create a compound string argument that represents the keystroke combination. You can do it by preceding the regular keystroke with one or more of the following special characters:

Key	Arguments
Shift	~+
Ctrl	~^
Alt	~%

When used this way, these special characters are not enclosed within a set of braces.

...

This action connects and logs on to the designated SAP server.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
ServerDescription	Enter the server details that need to be connected.	Yes	String
Client	Enter the client details that need to be connected.	Yes	String
User	Enter the User name to use when connecting to the server.	Yes	String
Password	Enter the password to use when connecting to the server.	Yes	String
Language	Enter the 2-digit code to select the language.	Yes	String

Example:

SAPAutoLogon "Calderone" "4700" "Qualitia" "Password" "EN"

...

This action connects and logs on to an SAP server according to its IP address.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
ConnectionString	Enter the connection string that needs to be connected.	Yes	String
Client	Enter the client details that need to be connected.	Yes	String
User	Enter the User name to use when connecting to the server.	Yes	String
Password	Enter the password to use when connecting to the server.	Yes	String
Language	Enter the 2-digit code to select the language.	Yes	String

Example:

SAPAutoLogonbyIP "/F/123.132.75.5/S/3200" "4700" "Qualitia" "Password" "EN"

...

This action connects and logs on to an SAP server according to specified target system.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
TargetSystem	Enter the target system that needs to be connected.	Yes	String
Client	Enter the client details that need to be connected.	Yes	String
User	Enter the User name to use when connecting to the server.	Yes	String
Password	Enter the password to use when connecting to the server.	Yes	String
Language	Enter the 2-digit code to select the language.	Yes	String

Example:

SAPAutoLogonbyTargetSystem "C5P" "3200" "4700" "Qualitia" "Password" "EN"

...

This action opens the connection to the specified SAP server.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
ServerDescription	Enter the server description that needs to be connected.	Yes	String

Example:

SAPOpenConnection "Calderone"

...

This action opens a connection to the specified SAP server according to its IP address.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
ConnectionString	Enter the connection string that needs to be connected.	Yes	String

Example:
SAPOpenConnectionByIP "/F/123.132.75.5/S/3200"

...

This action opens a connection to the specified SAP server according to its target system.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
TargetSystem	Enter the target system that needs to be connected.	Yes	String

Example:
SAPOpenConnectionByTargetSystem "C5P"

...

It stores the total number of children of desktop class for the given set of arguments in a given key. Argument key and value should be separated by '=' and multiple key/val pair should be separated by a comma ','.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
ObjectDescription	Specification/property of the object whose instance count is to be stored. A general format is :"key1=value1,key2=value2,key3=value3"	Yes	String
Key	The key in which count is to be stored.	Yes	string

Example:
StoreObjectInstanceCount "Class Name=JavaWindow,title=LibrarySystem" "MyObjInstanceCountKey"

...

This action splits the string based on the delimiter specified by the user. Any of the split items can be stored, the particular item that is to be stored the user should provide the index of that item.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
key	The variable in which the specified indexed item of the split string is to be stored	Yes	String
mainString	The string which is to be split	No	String
delimiter	The delimiter to be used for splitting	Yes	String
instance	The index of the item which is to be store after splitting	No	String

Example:

StoreSplitString "StoreItem" "This is ; a sample ; String" ";" "2 "

StoreSubString (Deprecated)

This action stores a substring of a string into a variable. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
key	The variable in which the sub-string is to be stored.	Yes	String
sourceString	Enter the string whose sub-string value is to be stored.	No	String
startIndex	Enter the index of the string from where the sub-string is to be fetched.	No	String
endIndex	The number of characters required in the string.	No	String

Example:
StoreSubString "resultSubString" "This is a test" "2" "4"

...

Increments the string length by the value specified by the user and stores it into a variable.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
mainstring	A string from which a length will be derived	No	String
intValue	The value by which the length needs to be incremented.	No	Integer

Examples:
StoreStringLength "length" "This is a test" "3"

...

User performing this action should have write access to the corresponding file and folder.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
FilePath	Enter the absolute path to the file in which you want to make changes.	Yes	String
Text	Enter the content to be overwritten or appended.	Yes	String
Mode	Value of this parameter can be OVERWRITE or APPEND. If user keeps mode empty, it will be considered as append.	Yes	String

Example:
WriteToTextFile "C:\Users\Notepad.txt" "Qualitia" "A

...

This action modifies the date interval based on the data provided by user and stores the modified date in the specified key. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Inputdate	Enter the date to which you want to add the interval.	Yes	String
Interval	Enter the interval which you want to modify. Value for this parameter can be as follows: yyyy - Year q - Quarter m - Month y - Day of year d - Day w - Weekday ww - Week of year h - Hours n - Minutes s – Seconds	Yes	String
Data	Enter the number of intervals you want to add to the input date. The number can be positive for future dates and negative for dates in the past.	Yes	String
key	Enter the key name under which you want to store the modified date. The key value can be retrieved using the key name.	Yes	String

Example:

Data.StoreModifiedDate “02/28/2001” “yyyy” “20” “Key”

...

This action modifies format of the date and time based on the format specified by the user and stores the date and time in the modified format under the specified key. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Inputdate

Enter the date whose format you want to change.

Yes

String

Format

Enter the value for the format you want to update the date into. Value for this parameter can be as follows:

0 – Converts current date into mm/dd/yy and time (if specified) into hh:mm:ss PM/AM.
1 – Converts current date into weekday, monthname, year format.
2 – Converts current date into mm/dd/yy format.
3 – Converts current time into hh:mm:ss PM/AM format
4 - Converts current time into hh:mm format.

Yes

Integer

key

Enter the key name under which you want to store the modified date. The key value can be retrieved using the key name.

Yes

String

Example:

Date.ChangeDateFormat “02/28/2021” “1” “Key”

...

Info

Prerequisite:

Before using this action, ensure that the required databases and database drivers are installed.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

DriverString

The DriverString is a combination of driver and database details which helps automation tool to connect to the database. You must provide details in specified format as follows:

DRIVER=~{<DriverName>~};Server=<ServerIP/HostName,PortNumber>; Database=<DBName>;UID=<DBUsername>;PWD=<DBPassword>

Yes

String

Query

The query that needs to be executed.

Yes

String

FilePath

Enter the absolute path to the file in which you want to store the results.

Yes

String

Example:

MySQL:

DB.ExecuteDDLQueryAndStoreInFile “DRIVER=~{MySQL ODBC 5.3 ANSI Driver~};Server=192.168.24.99,1234; Database=ProductInfo;UID=Qualitia; PWD=Qualitia” "select * from productinfo.keyword where keywordid = 'c0ab6ad8f67234b'" "C:\Users\localadmin\Desktop\ProductInfo.txt"

...

If the record set has more than one records, value cannot be stored under the specified key. In such cases, this action fails showing appropriate error logs in the test case execution reports.

Parameter Name

Parameter Description

Mandatory

Data Type

DriverString

The DriverString is a combination of driver and database details which helps automation tool to connect to the database. You must provide details in specified format as follows:

DRIVER=~{<DriverName>~};Server=<ServerIP/HostName,PortNumber>; Database=<DBName>;UID=<DBUsername>;PWD=<DBPassword>

Yes

String

Query

The query that needs to be executed.

Yes

String

Key

Enter the key under which you want to store the results. Key value van be retrieved using the key name.

Yes

String

Input Parameters:

Example:

...

Info

Prerequisite:

Before using this action, ensure that the required databases and database drivers are installed.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

DriverString

The DriverString is a combination of driver and database details which helps automation tool to connect to the database. You must provide details in specified format as follows:

DRIVER=~{<DriverName>~};Server=<ServerIP/HostName,PortNumber>; Database=<DBName>;UID=<DBUsername>;PWD=<DBPassword>

Yes

String

Query

The query that needs to be executed.

Yes

String

Key

Enter the key under which you want to store the results. Key value van be retrieved using the key name.

Yes

String

Example:

MySQL:

DB.ExecuteDDLQueryandStoreDatainKey “DRIVER=~{MySQL ODBC 5.3 ANSI Driver~};Server=192.168.24.99,1234; Database=ProductInfo;UID=Qualitia; PWD=Qualitia”

"select * from productinfo.keyword where keywordid = 'c0ab6ad8f67234b'" "ProductInfo"

MS SQL:

DB.ExecuteDDLQueryandStoreDatainKey “DRIVER=~{SQL Server~}; Server=192.168.24.99,1234;Database=ProductInfo UID=Qualitia;PWD=Qualitia”

...

This action changes the case of the provided string and stores the final value into the specified key. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Key

Enter the key name in which you want to store the updated string.

Yes

String

InputString

Enter the string whose case you want to change.

Yes

String

Case

Value for this parameter can be as follows:

Set Upper to change the case of the string to upper case.
Set Lower to change the case of the string to lower case.

Yes

String

Example:

ChangeCaseAndStore "Key" "Qualitia" "Upper"

...

This action converts the provided string to the integer value and stores it into the specified key. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Key	Enter the key name in which you want to store integer value.	Yes	String
Number	Enter the number whose integer value you want to store into the key.	Yes	String

Example:

StoreStringToInteger "Key" "20"

...

This action runs the application or file from the specified path.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
filePath	Enter the absolute path of the application or file which you want to run or open.	Yes	String
AppParameters	If the filePath contains path to the executable file, enter the argument here to specify any parameters to be passed while opening the file.	No	String
AppDirectoryPath	Enter the directory of the application or executable file.	No	String
Operation	Specify the operation to performe after opening the application. You can specify following operations: Open-Opens the specified file or application. This can be an executable file or folder as well. Edit-Launches the application or file in the edit mode. Explore-Explores the folder which is specified in the filePath parameter. Find-Initiates the search operation from the specified folder path. Print-Prints the file specified in the filePath parameter. This action fails in case the file is not printable. Default value is Open.	No	String
Mode	Enter the mode of the application or file to open. You can specify the integer value from the list below to open application in corresponding mode. Enter, 0 to hide the window. 1 to activate and display the window of the application or file which is launched. 2 to open the application window in minimize mode. 3 to open the application window in maximize mode. 4 to open the application window in its most recent size and position. 5 to open the application window in its current size and position. 6 to minimize the specified window and activate the next top-level window in the Z order. 7 to display the window as a minimized window. 8 to displays the window in its current state. 9 to activate and display the window. If the window is minimized or maximized, the system restores it into its original size and position. 10 to Set the show-state based on the state of the program that started the application. Default value is 1.	No	Integer

Example:

LaunchApplication "C:\Application.exe"

...

This action stores the value available in the specified cell. You can then use this data while developing tasks and test cases.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
filePath	Enter absolute path to the Excel file from which you want to get and store the value.	Yes	String
sheetName	Enter the sheet name from the Excel file from which value is to be stored.	Yes	String
rowNumber	Enter the row number of the cell from which you want to store the value.	Yes	String
columnID	Enter the column ID or column name from which you want to store the value in the following format. - Column ID either can be an index number of the column or column header (mentioned at the top of each column, starts from the letter A). For example: to specify 2nd column, use col::2 or col::B. - Column name: Enter the name of the column from which you want to store the value. This name is provided by the user while adding data.	Yes	String
Key	Enter the key name under which you want to store the value. The key value can be retrieved using the key name.	Yes	String

Example:

Excel.StoreCellData “D:\TrainingStatus.xlsx” “Sheet1” “3” “Col::3” “Key”

...

This action adds specified value or a set of values into the specified row of the Microsoft excel file.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
filePath	Enter absolute path to the Excel file.	Yes	String
sheetname	Enter the sheet name from the Excel file in which you want to add the values.	Yes	String
RowNumber	Enter the row number in which you want to add the value.	Yes	String
ColumnID	Enter the column ID or column name in which you want to add the value in the following format. - Column ID either can be an index number of the column or column header (mentioned at the top of each column, starts from the letter A). For example: to specify 2nd column, use col::2 or col::B. - Column name: Enter the name of the column from which you want to store the value. This name is provided by the user while adding data.	Yes	String
Data	This is the data to be added to the specified Excel row. In case you are statically creating an array, values should be separated by caret (^).	Yes	Array
Overwrite	Specify whether you want to overwrite the existing data or you want to add another row to add this data. Values for this parameter can be as follows: Enter Previous to add a new row before the row specified above. Enter Next to add a new row after the row specified above. Enter Current to overwrite new values over the existing set of values.	No	String

Example:

WriteToRow “D:\TrainingStatus.xlsx” “Sheet1” “3” “Col::3” “PASS^PASS^FAIL^WIP” “Current”

...

This action adds specified value or a set of values into the specified column of the Microsoft excel file.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
filePath	Enter absolute path to the Excel file.	Yes	String
sheetname	Enter the sheet name from the Excel file in which you want to add the values.	Yes	String
RowNumber	Enter the row number in which you want to add the value.	Yes	String
ColumnID	Enter the column ID or column name in which you want to add the value in the following format. - Column ID either can be an index number of the column or column header (mentioned at the top of each column, starts from the letter A). For example: To specify the 2nd column, use col::2 or col::B. - Column Name: Enter the name of the column from which you want to store the value. This name is provided by the user while adding data.	Yes	String
Data	You need to add the data in the specified Excel row. In case you are statically creating an array, values should be separated by caret (^).	Yes	Array
Overwrite	Specify whether you want to overwrite the existing data or you want to add another row to add this data. Values for this parameter can be as follows: Enter Previous to add a new column before the column specified above. Enter Next to add a new column after the column specified above. Enter Current to overwrite new values over the existing set of values.	No	String

Example:

WriteToColumn “D:\TrainingStatus.xlsx” “Sheet1” “3” “Col::3” “USER1^ USER2^ USER3^ USER4” “Previous”

...

This action stores the total number of columns present in the specified sheet of Microsoft Excel.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
filePath	Enter absolute path to the Excel file.	Yes	String
sheetname	Enter the sheet name from the Excel file from which you want to store the column count.	Yes	String
ignoreBlankColumn	Specify whether you want to ignore the blank columns while calculation. To ignore blank columns, use True. To consider even blank columns, use False.	No	String
Key	Enter the key name under which you want to store the value.	Yes	String

Example:

Excel.StoreColumnCount “D:\TrainingStatus.xlsx” “Sheet1” “True” “Key”

...

This action stores the total number of rows present in the specified sheet of Microsoft Excel.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Key	Enter the key name under which you want to store the value.	Yes	String
filePath	Enter the absolute path to the Excel file.	Yes	String
sheetname	Enter the sheet name from the Excel file from which you want to store the row count.	Yes	String
ignoreBlankRows	Specify whether you want to ignore the blank rows while calculation. To ignore blank rows, use True. To consider even blank rows, use False.	No	String

Example:

Excel.StoreRowCount “D:\TrainingStatus.xlsx” “Sheet1” "5" “True” “Key”

...

This action stores the occurrence of the specific value into the specified column.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
filePath	Enter absolute path to the Excel file.	Yes	String
sheetname	Enter the sheet name from the Excel file in which you want to check for the data.	Yes	String
ColumnNumber	Enter the column ID or column name in which you want to add the value in the following format. - Column ID either can be an index number of the column or column header (mentioned at the top of each column, starts from the letter A). For example: to specify 2nd column, use col::2 or col::B - Column name: Enter the name of the column from which you want to store the value. This name is provided by the user while adding data.	Yes	String
Data	You need to add the data in the specified Excel row. In case you are statically creating an array, values should be separated by caret (^).	Yes	String
Key	Enter the key name under which you want to store the occurrence.	Yes	String

Example:

Excel.StoreColumnDataOccurrence “D:\TrainingStatus.xlsx” “Sheet1” “True” “Key”

...

This action compares only the files with flat structures (like .csv, .txt, .json and so forth).

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
File1	Enter the absolute path to the source file from which you want to compare the content.	Yes	String
File2	Enter the absolute path to the target file with which you want to compare the source file content.	Yes	String
CaseSensitive	Enter whether you want to consider case-sensitivity when comparing content. Value for this parameter can be True or False. Set True for case-sensitive comparison. Set False for case-insensitive comparison.	Yes	String
IgnoreWhitespace	Enter whether you want to consider whitespaces when comparing file contents. Value for this parameter can be True or False. Set True if you want to ignore whitespaces. Set False if you want to consider whitespaces. Note: Only leading and trailing whitespaces will be ignored if you set this parameter to True. Whitespaces inside the content will not be considered.	Yes	String

Example:

File.CompareFileContents “C:\Users\admin\Downloads\Cust_Info.xlsx” “C:\Users\admin\Downloads\Client_list.xlsx” “False” “True”

...

This action stores the total number of characters present in the specified text file.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

FilePath

Enter the absolute path to the file from which you want to store characters.

Yes

String

Key

Enter the key name in which you want to store the character count.

Yes

String

IgnoreWhitespace

Enter whether you want to consider whitespaces when storing character count. Value for this parameter can be True or False.

Set True if you do not want to consider tabs and spaces as characters.
Set False if you want to consider tabs and spaces as characters.

Note: A space or a tab is counted as one character.

Yes

String

Example:

FILE.StoreCharacterCount “C:\Users\admin\Downloads\Cust_Info.txt” “Key” “True”

...

This action stores data from the specified row of the specified text file in the key. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
FilePath	Enter the absolute path to the file from which you want to store data.	Yes	String
RowNumber	Enter the row number from which you want to get and store the data.	Yes	String
Key	Enter the key name in which you want to store the data.	Yes	String

Example:

FILE.StoreStringByLineNumber “C:\Users\admin\Downloads\Cust_Info” “2” “Key”

...

This action verifies whether the specified data exists in the specified text file.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

FilePath

Enter the absolute path to the file in which you want to verify data.

Yes

String

Data

Enter the data which you want to verify in the file.

Yes

String

CaseSensitive

Enter whether you want to consider case-sensitivity when verifying data. Value for this parameter can be True or False.

Set True for case-sensitive comparison.
Set False for case-insensitive comparison.

Yes

String

Example:

FILE.VerifyStringExistInFile “C:\Users\admin\Downloads\Cust_Info” “Qualitia” “True”

...

This action verifies the existence of the specified file at the specified location.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
FilePath	Enter the absolute path to the file which you want to verify.	Yes	String

Example:

File.VerifyFileExist “C:\Users\admin\Downloads\Cust_List.txt”

...

This action verifies the existence of the specified folder at the specified location.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
FolderPath	Enter the path to the folder which you want to verify.	Yes	String

Example:

File.VerifyFolderExist “C:\Users\admin\Downloads\Cust_Info”

...

This action simulates the keystroke events specified into the parameter.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
KeyboardInput	Enter the keys which you want to simulate.	Yes	String

This action supports following keystrokes:

To press	Enter
tab key	"Tab"
enter key	"Enter"
F1 key	"F1"
F2 key	"F2"
F3 key	"F3"
F4 key	"F4"
F5 key	"F5"
F6 key	"F6"
F7 key	"F7"
F8 key	"F8"
F9 key	"F9"
F10 key	"F10"
F11 key	"F11"
F12 key	"F13"
space key	"Space"
CapsLock key	"CapsLock"
delete key	"Delete"
down arrow key	"Down"
up arrow key	"Up"
right arrow key	"Right"
left arrow key	"Left"
end key	"End"
home key	"Home"
page down key	"Page_Down"
page up key	"Page_Up"
shift key	"Shift"

Example:

TypeKey "Enter"

...

This action simulates the keyboard inputs specified into the parameters.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
StringData	Enter the string which you want to type.	Yes	String

Example:

TypeString "qualitiasoft.com"

...

This action stores the difference between two specified dates under the specified key. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
strKey	The key in which the difference will be stored.	Yes	String
interval	It is the expression that you want to use to calculate the differences between from date and to date. Please refer to the Interval section below for more examples of it.	Yes	String
fromDate	Enter the date from.	Yes	Integer
toDate	Enter the date to.	Yes	Integer

Interval: The interval parameter can have the following values:

Parameter	Description
YYYY	Year
Q	Quarter
M	Month
Y	Day of year
D	Day
W	Weekday
WW	Week of year
H	Hour
N	Minute
S	seconds

Example:
CalculateDifferenceInDateAndStore "Key" "D" "12-Dec-2016" "12-Dec-2027"

...

This action compares the data passed by user and verifies that it matches the pattern specified by the user.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

pattern

Enter the pattern against which the data specified by the user will be verified.

Yes

String

data

Enter the data which will be matched against the pattern specified by the user.

No

String

caseSensitive

Specify the kind of comparison; case-sensitive or case-insensitive.

Set True for case-sensitive comparison.
Set False for case-insensitive comparison.

No

String

Example:
Consider a bank application where on adding a user an account number is generated which is unique and consists of alphanumeric characters. The number of characters in that account number is 10 where the first 5 are alphabets and remaining five are numbers.

...

This action compares two strings without trimming the spaces. The comparison can be either case-sensitive / non case-sensitive. Even a key can be passed as one of the parameters for comparison where the CompareString function will retrieve the value from the key and that value will be compared with expected.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

actualString

Enter the string value that you want to compare. You can pass the key name here enclosed in braces.

No

String

excpectedString

Enter the expected string value against which the actualString will be compared. You can pass the key name here enclosed in braces.

No

String

caseSensitive

Specify the kind of comparison; case-sensitive or case-insensitive.

Set True for case-sensitive comparison.
Set False for case-insensitive comparison.

No

String

CompareString "{key}" "Cancel" "true"

...

This action compares the database results in two files and displays only the difference in an Microsoft or a kingsoft Excel sheet. A link is generated in the log file. On clicking the link, the excel sheet opens in which the difference in the data is displayed. This action compares the following file types which contain DB results. These files contain the results after executing the queries using the actions "ExecuteQueryAndStoreInFile" or "StoreTableData". The supported file extension types are : txt, xml and xls.

text and text
text and excel
text and xml
xml and xml
xml and excel
excel and excel

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
sourceFile	Enter the source file to be used for the comparison.	Yes	String
targetFile	Enter the target file against which you want to compare the source file.	Yes	String
resultFileType	The file type in which the difference between the two results need to be displayed. The file type supported is: MSExcel	No	String

Example
CompareTabularResults "C:\DBResults\XML\ORACLE\Result.xml" "C:\DBResults\Excel\ORACLE\Result.xls" "MSExcel"

...

This action double clicks at the specified location of the screen or object from the application under test.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
x-coordinate	Enter the x-coordinate of the screen where you want to perform double click.	Yes	Integer
y-coordinate	Enter the y-coordinate of the screen where you want to perform double click.	No	Integer
Button	Specify which button of the mouse you want to press while performing the double click action. Valid parameters are left, middle, and right. Default is left.	No	String

Example:

DoubleClick “233” “342” “Left”

...

This action verifies whether the array is sorted in ascending/descending order.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
array data	The array to be verified for ascending or descending order. The list of data provided should be carat(^) separated.	Yes	Array
datatype	This is the type of data considered for testing. Supported data types are STRING : These are combination of alphanumeric and special characters items. INTEGER : These are strictly numerical items.	Yes	String-
direction	The way the data are to be sorted, i.e. in either ascending or descending. Supported directions are: 1=indicates ascending 2=indicates descending	No	String

Example:
IsArraySorted "0^1^4^10" "Integer" "1"

...

This action stores the specified value securely by encrypting it under the specified key. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
key	The variable under which the string data is to be stored.	Yes	String
data	Enter the data to be stored in encrypted mode.	No	String

Example:

SecureStoreVariable "Password" "Encrypt(Abc)"

...

This action verifies the difference between two integer values and validates it with the expected difference value.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Int1	Enter the 1st numerical value to compare. You can pass the key name here enclosed in braces.	No	String
Int2	Enter the 2nd numerical value to compare. You can pass the key name here enclosed in braces.	No	String
expectedDifference	Enter the expected difference between the two numbers.	No	String

Example:
VerifyDifference "30" "40" "10"

...

This action verifies that the substring is present within the main string. Comparison can either be case sensitive or insensitive.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

strMainString

Enter the main string in which you want to search substring. You can pass the key name here enclosed in braces.

No

String

strSubstring

Enter the 2nd string value that you want to search. You can pass the key name here enclosed in braces.

No

String

blncase

Specify the kind of comparison; case-sensitive or case-insensitive.

Set True for case-sensitive comparison.
Set False for case-insensitive comparison.

No

String

VerifyStringContainsValue "{mainStrKey}" "the action" "True"

...

This action compares two images. The file extension and resolution of both the images (source and target) should be same, otherwise, the step will fail.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
SourceImage	Enter the absolute path to the source image which you want to compare.	Yes	String
TargetImage	Enter the absolute path to the target image with which you want to compare the source image.	Yes	String

Example:

IMAGE.CompareTwoImages “C:\Users\Qualitia\Cust_Sign.png” “C:\Users\Qualitia\Cust_Logo.png”

...

This action stores the square root of the specified number under the key. The stored key value can be retrieved using the key name.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Key	Enter the key name under which you want to store the square root.	Yes	String
Number	Enter the number whose square root you want to store.	Yes	String

Example:

StoreSqRoot "144" "Key"

In this case, the 12 will be stored under key.

...

This action stores the specified number of characters from the right side of the given string. The stored key value can be retrieved using the key name.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
InputString	Enter the input string from which you want to store the characters.	Yes	String
length	Specify the number of characters you want to store under the key name. Enter 0 if you want to store an empty string.	Yes	String
Key	Enter the key name under which you want to store the specified number of characters.	Yes	String

Example:

StoreStringFromRight "John Doe" "3" "Key"

In this case, the last three characters i.e. Doe will be stored under the key name.

...

This action generates and stores any random string of the specified length into the key. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Key	Enter the key name under which you want to store the random text.	Yes	String
Length	Specify the number of characters of the string you want to generate and store under the key name.	Yes	String

Example:

StoreRandomString "Key" "23"

...

This action generates and stores any random alphanumeric string of the specified length into the key. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Key	Enter the key name under which you want to store the random text.	Yes	String
Length	Specify the number of characters of the string you want to generate and store under the key name.	Yes	String

Example:

StoreRandomAlphanumericString "Key" "33"

...

Number can be duplicated, if you use this action multiple times in a single test case.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
minNumber	Enter the minimum number.	Yes	String
maxNumber	Enter the minimum number.	Yes	String
strKey	Enter the key name under which you want to store the random number.	Yes	String

Example:

StoreRandomNumber “123” “890” “Key”

...

Enter 0 if you want to store the empty string.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
InputString	Enter the input string from which you want to store the characters.	Yes	String
length	Specify the number of characters you want to store under the key name. Enter 0 if you want to store an empty string.	Yes	Integer
Key	Enter the key name under which you want to store the specified number of characters.	Yes	String

ReplaceStringBySubString

This action replaces the specified part from the string with another string and stores the updated value into the specified key. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
Key	Enter the key name in which you want to store the updated string.	Yes	String
InputString	Enter the string that you want to replace.	Yes	String
Find	Enter the part of the string that need to be replaced.	Yes	String
Replacewith	Enter the replacement text for the first string.	Yes	String
Start	Enter the start position. Default is 1. All characters before the start position will be removed.	No	String
Count	Enter the number of substitutions to perform. Default is -1, which makes all possible substitutions.	No	String
CaseSensitive	Enter whether you want to consider case-sensitivity when comparing the string before replacement. Value for this parameter can be 0 or 1. Set 0 for case-insensitive comparison. Set 1 for case-sensitive comparison.	No	String

Example:

ReplaceStringBySubString "Key" "Australia" "A" "B" "1" "-1" "0"

...

This action reads the specified XML file and updates the inner value of the specified node.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
xmlFilePath	Enter the absolute path to the XML file in which you want to update the value.	Yes	String
xPath	Enter the path to the node (X Path) whose value you want to update.	Yes	String
strValue	Enter the value which you want to add in the specified node.	Yes	String

Example:

SetNodeValue “C:\Users\Qualitia\Cust_List.xml” “//DataSet[@ID='394502re33']/Step/Param[@ParamSeq='4']” “Qualitia Automation Studio”

...

This action reads the specified XML file and stores the inner value of the specified node under the specified key. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
xmlFilePath	Enter the absolute path to the XML file from which you want to get and store the value.	Yes	String
xPath	Enter the path to the node (XPath) from which you want to read and store the inner text.	Yes	String
strKey	Enter the key name under which you want to store the node value (inner text from the node).	Yes	String

Example:

XML.StoreNodeValue “C:\Users\Qualitia\Actors_List.xml” "//actors/actor[@id="3"]" “ActorName”

...

This action reads the specified JSON file, navigates to the specified JSON path, and stores the value of the specified attribute under the specified key. The key value can be retrieved using the key name.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
jsonFilePath	Enter the absolute path to the JSON file from which you want to store the value.	Yes	String
Jpath	Enter the path to the node (J Path) from which you want to read and store the value.	Yes	String
elementIndx	Enter the index number which results you want to store in the specified key. Index starts from 0.	Yes	Integer
attributeName	Enter the attribute name whose value you want to save under the specified key.	No	String
strKey	Enter the key name under which you want to store the attribute value.	Yes	Key

Example:

JSON.StoreJsonString “C:\Users\Qualitia\Cust_List.json” “$.Customers.Country[0].India” “3” “Name” “Key”

...

This action reads the specified JSON file, navigates to the specified JSON path, and sets the specified value to the specified attribute.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
jsonFilePath	Enter the absolute path to the JSON file in which you want to set the value.	Yes	String
jsonPath	Enter the path to the node (Json Path) to which you want to set the value.	Yes	String
indx	Enter the index number which results you want to set in the specified value. Index starts from 0.	Yes	Integer
attributeName	Enter the attribute name against which you want to set the value.	No	Integer
strValue	Enter the value which you want to set against the specified attribute.	Yes	String

Example:

JSON.UpdateJsonString “C:\Users\Qualitia\Cust_List.json” “$.Customers.Country[0].India” “3” “Company” “Qualitia”

...

This action executes the specified REST request. Qualitia gives you provision to store the response at the specified file path location in the JSON format, if required.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
URL	Enter the REST URL where you want to execute the request.	Yes	String
method	Enter method you want to execute on the specified URL.	Yes	String
authType	Enter the authentication type you want to use when executing the REST request. Qualitia supports two authentication types: Basic and NoAuth.	Yes	String
Username	Enter the username if the authentication type selected is Basic.	No	String
Password	Enter the password if the authentication type selected is Basic.	No	String
reqFilePath	Enter the absolute path to the file which has REST request related information in the JSON format.	No	String
resFilePath	Enter the absolute path to the file in which you want to store the REST response in the JSON format.	No	String

Example:

REST.ExecuteServiceRequest “192.122.22.34:8098/rest/ 1.0/api/qProjectMapping/project/OAT” “POST” “Basic” “john.doe@gmail.com” “john.doe@123”

...

In order to execute this action, you should know how to develop request XML for SOAP operations.

Input Parameters:

Parameter Name	Parameter Description	Mandatory	Data Type
url	Enter the API URL.	Yes	String
authType	Enter the authentication type you want to use when executing the REST request. Qualitia supports two authentication types: Basic and NoAuth.	No	String
userName	Enter the username if the authentication type selected is Basic.	No	String
password	Enter the password if the authentication type selected is Basic.	No	String
requestType	Enter the request type you want to execute.	Yes	String
reqXMLPath	Enter the absolute path to the file which has REST request related information in the JSON format.	Yes	String
methodName	Enter the method name which you want to use when executing the SOAP request.	No	String
resXmlPath	Enter the absolute path to the XML file where the response will be stored.	No	String

Example:

SOAP.ExecuteServiceRequest “http://www.dnonline.com/calculator.asmx” “Basic” “Qualitia” “Qualitia” “Post” “C:\Users\localadmin\Desktop\SOAPRequest.xml” “http://abcurl.org/add” “C:\Users\localadmin\Desktop\SOAPResponse.xml”

...

Versions Compared

Old Version 1

New Version Current

Key

StoreSubString (Deprecated)

Prerequisite:

Prerequisite:

ReplaceStringBySubString