Generic Actions
OpenURL
This action opens the specified URL. Qualitia user can specify the browser and browser version in the parameters section to be used when opening URL.
- Ensure you have enabled HP Functional Testing Agent on your execution browsers (IE, Firefox, and Google Chrome).
- Ensure the browser version installed on your execution device is compatible with HPE 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:
| 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. | Yes | 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. | Yes (for Chrome only) | String |
Example:
OpenURL “Chrome” “http://www.google.com” “53.8” “C:\Program Files\Google\Chrome\Application\chrome.exe”
When using this action, Qualitia defines its own set of system variables which can be used later when executing test cases. These variables are stored in Qualitia with their expressions (TRUE or FALSE). Following is the list of system variables that Qualitia stores when executing the OpenURL action.
- $$_ISIE: If browser type is set as IE (Internet Explorer), then this expression is stored as TRUE. Here, other two ($$_ISFIREFOX and $$_ISCHROME) are stored as FALSE.
- $$_ISFIREFOX: If browser type is set as FIREFOX (Mozilla Firefox), then this expression is stored as TRUE. Here, other two ($$_ISIE and $$_ISCHROME) are stored as FALSE.
- $$_ISCHROME: If browser type is set as CHROME (Google Chrome), then this expression is stored as TRUE. Here, other two ($$_ISFIREFOX and $$_IE) are stored as FALSE.
Note: It is recommended to close all the unnecessary browsers before starting the test execution or object spying using UFT.
CalculateDifferenceInDateAndStore
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 | String |
toDate | Enter the date to. | Yes | String |
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"
CloseApplication
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"
CompareTabularResults
This action compares two CSV files and displays the comparison in MS Excel/Kingsoft format. A link will be displayed in the HTML report if there is any data mismatch. You can click the link to view the difference in either of the spreadsheet as parameterized by the user. This action performs an exact match of the data. Before comparing the data will be trimmed for any trailing spaces. The comparison is case-sensitive.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
File1 | File path of first csv file to be compared | Yes | String |
File2 | File path of second csv file to be compared | Yes | String |
Format ResultFileFormat | This is the spreadsheet where the mismatch data [if any] will be displayed. The current supported formats are "MSExcel" and "KSOExcel". | Yes | String |
Example:
CompareTabularResults "D:\File1.csv" "D:\File2.csv" "MSExcel"
ComputeExpression
This action evaluates mathematical, relational, logical operations and stores the result in a key.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
strKey | The key on which the result of the evaluation need to be stored. | Yes | String |
strexpression | The expression to be evaluated | Yes | String |
Example:
- Mathematical Expression
ComputeExpression "result" "24*2+4"
- Relational Expressio
ComputeExpression "result" "10*2<30"
- Logical Expression
ComputeExpression "result" "10*2+1>19&10*2+2<23"
ExecuteDDLQueryAndStoreInFile
This action executes data definition queries like select and stores the result set of the fired query. The result set is stored in a CSV file. The action supports and is tested for database Oracle 10g.
Before using this action, ensure that the required database and database drivers are installed. Below is basic information on the oracle drivers and connection with Vbscript.
Oracle10g:
For interacting with the database you would need a driver that is supported in VbScript to interact with Oracle 10 g. One of the drivers can be as follow. The driver would need to be installed before interacting with the database.
- 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}"
ExecuteDMLQueryAndStoreInKey
This action executes data manipulation queries like update, delete, and stores the result into a key. This action supports and is tested for database Oracle 10g.
Before using this action, ensure that the required database and database drivers are installed. Below is basic information on the oracle drivers and connection with Vbscript.
Oracle10g:
For interacting with the database you would need a driver that is supported in VbScript to interact with Oracle 10 g. One of the drivers can be as follow. The driver would need to be installed before interacting with the database.
- 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 |
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 * from sales_master where id=100" "{Key_Status}"
ExecuteFile
This action executes the batch file specified by the user.
Input Parameters
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
FilePath | The complete path of the file to be executed. | Yes | String |
Example:
ExecuteFile "C:\test\batchfile1.bat"
IsArraySorted
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. | Yes | Array |
datatype | This is the type of data considered for testing. Supported data types are | Yes | - |
direction | The way the data are to be sorted, i.e. in either ascending or descending. Supported directions are: | Yes | String |
Example:
IsArraySorted "0^1^4^10" "Integer" "1"
NavigateFireFoxBrowser
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"
NavigateIEBrowser
This action opens the specified URL in the Internet Explorer (IE) browser. If there is any blank IE browser on the desktop, uses the same browser, otherwise Qualitia opens a new blank browser and navigates to the URL.
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"
OpenApplication
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"
OpenSAPApplication
This action opens the SAP application.
Input Parameters
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
AppPath | Enter the path of the application to be opened. | Yes | String |
strValue | Enter the module name to be opened of the SAP application. | Yes | String |
Example:
OpenSAPApplication "D:/SampleSAPapplicaiton.exe" "Admin"
PressKey
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 to be pressed from the keyboard. | Yes | String |
Example:
Suppose the user want to open the Find dialog on the Browser window under test. Manually this is done by pressing the keys Control and F simultaneously. This opens the Find dialog on the browser window. The same thing can be done using the action PressKey .The data to be passed to the keyword in this case will be given as ~^F where ^ means Control. (See the list below for the keys and their meaning.
The action returns 0, if the key is pressed successfully, otherwise, it will return 1 in any other case.
Important Note:
Ideally the data to be passed here is only ^F, however as ^ has a special meaning in Qualitia it has to be preceded with an escape sequence ~. Hence the data passed will be ~^F.
Make sure to prefix an escape sequence which is a caret for the following characters which has a special meaning in Qualitia. These characters are {,}, ^.
For example, if you want to press the {F1} key, then user should pass data as {F1}
Use the PressKey method 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, if you want to send the letter x, send the string argument "x".
You can use PressKey to send more than one keystroke at a time. To do this, create a compound string argument that represents a sequence of keystrokes by appending each keystroke in the sequence to the one before it. For example, to send the keystrokes a, b, and c, you would send the string argument "abc". The PressKey method uses some characters as modifiers of characters (instead of using their face-values). This set of special characters consists of parentheses, brackets, braces, and the:
- plus sign "+",
- caret "^",
- percent sign "%",
- tilde "~"
Send these characters by enclosing them within braces "{}". For example, to send the plus sign, send the string argument "{+}". Brackets "[ ]" have no special meaning when used with PressKey, but you must enclose them within braces to accommodate applications that do give them a special meaning (for dynamic data exchange (DDE)).
- To send bracket characters, send the string argument "{[}" for the left bracket and "{]}" for the right one.
- To send brace characters, send the string argument "
}" for the left brace and "{
" for the right one.
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, send the arguments 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 do this by preceding the regular keystroke with one or more of the following special characters:
Key Special Character
- SHIFT: +
- CTRL: ^
- ALT: %
When used this way, these special characters are not enclosed within a set of braces.
To specify that a combination of SHIFT, CTRL, and ALT should be held down while several other keys are pressed, create a compound string argument with the modified keystrokes enclosed in parentheses. For example, to send the keystroke combination that specifies that the SHIFT key is held down while:
- e and c are pressed, send the string argument "+(ec)".
- e is pressed, followed by a lone c (with no SHIFT), send the string argument "+ec".
You can use the PressKey method to send a pattern of keystrokes that consists of a single keystroke pressed several times in a row. To do this, create a compound string argument that specifies the keystroke you want to repeat, followed by the number of times you want it repeated. You do this using a compound string argument of the form {keystroke number}. For example, to send the letter "x" ten times, you would send the string argument "{x 10}". Be sure to include a space between keystroke and number.
- The only keystroke pattern you can send is the kind that is comprised of a single keystroke pressed several times.
For example, you can send "x" ten times, but you cannot do the same for "Ctrl+x". - You cannot send the PRINT SCREEN key {PRTSC} to an application.
- To send a space, send the string " ".
ReplaceAndStoreText
This action replaces a substring by another substring into a source string and stores the resulting string in the given key.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
SourceText | The complete path of the file to be executed. | Yes | String |
TextToBeReplaced | Substring that is to be replaced from the SourceText. | Yes | String |
TextToBeReplacedBy | Substring by which replacement is to be done. | Yes | String |
IsCaseSensitive | Indicates case sensitive. | Yes | String |
Key | Key in which final output will be stored. | Yes | String |
Example:
ReplaceAndStoreText "India" "i" "Z" "True" "key1"
RestJsonResp
This action stores JSON response of the specific key for RESTful service.
Input Parameters
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
URL | Enter the URL of the REST service. | Yes | String |
Method | Enter the method to request the service. | Yes | String |
Filepath | Enter the absolute path of the .txt file from where the request is to be taken. | Yes | String |
Key | Enter the key for which the value is to be stored. | Yes | String |
Response | The key value will be stored in this variable. | Yes | String |
Example:
RestJsonResp "http://abcd.cbdx.com" "Get/Post" "D:/sample.txt" "Name" "Key"
SAPAutoLogon
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"
SAPAutoLogonByIP
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"
SAPAutoLogonByTargetSystem
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:
SAPAutoLogonbyIP "C5P" "3200" "4700" "Qualitia" "Password" "EN"
SAPCloseConnections
This action closes all the existing connections that are open currently.
This action does not have any input parameters.
Example:
SAPCloseConnections
SAPOpenConnection
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:
OpenConnection "Calderone"
SAPOpenConnectionByIP
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:
OpenConnectionByIP "/F/123.132.75.5/S/3200"
SAPOpenConnectionByTargetSystem
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:
OpenConnectionByIP "C5P"
SAPStartBPCATracing
This action begins running the Business Process Change Analyzer to detect changes in a transaction's objects (as compared to the TBOM).
This action does not have any input parameters.
Example:
SAPStartBPCATracing
SAPStopBPCATracing
This action stops the Business Process Change Analyzer.
This action does not have any input parameters.
Example:
SAPStopBPCATracing
SecureStoreVariable
This action securely stores the value in the specified key. The value is encrypted for security purposes but value can be retrieved using the key name.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
strkey | The variable in which the string data is stored | Yes | String |
value | Enter the value that needs to be stored securely. The value will be encrypted. | Yes | String |
Example:
To store a data in a variable:
SecureStoreVariable "pwd" "Encrypt(ABC)"
When the focus is moved away from parameter Qualitia automatically encrypts the data ABC and result in a secured text like:
"vHpmlfI4R3PQkCN4sZnuqw==þNWE3ZDdkNjE3N22ODgxMzQwYWI1MTA3YWNDc="
StoreArrayItem
This action gets the value from an array and stores it into the specified key. The key value can be retrieved using the key name.
Input Parameters:
Parameters Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
Key | Enter the key in which the Array is to be stored. | Yes | String |
ArrayName | Enter the array name from which values are to be stored. | Yes | String |
ArrayIndex | Enter the array index from which values are to be stored. | Yes | String |
Example:
StoreArrayItem "Key" "Name" "3"
StoreObjectInstanceCount
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. | Yes | String |
Key | The key in which count is to be stored. | Yes | string |
Example:
StoreObjectInstanceCount "Class Name=JavaWindow,title=LibrarySystem" "MyObjInstanceCountKey"
StoreSplitString
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 |
---|---|---|---|
strKey | The variable in which the specified indexed item of the split string is to be stored | Yes | String |
strMainString | The string which is to be split | Yes | String |
Delimiter | The delimiter to be used for splitting | Yes | String |
index | The index of the item which is to be store after splitting | Yes | Integer |
Example:
StoreSplitString "StoreItem" "This is ; a sample ; String" ";" "2 "
StoreStringLength
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 |
---|---|---|---|
strKey | A key in which a length will be stored | Yes | String |
strMainStr | A string from which a length will be derived | Yes | String |
intIncrement | The value by which the length needs to be incremented. | Yes | Integer |
Examples:
StoreStringLength "length" "This is a test" "3"
StoreSubString
This action stores substring of specified length from main string from the specified index.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
strKey | A key in which a substring will be stored | Yes | String |
strMainString | A string from which a substring will be derived | Yes | String |
intStart | A position from which substring will be derived from main string | Yes | Integer |
intLen | Length of substring starting from a position specified in parameter intStart | Yes | Integer |
Examples:
StoreSubString "SubStr" "Qualitia" "4" "4"
StoreVariable
Store a particular string value in a variable (key).
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
strKey | A key in which you want to store the value. | Yes | String |
Value | Value to be stored. | Yes | String |
Example:
StoreVariable "url" "http://www.google.com" NavigateIEBrowser "{url}"
TrimAndStoreText
This action trims the preceding and succeeding spaces and stores the resulting string in the given key.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
strText | The string which has to be trimmed. | Yes | String |
strKey | The key in which result is to be stored. | Yes | String |
Example:
TrimAndStoreText " John Doe " "FullName"
Suppose, you give the strText as " John Doe " to store the final string inside the key "FullName". End of the execution, John Doe will be stored in the key FullName.
VerifyDataType
This action verifies if the data type is numeric or string.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
data | Enter the data to verify. | Yes | String |
dataType | The data type against which the data is to be verified. | Yes | string |
Example:
VerifyDataType "4.78" "numeric"
This shall verify if 4.78 is numeric
VerifyDataType "This is a test" "string"
This shall verify if "This is a test" is a string
Anything which is not numeric shall be considered as a string.
Example: "Enter 123", "23/02/20" etc shall be considered as a string.
VerifyDifference
This action verifies the difference between two integers.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
int1 | First integer to be compared | Yes | String |
Int2 | second integer to be compared | Yes | String |
intDiff | Expected difference between the two integers against which actual difference will be verified | Yes | String |
Examples:
VerifyDifference "100" "75" "25"
VerifyStringContainsValue
This action verifies that the substring is available within the main string. Comparison can either be case sensitive or insensitive.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
strMainString | The main String in which the substring will be searched for. | Yes | String |
strSubString | The string to be searched for in the main string. | Yes | String |
blnCase | The kind of comparison to be done. | Yes | Boolean |
Example:
Consider an application where order for books are placed .Once an order is placed the confirmation message and order number is displayed in a WebElement. Lets consider the message displayed in the WebElement is 'Your order has been placed successfully. Order Number is 10'. As the order number is dynamic you can verify part of the string using the action VerifyStringContainsValue. User can use the keyword StorePropertyFromObject to store the web elements value in a key say "MyElementKey"
Now the user can verify this value by using the action VerifyStringContainsValue as follows
strMainString - { MyElementKey }
strSubString – Your order has been placed successfully. Order Number is
blnCase - True
VerifyStringContainsValue "{MyElementKey}" "Your order has been placed successfully
Order Number is" "True"
WaitFor
This action makes a tool wait for the specified period of time.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
intExpTimeSecs | 'intExpTimeSecs' is the specified seconds that the tool is expected to pause. | Yes | Integer |
Example:
Waitfor "8"
WriteLog
This action helps Qualitia users to select the appropriate status and information message to be displayed in the execution report based on the test case requirements.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
Status | Enter the result status to be displayed in the report. The report status should be Pass, Fail, or Defect. | Yes | String |
Message | Enter the message to be displayed for the respective test step in the execution report. | Yes | String |
Example:
WriteLog "Defect" "The value in the edit box should be Username"
WriteTextToFile
This action allows users to write or append the text in the specified file.
User performing this action should have write access to the corresponding file and folder.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
FileName | Enter the absolute path to the file in which you want to make changes. | Yes | String |
FileContent | 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:
WriteTextToFile "C:\Users\Notepad.txt" "Qualitia" "Append"
EXCEL.StoreCellData
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 | Integer |
column | 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:
StoreCellData “D:\TrainingStatus.xlsx” “Sheet1” “3” “Col::3” “Key”
EXCEL.WriteToRow
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 | Integer |
column | 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 into 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:
| Yes | String |
Example:
WriteToRow “D:\TrainingStatus.xlsx” “Sheet1” “3” “Col::3” “PASS^PASS^FAIL^WIP” “Current”
EXCEL.WriteToColumn
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 | Integer |
column | 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 into 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:
| Yes | String |
Example:
WriteToColumn “D:\TrainingStatus.xlsx” “Sheet1” “3” “Col::3” “USER1^ USER2^ USER3^ USER4” “Previous”
EXCEL.StoreColumnCount
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.
| Yes | Boolean |
Key | Enter the key name under which you want to store the value. | Yes | String |
Example:
Excel.StoreColumnCount “D:\TrainingStatus.xlsx” “Sheet1” “True” “Key”
EXCEL.StoreRowCount
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 |
---|---|---|---|
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 row count. | Yes | String |
ignoreBlankColumn | Specify whether you want to ignore the blank rows while calculation.
| Yes | Boolean |
Key | Enter the key name under which you want to store the value. | Yes | String |
Example:
Excel.StoreRowCount “D:\TrainingStatus.xlsx” “Sheet1” “True” “Key”
EXCEL.StoreColumnDataOccurance
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 |
column | 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 |
cellData | Enter the data which you want to verify in to the specified column. | Yes | String |
Key | Enter the key name under which you want to store the occurrence. | Yes | String |
Example:
Excel.StoreColumnDataOccurrence “D:\TrainingStatus.xlsx” “Sheet1” “col::3” “PASS” “Key”
EXCEL.StoreCellText
This action reads the Microsoft Excel file and stores the data from the specified cell of the specified sheet in the key. The value stored under the key can be retrieved using the key name.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
fileName | Enter the Microsoft Excel file name from which you want to store the value. | Yes | String |
sheetNum | Enter the sheet number from the Microsoft Excel work book from which you want to store the value. Index starts from 1. | Yes | String |
rowNum | Enter the row number of the cell from which you want to store the value. | Yes | Integer |
colNum | Enter the column number of the cell from which you want to store the value. | No | String |
strKey | Enter the key name under which you want to store value from the cell. | Yes | String |
Example:
EXCEL.StoreCellText “C:\Users\Qualitia\Cust_Name.xlsx” “2” “4” “5” “Key”
Excel.StoreCellDataFromFile
This action checks the condition added by the user and stores the matching data from specified Excel cell into the specified key.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
filename | Enter the absolute path to the excel file from which you want to read and store the data. | Yes | String |
sheetName | Enter the name of the sheet from which you want to fetch the data. | Yes | String |
colName | Enter the column name from which you want to fetch the data. | Yes | String |
Condition | Enter the condition which you want to match for getting the desired data. | Yes | String |
Separator | Specify the separator which you have used to separate column name and data while adding the condition. You can use any character as a separator (equal to [=] sign in the example mentioned below). Use caret sign (^) as a connection string. | Yes | String |
strKey | Enter the key in which you want to store the data. | Yes | String |
Example:
Suppose there is list of employees and you want to store the employee ID of the specific employee from the list. (refer to the image below). To store the employee ID of Jane, you can use this action as follows:
"D\Book1.xlsx" "Sheet1" "Employee ID" "FirstName=Jane^LastName=Doe^Designation=Asst.Manager" "=" "ID"
End of the execution, action stores the Employee ID of Jane i.e. 232 into the specified key ID.
IMAGE.CompareTwoImages
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 |
---|---|---|---|
SourceImagePath | Enter the absolute path to the source image which you want to compare. | Yes | String |
TargetImagePath | 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”
Date.StoreModifiedDate
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:
| 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 | 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:
Data.StoreModifiedDate “02/28/2001” “yyyy” “10” “Key”
Post execution, Qualitia will store 02/28/2010 in the key.
Date.ChangeDateFormat
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 |
Interval | Enter the value for the format you want to update the date into. Value for this parameter can be as follows:
| 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:
Date.ChangeDateFormat “02/28/2001” “1” “Key”
Post execution, Qualitia will store Monday, February, 2010 in the key.
DB.ExecuteDDLQueryAndStoreInFile
This action executes Data Definition Language (DDL) queries and stores the result set of the fired query in a text file.
Prerequisite:
Before using this action, ensure that the required databases and database drivers are installed.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
ConnectionString | The ConnectionString 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"
- MS SQL:
DB.ExecuteDDLQueryAndStoreInFile “DRIVER=~{SQL Server~}; 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"
DB.ExecuteDMLQueryAndStoreinKey
This action executes Data Manipulation Language (DML) queries such as update, delete and so forth and stores the query execution status into the specified key. If the query gets executed successfully, stores 0 and if the query does not get executed, stores 1.
Prerequisite:
Before using this action, ensure that the required databases and database drivers are installed.
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 |
---|---|---|---|
ConnectionString | The ConnectionString 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:
- MySQL:
DB.ExecuteDMLQueryAndStoreInKey “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.ExecuteDMLQueryAndStoreInKey “DRIVER=~{SQL Server~}; Server=192.168.24.99,1234;Database=ProductInfo UID=Qualitia;PWD=Qualitia”
"select * from productinfo.keyword where keywordid = 'c0ab6ad8f67234b'" "ProductInfo"
DB.ExecuteDDLQueryandStoreDatainKey
This action executes Data Definition Language (DDL) queries and stores the result data set in the specified key. In case of finding multiple data sets, this action will fail.
Prerequisite:
Before using this action, ensure that the required databases and database drivers are installed.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
ConnectionString | The ConnectionString 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”
"select * from productinfo.keyword where keywordid = 'c0ab6ad8f67234b'" "ProductInfo"
File.CompareFileContents
This action compares two text files and validates whether content inside them is identical.
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.
| Yes | String |
IgnoreWhitespace | Enter whether you want to consider whitespaces when comparing file contents. Value for this parameter can be True or False.
| Yes | Boolean |
Example:
File.CompareFileContents “C:\Users\admin\Downloads\Cust_Info.xlsx” “C:\Users\admin\Downloads\Client_list.xlsx” “False” “True”
FILE.StoreStringByLineNumber
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”
FILE.VerifyStringExistInFile
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.
| Yes | String |
Example:
FILE.VerifyStringExistInFile “C:\Users\admin\Downloads\Cust_Info” “Qualitia” “True”
File.VerifyFileExist
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”
File.VerifyFolderExist
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”
PDF.VerifyStringExistInPDF
This action searches specified text in the PDF file.
Prerequisite:
Before executing this action, ensure you:
- Download XPDF Tools and
- Add XPDF tools directory to system path environment variables.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
pdfFile | Enter the absolute path to the PDF file in which you want to find the text. | Yes | String |
textToFind | Enter the text you want to find in the specified PDF file. | Yes | String |
Example:
PDF.VerifyStringExistInPDF “C:\Users\Qualitia\Cust_List.pdf” “Qualitia”
PDF.VerifyStringExistInPDFPage
This action searches specified text on the specified page of the PDF file.
Prerequisite:
Before executing this action, ensure you:
- Download XPDF Tools and
- Add XPDF tools directory to system path environment variables.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
pdfFile | Enter the absolute path to the PDF file in which you want to find the text. | Yes | String |
textToFind | Enter the text you want to find in the specified PDF file. | Yes | String |
pageNumber | Enter the page number on which you want to search the specified text. | Yes | String |
Example:
PDF.VerifyStringExistInPDFPage “C:\Users\Qualitia\Cust_List.pdf” “Qualitia” “2”
PDF.ComparePDF
This action compares two PDFs and validates whether content inside them is identical and stores differences in the temporary text file.
Prerequisite:
Before executing this action, ensure you:
- Download XPDF Tools and
- Download and install GnuWin
- Add XPDF Tools and GnuWin installation directory to system path environment variables.
For example: D:\XPDF\xpdf-tools-win-4.00;C:\Program Files (x86)\GnuWin32\bin
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
Pdf1 | Enter the absolute path to the PDF file which you want to compare. | Yes | String |
Pdf2 | Enter the absolute path to the PDF file with which you want to compare the source file. | Yes | String |
diffFilePath | Enter the absolute path to the text file in which you want to store the PDF comparison results. | Yes | String |
Example:
PDF.ComparePDF “C:\Users\Qualitia\Cust_List.pdf” “C:\Users\Qualitia\Client_List.pdf” “C:\Users\Qualitia\Diff.txt”
XML.SetNodeValue
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 |
---|---|---|---|
fileName | 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:
XML.SetNodeValue
“C:\Users\Qualitia\Cust_List.xml” “//DataSet[@ID='394502re33']/Step/Param[@ParamSeq='4']” “Qualitia Automation Studio”
XML.StoreNodeValue
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 |
---|---|---|---|
fileName | 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 (X Path) 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\Cust_List.xml” “//DataSet[@ID='106cee8f60']/Step/Param[@ParamSeq='4']” “Key”
JSON.StoreJsonString
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 |
Index | Enter the index number which results you want to store in the specified key. Index starts from 0. | Yes | String |
attributeName | Enter the attribute name whose value you want to save under the specified key. | No | String |
Key | Enter the key name under which you want to store the attribute value. | Yes | String |
Example:
JSON.StoreJsonString “C:\Users\Qualitia\Cust_List.json” “$.Customers.Country[0].India” “3” “Name” “Key”
JSON.UpdateJsonString
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 |
Jpath | Enter the path to the node (J Path) to which you want to set the value. | Yes | String |
Index | 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 | String |
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”
FILE.StoreCharacterCount
This action stores the total number of characters present in the specified text file.
Line breaks are considered as characters while counting characters from the file. One line break is equal to 2 characters.
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.
Note: Only leading and trailing whitespaces will be ignored if you set this parameter to True. Whitespaces inside the text will not be considered. | Yes | Boolean |
Example:
FILE.StoreCharacterCount “C:\Users\admin\Downloads\Cust_Info” “Key” “True”
StoreRandomNumber
This action picks up any random number from the specified range and stores that number in the specified key. The key value can be retrieved using the key name.
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:
Data.StoreRandomNumber “123” “890” “Key”
REST.ExecuteServiceRequest
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 |
Pwd | 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”
“C:\Users\Qualitia\Request-Cust_List.json” “C:\Users\Qualitia\Response-Cust_List.json”
SOAP.ExecuteServiceRequest
This action executes the specified SOAP request in the specified XML file. You can also store response in the XML file, if required.
Prerequisites:
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. | Yes | String |
Username | Enter the username if the authentication type selected is Basic. | No | String |
Pwd | 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. | No | String |
methodName | Enter the method name which you want to use when executing the SOAP request. | Yes | String |
resXmlPath | Enter the absolute path to the XML file where the response will be stored. | Yes | 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”
CompareNumbers
This action compares and validates the numbers based on specified the comparison operator.
In case of not matching the expected results, Qualitia reports a defect in the execution reports.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
FirstNumber | Enter the number which you want to compare. | Yes | String |
ComparisionOperator | Enter the comparison operator for the number validation. Value for this parameters can be as follows:
| Yes | String |
SecondNumber | Enter the number with which you want to compare the first number. | Yes | String |
Example:
CompareNumber "21" "<" "20"
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 |
String | 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 |
Compare | Enter whether you want to consider case-sensitivity when comparing the string before replacement. Value for this parameter can be 0 or 1.
| No | String |
Example:
ReplaceStringBySubString "Key" "Australia" "A" "B" "1" "-1" "0"
ChangeCaseAndStore
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:
| Yes | String |
Example:
ChangeCaseAndStore "Key" "Qualitia" "Upper"
StoreFixNumber
This action stores the integer part of a specified number into the specified 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 in which you want to store the updated string. | Yes | String |
Number | Enter the number from which you want to store the integer part. | Yes | String |
Example:
StoreFixNumber "Key" "6.4332"
StoreRoundNumber
This action stores values specified by the user by rounding them off to the nearest whole number. The rounded off value stored in the key 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 rounded value. | Yes | String |
Number | Enter the number whose value you want to store into the key. | Yes | String |
Example:
StoreRoundNumber "key" "6.43"
- In this case, 6 will be stored into the key.
StoreRoundNumber "key" "6.55"
- In this case, 7 will be stored into the key.
StoreStringToInteger
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"
StoreStringConcat
This action concatenates (combines) two strings specified by the user and stores into the specified key. The key value can be retrieved using the key name.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
String1 | Enter the string first string. | Yes | String |
String2 | Enter the another string. | Yes | String |
Key | Enter the key name under which you want to store the combined value. | Yes | String |
Example:
StoreStringConcat "String1" "String2" "Key"
StoreMatchesFromRegExPattern
This action fetches all the matches of a regular expression pattern from an InputString and stores the array of all the matches into the specified key. The key value can be retrieved using the key name.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
RegExPattern | Enter the regular expression pattern. | Yes | String |
InputString | Enter the data from which you want to store the element. | Yes | String |
Key | Enter the key name under which you want to store the matching element. | Yes | String |
Example:
StoreMatchesFromRegExPattern "Cust1(\d?)" "CustKey1 CustKey123Cust321" "Key"
Array.AddItem
This action adds the specified element in the existing array.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
ArrayKey | Enter the key that holds an array data where you want to add this additional element. | Yes | String |
Element | Enter the element which you want to add into the existing array. | Yes | String |
Example:
Array.AddItem "ArrayKey" "Sunday"
Array.DeleteItem
This action deletes the specified element from an existing array.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
ArrayKey | Enter the key that holds an array data from where you want to remove the element. | Yes | String |
Index | Enter the index of an element which you want to remove. | Yes | Integer |
Example:
Array.DeleteItem "ArrayKey" "2"
Array.IsArray
This action verifies whether the specified data is in the array form. If the data is not an array, reports a defect in the execution report.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
ArrayKey | Enter the key that holds an array data which you want to verify. | Yes | String |
Example:
Array.IsArray "ArrayKey"
Array.JoinArrayAndStore
This action joins the substrings from an existing array and stores them into the specified key. By default, these substrings are separated by the caret sign (^). The key value can be retrieved using the key name.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
ArrayKey | Enter the key that holds an array data which you want to join. | Yes | String |
Key | Enter the key name under which you want to store the joined array. | Yes | String |
Example:
Array.JoinArrayAndStore "ArrayKey" "Key"
Array.Reverse
This action reverses the existing sequence of data given in an array.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
ArrayKey | Enter the key that holds an array data which you want to modify the sequence of. | Yes | String |
Example:
Array.Reverse "ArrayKey"
Array.Sort
This action sorts the existing array data in an ascending order.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
ArrayKey | Enter the key that holds an array data which you want to sort in an ascending order. | Yes | String |
Example:
Array.Sort "ArrayKey"
Array.StoreArrayLength
This action stores the length of an existing array into the specified key. The key value can be retrieved using the key name.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
ArrayKey | Enter the key that holds an array data whose length you want to store. | Yes | String |
Key | Enter the key name under which you want to store the array length. | Yes | String |
Example:
Array.StoreArrayLength "ArrayKey" "Key"
Array.StoreElementByIndex
This action stores the element from the specified index of an array into the specified key. The key value can be retrieved using the key name.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
ArrayKey | Enter the key that holds an array data from which you want to store the element. | Yes | String |
Index | Enter the index of the element which you want to store. | Yes | Integer |
Key | Enter the key name under which you want to store the element. | Yes | String |
Example:
Array.StoreElementByIndex "ArrayKey" "5" "Key"
Array.StoreElementIndex
This action stores the index of the specified element from an existing array into the specified key. The key value can be retrieved using the key name.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
ArrayKey | Enter the key that holds an array data from which you want to store the element index. | Yes | String |
Element | Enter the element which you want to store. | Yes | String |
Occurrence | Enter the number of occurrence from the array which you want to store. | Yes | String |
CaseSensitive | Enter whether you want to consider case-sensitivity when comparing content. Value for this parameter can be True or False.
| Yes | String |
Key | Enter the key name under which you want to store the index of an element. | Yes | String |
Example:
Array.StoreElementIndex "ArrayKey" "Sunday" "1" "True" "Key"
Array.VerifyElementExist
This action verifies whether the specified item exists in an array and reports a defect in case of not finding the specified item.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
ArrayKey | Enter the key that holds an array data from which you want to verify the element. | Yes | String |
Element | Enter the element which you want to verify. | Yes | String |
CaseSensitive | Enter whether you want to consider case-sensitivity when comparing content. Value for this parameter can be True or False.
| Yes | String |
Example:
Array.VerifyElementExists "ArrayKey" "Sunday" "True"
LeftTrimAndStore
This action removes or trims the blank spaces existing at the extreme left side of the specified string and stores the value under the specified key. The key value can be retrieved using the key name.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
InputString | Enter the string from which you want to trim the blank space. | Yes | String |
Key | Enter the key name under which you want to store the final value. | Yes | String |
Example:
LeftTrimAndStore " John and family" "Key"
In this case, the John and family will be stored under key. The blank space before john will be removed.
RightTrimAndStore
This action removes or trims the blank spaces existing at the extreme right side of the specified string and stores the value under the specified key. The key value can be retrieved using the key name.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
InputString | Enter the string from which you want to trim the blank space. | Yes | String |
Key | Enter the key name under which you want to store the final value. | Yes | String |
Example:
RightTrimAndStore "John and family " "Key"
In this case, the John and family will be stored under key. The blank space after john and family will be removed.
StoreAbsoluteValue
This action stores the absolute value of the specified number under the key name. The key value can be retrieved using the key name.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
Integer | Enter the integer whose absolute value you want to store. | Yes | String |
Key | Enter the key name under which you want to store the absolute value. | Yes | String |
Example:
StoreAbsoluteValue "-3.6" "Key"
In this case, the 3.6 will be stored under key.
StoreIntegerSign
This action stores an integer that indicates sign of the number specified in the parameter. The key value can be retrieved using the key name.
- If number is greater than 0, stores 1.
- If number is equal to 0, stores 0.
- If number is lesser than 0, stores -1.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
Number | Enter the number whose integer value you want to store. | Yes | String |
Key | Enter the key name under which you want to store the integer value. | Yes | String |
Example:
StoreIntegerSign "-12" "Key"
In this case, the -1 will be stored under key because the number is lesser than 0.
StoreSqRoot
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 |
---|---|---|---|
Number | Enter the number whose square root you want to store. | Yes | String |
Key | Enter the key name under which you want to store the square root. | Yes | String |
Example:
StoreSqRoot "144" "Key"
In this case, the 12 will be stored under key.
StoreStringFromLeft
This action stores the specified number of characters from the left side of the given string. The key value can be retrieved using the key name.
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 | String |
Key | Enter the key name under which you want to store the specified number of characters. | Yes | String |
Example:
StoreStringFromLeft "John Doe" "4" "Key"
In this case, the first four characters i.e. Jonn will be stored under the key name.
StoreStringFromRight
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 | Integer |
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.
StoreRandomString
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 | Integer |
Example:
StoreRandomString "Key" "23"
StoreRandomAlphanumericString
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 | Integer |
Example:
StoreRandomAlphanumericString "Key" "33"
LaunchApplication
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:
| 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.
| No | Integer |
Example:
LaunchApplication "C:\Application.exe"
TypeKey
This action simulates the keystroke events specified into the parameter.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
Key | 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"
TypeString
This action simulates the keyboard inputs specified into the parameters.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
Text | Enter the string which you want to type. | Yes | String |
Example:
TypeString "qualitiasoft.com"
Clipboard.Copy
This action copies the data given into the parameter to clipboard.
Input Parameters:
Parameter Name | Parameter Description | Mandatory | Data Type |
---|---|---|---|
Text | Enter the text to add to the clipboard memory. | Yes | String |
Example:
Clipboard.Copy "Qualitia Software Pvt. Ltd."
StoreClipboardData
This action stores the data present on the clipboard into the specified key. The key value then 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 data. The key value then can be retrieved using the key name. | Yes | String |
Example:
StoreClipboardData "key"
Clipboard.Clear
This action clears the data present on the clipboard memory.
This action does not have any input parameters.
Example:
Clipboard.Clear