Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

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”

...

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.

...

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. 

...

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”

...

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

...

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

...

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

...

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

...

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

...

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

...

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”

...

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”

...

StoreSqRoot              "144"             "Key"

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

...

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

...