Versions Compared

Key

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

Multiexcerpt include macro
nameVerifyExistence
pageWebButton Actions

Multiexcerpt include macro
nameVerifyVisibility
pageWebButton Actions

StoreColumnCount

This action verifies stores the existence of column count of the specified table under the specified objectkey. 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

existence

Value of this parameter can be true or false.
If True – checks if the object exists
If False – checks if the object does not existkey

Enter the variable name to store table's column count.

Yes

String

row

Enter the row number whose column count you want to store.

Yes

String

Example:
VerifyExistence StoreColumnCount                            "key"             "True2"

VerifyVisibility

StoreRowCount

This action verifies stores the visibility row count of the specified objecttable under the specified key.  

Input Parameters:

VerifyVisibility

Parameter Name

Parameter Description

Mandatory

Data Type

visibility

Value of this parameter can be true or false.
If True – checks if the object is visible
If False – checks if the object is invisible

Yes

String

Example:

key

Enter the key name under which you want to store table's row count.

Yes

String


Example:
StoreRowCount                             "TrueKey"

StoreColumnCount

On this page:

Table of Contents
maxLevel2
minLevel2
absoluteUrltrue

StoreCellText

This action stores the

column count

text of the specified table

in

cell 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 name

to store the table's column count

in which the cell text is to be stored.

Yes

String

row

Row

The row number

whose column count has to be stored

of the cell. Row number starts at 1.

Yes

String

Column

The column number of the cell. Column number starts at 1.

Yes

String


Example:

StoreColumnCount

StoreCellText             "cellTextKey"                "1"     

"key"

       

 

"

2

3"

StoreRowCount

ClickLinkAtCell

This action

stores the row count of the specified table under the specified key.  

clicks the link present in the specified cell.

This is applicable for tables having same number of columns in all the rows.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

key

The variable name to store the table's row count.

Link

Enter the URL to be clicked.

Yes

String

Row

Enter the row number of the cell in which the link is present. Row number starts at 1

Yes

String

Column

Enter the column number of the cell in which the link is present. Column number starts at 1

Yes

String


Example:

StoreRowCount

ClickLinkAtCell              "http://www.google.com"             "2"          "

Key

3"

On this page:

Table of Contents
maxLevel2
minLevel2
absoluteUrltrue

StoreCellText

This action stores the text of a table cell in a variable. The stored value can be retrieved using the variable name. 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

key

The variable name in which the cell text is to be stored.

Yes

String

Row

The row number of the cell. Row number starts at 1.

Yes

String

Column

The column number of the cell. Column number starts at 1.

Yes

String

Example:
StoreCellText
Note

If Link is an empty data ("" or $NULL$), and there are multiple links in the cell, then the first link in the cell will be clicked. If there is only one link in the cell, then the link will be clicked. However, if there is no link available in the cell, the action will fail with an error message that no link is available in the cell.

StoreRowNoOfCellText

This action stores the row number of the cell having the specified data in a specified column. This comparison is case-sensitive. When multiple cells in the column specified contain the expected data, then the first row number is stored under the specified key. This is also applicable for tables where each row in the table has different number of columns.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Key

The variable in which the row number is to be stored.

Yes

String

cellText

Cell data to be searched for in the table.

Yes

String

Column

Column number of the cell data to be searched for. Column number starts at 1.

Yes

String

Example:
StoreRowNoOfCellText                             "key"                   "cellTextKeyTesting"        "1"        "3"

ClickLinkAtCell

This action clicks the link present in the specified cell.

This is applicable for tables having same number of columns in all the rows.2"

Multiexcerpt include macro
nameClick
pageWebButton Actions

Multiexcerpt include macro
nameStorePropertyValue
pageWebButton Actions

ClickImageInCell

This action clicks the image from the specified cell. 

Input Parameters:

Note

If Link is an empty data ("" or $NULL$), and there are multiple links in the cell, then the first link in the cell will be clicked. If there is only one link in the cell, then the link will be clicked. However, if there is no link available in the cell, the action will fail with an error message that no link is available in the cell.

StoreRowNoOfCellText

This action stores the row number of the cell having the specified data in a specified column

Parameter Name

Parameter Description

Mandatory

Data Type

Link

altorindex

Enter

the URL to be clicked.

Yes

String

Row

The row number of the cell in which the link is present. Row number starts at 1

Yes

String

Column

The column number of the cell in which the link is present. Column number starts at 1

Yes

String

Example:
ClickLinkAtCell                         "http://www.google.com"             "2"       "3"

any of the attribute of the image. This can be alt or title. This parameter can also be an index. Index starts from 1. Following will be the preference in which the action will assume the incoming data:
If the data is a number then it will be considered as index, else, the first preference then goes to title. If an image with specified title is found then click, otherwise, search for an image with property. 
Alt = incoming data

Yes

String

Row

Enter the row number of the cell in which the image is present. Row number starts at 1.

Yes

String

Column

Enter the column number of the cell in which the image is present.

Yes

String

Example:
ClickImageInCell              "2"                "2"           "3"

StoreRowNoContainingCellText

This action stores the row number of the cell whose data contains the text specified by the user. This comparison is case-sensitive .When multiple cells in the column specified contain the expected data, then the first row number is shall be stored in the variable. This can also be applicable for tables where each row in the table has different number of columns. 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Key

The variable in Enter the key name under which the row number is to will be stored.

Yes

String

cellText

Cell Enter the cell data you want to be searched for search in the table.

Yes

String

ColumnColumn

Enter the column number of the cell data to be searched for. Column number starts at 1.in which the data is present.

Yes

String


Example:
StoreRowNoOfCellText           StoreRowNoContainingCellText                "key"                   "Testingword"         "2"

Click

SetTextinCellEdit

This action clicks sets text in the specified object.

This action does not have any parameter. 

Example:
Click

StorePropertyValue

This action stores the property value of the specified object against a key name. The stored value can be retrieved by using the key name.
Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

key

Variable in which the property value will be stored

cell of the table.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Row

Enter the row number of the cell in which you want to enter the data. Row number starts at 1.

Yes

String

Column

Enter the column number of the cell in which you want to enter the text. Column number starts at 1.

Yes

String

Property

Property/attribute name of the object whose value needs to be stored.
This can be any apt attribute of that html object.
This action also supports "text" as the property. "Text" property will retrieve the inner text of an element.text

Enter the text you want to enter in the cell.

Yes

String

Example:
StorePropertyValue SetTextinCellEdit                                  "3"            "value2"           "nameQualitia"

ClickImageInCell

SecureSetTextinCellEdit

This action clicks sets the specified image text in the specified cell of the table. Once you move focus from the cell, Qualitia encrypts the text for security purpose.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

altorindex

This can be any of the attribute of the image alt or title. This parameter can also be an index[starting from 1].
Following will be the preference in which the action will assume the incoming data:
If the data is a number
Then it will be considered as index
Else
The first preference then goes to title. If an image with specified title is found then click, otherwise, search for an image with property
Alt = incoming data

Row

Enter the row number of the cell in which you want to enter the text. Row number starts at 1.

Yes

String

Column

Enter the column number of the cell in which you want to enter the text. Column number starts at 1.

Yes

String

Row

The row number of

text

Enter the text which you want to add in the cell in

which

the

image is present. Row number starts at 1

Yes

String

Column

The column number of the cell in which the image is present

Yes

specified format.

Format: Encrypt(<TEXT TO BE ADDED>)

No

String

Example:
ClickImageInCell               SetTextinCellEdit                          "2"3"                "2"          "3Encrypt(Abc)"

StoreRowNoContainingCellText


Note
This action stores the row number of the cell whose data contains the text specified by the user. This comparison is case-sensitive .When multiple cells in the column specified contain the expected data, then the first row number shall be stored in the variable

When the focus is moved away from the parameter, Qualitia will automatically encrypt the data ABC and result in a secured text like "vHpmlfI4R3PQkCN4sZnuqw==þNWE3ZDdkNjE3N2JmNDM2ODgxMzQwYWI1MTA3YWNjMDc="

DeSelectCheckBoxInCell

This action deselects the check box from the specified table cell. This can also be applicable for tables where each row in the table has have different number of columns. 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Key

The variable in which

Row

Enter the row number

is to be stored

Yes

String

cellText

Cell data to be searched for in the table

Yes

String

Column

The column number of the cell in which the data is present

Yes

String

Example:
StoreRowNoContainingCellText

from where you want to select the check box. Row number starts at 1.

Yes

Integer

Column

Enter the column number from where you want to select the check box. Row number starts at 1.

Yes

Integer

Example:
DeSelectCheckBoxInTableCell                              "key"          "word2"          "25"

SetTextinCellEdit

This action sets text in the specified cell of the table.

This will deselect the check box present in the second row and the fifth column cell in the table. If the check box is already deselected then the action will pass.

CompareRowData

This action compares the entire record in the specified row with the expected array data.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

RowThe

Enter the row number of the cell in which the text is to be enteredfrom which you want to compare the data. Row number starts at from 1.

Yes

String

Integer

Column

The column number of the cell in which the text is to be entered. Column number starts at 1rowData

Enter the entire row data expected to be present in a specified row. Separate multiple items with carat (^) operator.

Yes

String

Array.

text

The text data to be entered in the cell.

Yes

String

Example:
SetTextinCellEdit Example:
Consider a table containing the data India, Australia, England in row 2. If this data needs to be verified, the action can be used as follows.

CompareTableRowData                      "2"              "3"       "2"    "Qualitia"

SecureSetTextinCellEdit

India^Australia^ England"

CompareColumnData

This action sets secured text compares the entire record in the specified cell of the tablecolumn with the expected array data.

This is only applicable for tables having the same number of columns in all the rows.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Row

The row number of the cell in which the text is to be entered. Row number starts at Column

Enter the column number of table from which you want to compare the data. Column starts from 1.

Yes

String

Integer

ColumncolData

The column number of the cell in which the text is to be entered. Column number starts at 1.

Yes

String

text

Needs to use Encrypt to enclose the Text that needs to be secured

NO

String

Example:
SetTextinCellEdit        "3"

Enter the entire column data expected to be present in a specified column. Separate multiple items with carat (^) operator. 

Yes

Array

Example:
Consider a table containing the data India, Australia, England in Column 4. If this data needs to be verified, the action can be used as follows:
CompareColumnData                        "24"                "Encrypt(Abc)  "India^Australia^ England"

note

VerifyDataExistenceInColumn

When the focus is moved away from the parameter, Qualitia will automatically encrypt the data ABC and result in a secured text like "vHpmlfI4R3PQkCN4sZnuqw==þNWE3ZDdkNjE3N2JmNDM2ODgxMzQwYWI1MTA3YWNjMDc="

DeSelectCheckBoxInCell

This action deselects the check box in the specified table cell. This can also be applicable for tables where each row in the table have different number of columnsThis action verifies the existence of the expected data in the specified column. The expected data can be a sub-list of the actual column data in the table.

This is only applicable for tables having the same number of columns in all the rows.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Row

The row number to refer to a particular cell of table where a check box is expected to be present. Row

Column

Enter the column number table where you want to verify the data. Column number starts at 1.

Yes

Integer

Column

The column number to refer to a particular cell of table where a check box is expected to be present. Column number starts at 1.

Yes

Integer

Example:
DeSelectCheckBoxInTableCell    

data

Enter the data to be searched in a column. Separate multiple items with carat (^) operator. 

Yes

Array

existence

Value of this parameter can be either true or false.

  • Set True if you want to check the existence.
  • Set False if you want to check the non-existence.

Yes

String

Example:
VerifyDataExistenceInColumn       "2"            "Test"          "True" 

This will verify if the data Test is present in the column 2 of the table.

VerifyDataExistenceInColumn        "2"            "Test"       "5False"

This will deselect the check box verify if the data Test is not present in the second row and the fifth column cell in column 2 of the table. If the check box is already deselected, then the action will pass.

CompareRowData

StoreInstanceOfDataFromColumn

This action compares the entire record in the specified row with the expected array datastores the number of occurrences of the specified data in columns. The data comparison is case-sensitive.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Row

Row number in which data will be compared. Row number starts from

Key

Enter the key name under which you want to store the occurrences.

Yes

String 

Column

Enter the column number where you want to search the data. Column number starts at 1.

Yes

Integer

rowData

The entire row data expected to be present in a specified row.
This is an array data hence it will be demarcated by ^.

Yes

Array.

Example:
Consider a table containing the data India, Australia, England in row 2. If this data needs to be verified, the action can be used as follows.

CompareTableRowData      "2"

Data

Enter the data you want to search in the specified column.

Yes

String

Example:
StoreInstanceOfDataFromColumn          "result"        "3"         "India^Australia^ EnglandQualitia"

CompareColumnData

StoreRowNumWithRowData

This action compares the actual data from the specified column in a table with the specified array data. This is only applicable for tables having the same number of columns in all the rowsstores the row number of the table which contains the specified data.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Column

Column number of table in which the data will be compared. Column starts from 1rowData

Enter the entire row data expected to be present in a specified row.
Separate multiple items with carat (^) operator.

Yes

Integer

Array

colData

The entire column data expected to be present in a specified column.
This is an array data hence it will be demarcated by ^Key

Enter the key name under which the row number will be stored.

Yes

Array

String

Example:
Consider a table containing the following data:

  • India is in column 1 of a row,
  • Australia is in column 3 of the same row,
  • England
in Column 4. If this data needs to be verified
  • is in column 6 of the same row,

If the row number for this entry is to be retrieved, the action can be used as follows:

CompareColumnData StoreRowNumWithRowData                                    "4"1^India^3^Australia^6^ England"       "India^Australia^ EnglandRowNumber"

VerifyDataExistenceInColumn

This action verifies whether the expected data exists in the specified column. The expected data can be sub-list of the actual column data in the table.

This is only applicable for tables having the same number of columns in all the rowsThus it will check the data "India" in the first column of the table, "Australia" in the third column and "England" in the 6th column in a particular row. Thus, the data needs to be present in the same row.

SelectCheckboxInCell

This action selects a check box from the specified cell of the table. This can also be applicable for tables where each row in the table have different number of columns.

This step will pass if the check box is already selected.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Column

The column number to refer to a particular cell of table where the data is to be searched. Column Row

Enter the row number of the cell from which you want to select the checkbox. Row number starts at 1.

Yes

Integer

String

data

Data to be searched in a column. Multiple items can be separated with the (^)column

Enter the column number of the cell from which you want to select the checkbox. Column number starts at 1.

Yes

Array

String

existence

Data type of this parameter can be true or false.
If True – checks if the data exists.
If False – checks if the data does not exist.

Yes

String

Example:
VerifyDataExistenceInColumn       "2"            "Test"          "True" 

This will verify if the data Test is present in the column 2 of the table.

VerifyDataExistenceInColumn        "2"            "Test"       "False"

This will verify if the data Test is not present in the column 2 of the table.

StoreInstanceOfDataFromColumn

This action stores the number of occurrences of the specified data in columns. The data comparison is case-sensitive.

Input Parameters:

Example:
SelectCheckboxInCell          "2"         "3"

VerifyImageInCell

This action verifies that the image present in the specified cell is having the specified scr/title attribute.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Key

The variable in which the number of occurrences will be stored

Row

Enter the row number of the cell from which you want to verify the image. Row number starts at 1.

Yes

String 

String

Column

column

The

Enter the column number

to refer to a particular cell

of

table where the data is to be searched. Column

the cell from which you want to verify the image. Column number starts at 1.

Yes

Integer

String

Data

Data to be searched in a column.

Yes

String

Example:
StoreInstanceOfDataFromColumn

ScrTitle

Enter either the scr or title data of the image.
First the source property will be compared with the actual source and if not present then the title property will be verified.

Yes

String

Example:
VerifyImageIncell              "result4"             "36"         "QualitiaReview"

StoreRowNumWithRowData

Multiexcerpt include macro
nameClickAt
pageWebButton Actions

VerifyLinkTitleAtCell

This action stores the row number of the table which contains the specified row data.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

rowData

The entire row data expected to be present in a specified row.
The data needs to be separated using Caret (^).

Yes

Array

Key

The variable in which the row number is to be stored

Yes

String

Example:
Consider a table containing the data
India is in column 1 of a row,
Australia is in column 3 of the same row,
England is in column 6 of the same row,
If the row number for this entry is to be retrieved, the action can be used as follows

StoreRowNumWithRowData                                         "1^India^3^Australia^6^ England"    "rowNo"

Thus it will check the data "India" in the first column of the table, "Australia" in the third column and "England" in the 6th column in a particular row. Thus, the data needs to be present in the same row.

SelectCheckboxInCell

This action selects a checkbox from the specified cell of the table. This can also be applicable for tables where each row in the table have different number of columns.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Row

The row number of the cell in which the checkbox to be clicked is present. Row number starts at 1.

Yes

String

column

The column number of the cell in which the checkbox to be clicked is present. Column number starts at 1.

Yes

String

Example:
SelectCheckboxInCell          "2"         "3"

If the check box is already selected, the action will pass.

VerifyImageInCell

This action verifies that the image present in the specified cell is having the specified scr/title attribute.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Row

The row number of the cell in which the image is to be verified. Row number starts at 1.

Yes

String

column

The column number of the cell in which the image is to be verified. Column number starts at 1.

Yes

String

ScrTitle

Either the scr/title data of the image.
The order of precedence is, first verify the source property with the actual source, if not present then verify the title property.

Yes

String

Example:
VerifyImageIncell                             "4"          "6"         "Review"

ClickAt

This action clicks at the particular point on the object.
Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

X

The X-coordinate of the click.

Yes

String

Y

The Y-coordinate of the click.

Yes

String

Example
ClickAt        "5"     "10"

VerifyLinkTitleAtCell

This action verifies title of link in the given cell. It does not perform an exact match. It performs a contains match.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

link

Title data of the link

Yes

String

row

The row number of the cell in which the link title is to be verified. Row number starts at 1.

Yes

String

column

The column number of the cell in which the link title is to be verified. Column number starts at 1.

Yes

String

Example
VerifyLinkTitleAtCell ClickHere                                "5"      "10"

ClickCell

This action clicks at the specified cell in the table.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

row

The row number of the cell that is to be clicked. Row number starts at 1.

Yes

String

column

The column number of the cell that is to be clicked. Column number starts at 1.

Yes

String

Example
ClickCell   "5"      "10"

ClickRadioButtonInCell

This action clicks a radio in the specified cell of the table. This can also be applicable for tables where each row in the table has different number of columns.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

row

The row number of the cell in which the radio button to be clicked is present. Row number starts at 1.

Yes

String

column

The column number of the cell in which the radio button to be clicked is present. Column number starts at 1.

Yes

String

Example:
ClickRadioButtonInCell                "2"            "3"

StoreTableData

This action stores the data of multiple columns in a table into a file. To store the data laid out in the table across multiple pages, the parameter "noOfPageNext" can be used.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

locatorOfPageNext

The locator of the object which is used to navigate to the next page. If the table is not to be navigated, then this parameter can be "". The locator has to be only an XPATH

Yes

String

columsToStore

The index of columns whose data needs to be stored in the file. If multiple columns need to be stored, then separate the column index with the carat operator

Yes

Array

noOfPageNext

To store the data laid out in a table across multiple pages, set the no of times page next needs to be clicked. If only the current page table data needs to be stored, this parameter should be set to "0".

Yes

String

fileToStore

The complete path of the file which in which the data needs to be stored. The file types supported are xml, xmls and txt. The valid extensions are
For text file - .txt
For xml file- .xml
For excel file- .xls

Yes

String

Example
StoreTableData     verifies title of link in the given cell. It does not perform an exact match. It performs a contain match.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

link

Enter the title data of the link.

Yes

String

row

Enter the row number of the cell in which you want to verify the link. Row number starts at 1.

Yes

String

column

Enter the column number of the cell in which you want to verify the link. Column number starts at 1.

Yes

String

Example
VerifyLinkTitleAtCell                                       "//[@id=":cf"]"ClickHere"        "1^2^3 2"                 "05"      "C:\DBResults\Excel\ORACLE\Result.xls10"

StoreColumnNumber

ClickCell

This action stores the column number with the specified column name. This is only applicable for tables having same number of columns in all the rowsclicks the specified cell from the table.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

key

The variable in which the column number is to be storedrow

Enter the row number of the cell which you want to click. Row number starts at 1.

Yes

String

columnNamecolumnThe

name of Enter the column whose number is to be storedNonumber of the cell which you want to click. Column number starts at 1.

Yes

String

Example:
StoreColumnNumber ClickCell               "key" 5"                   "Column 110"

WaitForObject

ClickRadioButtonInCell

This action waits for the object to exist or not exist for the maximum no of seconds specified.

If the object is found or not found before the maximum time specified, the action shall stop waiting.

If the wait time is "" then the wait time shall be the "Sync Time" time set on the Qualitia Configuration (Execution) windowclicks a radio button in the specified cell of the table. This can also be applicable for tables where each row in the table has different number of columns.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

waitTime

The maximum no of seconds to wait for the object to exist or not exist 
This has to be 0 ,"",or a positive integer value

row

Enter the row number of the cell from which you want to click the radio button. Row number starts at 1.

Yes

String

existence

Boolean value to specify if the object should exist or not

column

Enter the column number of the cell from which you want to click the radio button. Column number starts at 1.

Yes

String

Example:
WaitForObject ClickRadioButtonInCell           "10"            "true"
The action shall wait for maximum 10 seconds for the object to exist. If the object exists before 10 seconds elapses, the wait shall be over.
WaitForObject         "15"          "False"
The action shall wait for maximum 15 seconds for the object not to exist. If the object does not exist before 15 seconds elapses, the wait shall be over.

StoreColumnData

     "2"            "3"

StoreTableData

This action stores the column data of multiple columns of the table into the specified column number. This is only applicable for tables having same number of columns in all the rows.The data is separated by caret (^). file.

You may use the parameter "noOfPageNext"  if you want to store the data laid out in the table across multiple pages.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

key

The variable in which the column number is to be stored

Yes

String

column

The column number of the cell whose data need to be stored. Column number starts at 1.

Yes

String

Example:
StoreColumnData        "key"         "2"

StoreRowData

This action stores the row data of the column for the specified row number.

The data is separated by caret (^). 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

key

The variable in which the row data is to be stored

Yes

String

row

The row number of the cell whose data need to be stored. Row number starts at 1

locatorOfPageNext

Enter the locator of the object which is used to navigate to the next page. If the table is not to be navigated, then this parameter can be "". The locator has to be only an XPATH

Yes

String

columsToStore

Enter the index of columns whose data you want to store in the file. In you want to store multiple columns, separate the column index with the carat (^) operator.

Yes

Array

noOfPageNext

Set the number of times page next needs to be clicked to store the data laid out in a table across multiple pages. If only the current page table data needs to be stored, this parameter should be set as "0".

Yes

String

fileToStore

Enter the complete path of the file in which you want to store the data. The file types supported are .xml, .xls, and .txt.

Yes

String


Example:
StoreRowData
StoreTableData                                             "key" "//[@id=":cf"]"        "1^2^3 2"                "0"

VerifyDataExistenceInRow

This action verifies whether the expected data exists in the specified row. The expected data can be a sublist of the actual column data in the table     "C:\DBResults\Excel\ORACLE\Result.xls"

StoreColumnNumber

This action stores the column number with the specified column name. This is only applicable for tables having same number of columns in all the rows.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Row

The row number to refer to a particular cell of table where the data is to be searched.
Row number starts at 1.

Yes

Integer

rowData

Data to be searched in a column. Multiple data can be separated with the caret (^) operator.

Yes

Array

existence

Data type of this parameter can be True or false.
If True – checks if the data exists
If False – checks if the data does not exist

NO

TRUE

Example:
VerifyDataExistenceInRow             "2"        "Test"       "True"
This shall verify if the data Test is present in the row 2 of the table

VerifyDataExistenceInRow

key

Enter the key name under which you want to store the column name.

Yes

String

columnName

Enter the column name whose number you want to store. 

No

String

Example:
StoreColumnNumber            "2key"         "Test" "False"
This shall verify if the data Test is not present in the row 2 of the table

RightClick

This action right clicks the specified objectColumn 1"

Multiexcerpt include macro
nameWaitForObject
pageWebButton Actions

StoreColumnData

This action stores the column data of the specified column number. This is only applicable for tables having same number of columns in all the rows.

The data is separated by caret (^)

Input Parameters:

The context menu option number that needs to be clicked

Parameter Name

Parameter Description

Mandatory

Data Type

option

key

Enter the key name under which you want to store the column number.

Yes

String

column

Enter the column number of the cell whose data you want to store. Column number starts at 1.

Yes

String

Example:
RightClick StoreColumnData                 "key"         "32"

This will select the third option in the right click menu.

StoreRowNumberHavingMinCellDataincolumn

StoreRowData

This action stores the row number of the table which contains the minimum value of integer data in from the column specified by user.specified row number.

The data is separated by caret (^). 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Key

The variable in which the row number will be storedkey

Enter the key name under which you want to store data from row. 

Yes

String

Col

The column number to refer to a particular cell of table. Column row

Enter the row number of the cell whose data you want to store. Row number starts at 1.

Yes

Integer

String

Example:
StoreRowNumberHavingMinCellDataincolumn StoreRowData                           "rowNokey"         "42"

StoreRowNumberContainsMaximumValue

VerifyDataExistenceInRow

This action stores the row number of the table which contains the maximum value of integer data in the column specified by userverifies the existence of the specified data in the specified row. The expected data can be a sub-list of the actual column data in the table.

This is only applicable for tables having same number of columns in all the rows.

Input Parameters:

Yes

Parameter Name

Parameter Description

Mandatory

Data Type

Key

The variable in which the row number will be stored

Yes

String

Col

The column number to refer to a particular cell of table.Column number starts at 1.

Data Type

Row

Enter the row number of the table where you want to verify the existence. Row number starts from 1.

Yes

Integer

rowData

Enter the data to be searched in a row. Separate multiple data with the caret (^) operator.

Yes

Array

existence

Value of this parameter can be either True or False.

  • Set True if you want to check for the existence. 
  • Set False if you want to check for the non-existence. 

No

String

Example:
StoreRowNumberContainsMaximumValue VerifyDataExistenceInRow             "2"        "rowNoTest"       "2True"

VerifyTableRowCount

This action verifies the actual row count of the specified table with the expected row count.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

rowCount

The expected row count that will be compared with the actual row count.

Yes

Integer

Example:
VerifyTableRowCount          "6"

VerifyCellText

This action verifies the actual data of the specified cell with the expected cell data.

This comparison is case sensitive.

This shall verify if the data Test is present in the row 2 of the table.

Multiexcerpt include macro
nameRightClick
pageWebElement Actions

StoreRowNumberHavingMinCellDataincolumn

This action stores the row number of the table which contains the minimum value of integer data from the specified column.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

data

The data or text which is to be verified in the table cell.

Yes

String

Row

The row number of the cell. Row number starts at 1Key

Enter the key name under which you want to store the row number.

Yes

String

Col

The Enter the column number of the cellwhere search for the minimum value. Column number starts at 1.

Yes

String

Integer

Example:
VerifyCellText StoreRowNumberHavingMinCellDataincolumn                 "Good Morning"        "2rowNumber"              "34"

ClickLinkAtCellandchooseOkOnConfirmation

StoreRowNumberContainsMaximumValue

This action clicks a link in the specific cell of the table. This is applicable for tables having same number of columns in all the rows. After clicking the link, if an alert or confirmation comes up this action will accept it by clicking on OK. If the link is clicked and no alert or confirmation comes up the action will fail. stores the row number of the table which contains the maximum value of integer data in the column specified by user.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Link

The link url to be clicked.

Yes

String

Row

The row number of the cell in which the link is present. Row number starts at 1Key

Enter the key name under which you want to store the row number.

Yes

String

ColumnCol

The Enter the column number of the cell in which the link is presentwhere search for the maxmum value. Column number starts at 1.

Yes

String


Example:
ClickLinkAtCellandchooseOkOnConfirmation StoreRowNumberContainsMaximumValue                 "rowNumber"                   "http://www.google.com"   "2"

VerifyTableRowCount

This action verifies the actual row count of the specified table with the expected row count.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

rowCount

Enter the expected row count which you want to compare with the actual row count. 

Yes

Integer


Example:
VerifyTableRowCount         "2"     "36" Note: If Link is an empty data ("" or $NULL$), and there are multiple links in the cell, then the first link in the cell will be click. If there are multiple links in the cell with the same text, then the first link will be clicked. However, if there is no link available in the cell, the action will fail with an error message that no link is available in the cell.

ClickAndWait

This action clicks the specified object and waits.

Example:
ClickAndWait

Note

In Webdriver we wait for the document to come in ready state. If it is in ready state it is assumed that the page is loaded completely and Webdriver will stop waiting. The condition to wait till the document is in ready state and assume that the page is loaded could however not work as expected at all times.

StoreRowNoContainingTextInArray

This action stores the row number which contains the combination of text given.

VerifyCellText

This action verifies the actual data of the specified cell with the expected cell data.

This comparison is case-sensitive.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

data

Enter the data which you want to verify in the table cell.

Yes

String

Row

Enter the row number of the cell. Row number starts at 1

Yes

String

Col

Enter the column number of the cell. Column number starts at 1.

Yes

String

Example:
VerifyCellText          "Good Morning"         "2"        "3"

ClickLinkAtCellandchooseOkOnConfirmation

This action clicks a link in the specific cell of the table. This is applicable for tables having same number of columns in all the rows. After clicking the link, if an alert or confirmation appears, this action will accept it by clicking OK.

This step fails if the link is clicked and no alert or confirmation appears. 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Key

The variable in which the row number will be storedLink

Enter the URL to click.

Yes

String

cellText

The text combination which needs to be checked in the columnsRow

Enter the row number of the cell where the link is present. Row number starts at 1.

Yes

Array

String

ColColumn

The Enter the column number of the cell in which where the data combination is to be searchedlink is present. Column number starts at 1.

Yes

String


Example:
StoreRowNoContainingTextInArray ClickLinkAtCellandchooseOkOnConfirmation                              "rowNo     "http://www.google.com"       "John^Smith2"       "3"
This will search for the combination of John and Smith in the column 3 of the table for all the rows.The row which contains this combination will be stored in the key "rowNo"

GenerateAndStoreMaximumValue

This action fetches the column data having the maximum value.It then adds an increment value to it and stores it in a keyNote: If Link is an empty data ("" or $NULL$), and there are multiple links in the cell, then the first link in the cell will be click. If there are multiple links in the cell with the same text, then the first link will be clicked. However, if there is no link available in the cell, the action will fail with an error message that no link is available in the cell.

Multiexcerpt include macro
nameClickAndWait
pageWebButton Actions

StoreRowNoContainingTextInArray

This action stores the row number which contains the combination of specified text.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

KeyThe variable in which the maximum generated data will be stored

Enter the key name under which you want to store the row number. 

Yes

String

Col

The column number of the cell in which the maximum data is to be found. Column number starts at 1

Yes

String

incr

The value by which the maximum data found in the column is to be incremented/decremented.

If this value is "" empty string, then the default increment is 0

NOcellText

Enter the text combination which you want to check in the columns.

Yes

Array

Col

The column number of the cell in which you want to search the combination of data. Column number starts at 1

Yes

String


Example:
GenerateAndStoreMaximumNumber StoreRowNoContainingTextInArray                             "keyrowNo"        "3John^Smith"        "2"

ClickLinkAtCellTH

This action clicks a link in the specific cell of the table header. This is applicable for tables having same number of columns in all the rows"3"
This will search for the combination of John and Smith in the column 3 of the table for all the rows.The row which contains this combination will be stored in the key "rowNo"

GenerateAndStoreMaximumValue

This action fetches the column data having the maximum value. It then adds an increment value to it and stores it under the specified key.

Input Parameters:

ClickLinkTitleAtCell

This action clicks a link based on the title in
The link url to be clicked
The data type is alphanumeric

Parameter Name

Parameter Description

Mandatory

Data Type

Link

No

String

Row

The row number of the cell in which the link is present. Row number starts at 1

Yes

-

Col

The column number of the cell in which the link is present. Column number starts at 1

Yes

-

Example:
ClickLinkAtCellTH                                    "http://www.google.com"     "2"    "3"
Note: If Link is an empty data ("" or $NULL$), then the first link in the cell will be click. If there are multiple links with the same text then the first link will be clicked. However, if there is no link available in the cell, the action will fail with an error message that no link is available in the cell.

Key

Enter the key name under which you want to store the maximum generated value.

Yes

String

Col

Enter the column number of the cell from which you want to find the maximum data. Column number starts at 1.

Yes

String

incr

Enter the value by which the maximum data found in the column is to be incremented/decremented.

If this value is "" empty string, then the default increment is 0.

No

String


Example:
GenerateAndStoreMaximumNumber               "key"            "3"              "2"

ClickLinkAtCellTH

This action clicks a link from the specific cell of the table header. This is applicable for tables having same number of columns in all the rows.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Link

The Enter the link title to be clickedclick.Yes

No

String

Row

The Enter the row number of the cell in which from the link is presentto be clicked. Row number starts at 1.

Yes

String

Col

The column number of the cell in from which the link is presentto be clicked. Column number starts at 1

Yes

String

string


Example:
ClickLinkTitleAtCell ClickLinkAtCellTH                                    "http://www.google.com"                   "2"                "3"
Note: If Link is an empty data ("" or $NULL$), and then the first link in the cell will be click. If there are multiple links in with the cell, same text then the first link in the cell will be clicked. However, if there is no link available in the cell, the action will fail with an error message that no link is available in the cell.

ClickCheckboxInCellTH

ClickLinkTitleAtCell

This action selects the checkbox in the specified header action clicks a link based on the title in the specific cell of the table. This is applicable for tables having same number of columns in all the rows.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Link

Enter the link title which you want to click.

Yes

String

Row

The Enter the row number of the cell in which from the checkbox link is to be clicked is present. Row number starts at 1.

Yes

String

ColumnCol

The column number of the cell in from which the checkbox link is to be clicked is present. Column number starts at 1.

Yes

String


Example:
SelectCheckboxInCell ClickLinkTitleAtCell         "google"       "2"         "3"
If the check box is already selected, the action shall pass.

ClickImageInCellTH

This action clicks the image in the specified cell of the table"3"
Note: If Link is an empty data ("" or $NULL$), and there are multiple links in the cell, then the first link in the cell will be clicked. However, if there is no link available in the cell, the action will fail with an error message that no link is available in the cell.

ClickCheckboxInCellTH

This action selects the check box from the specified header of the table.

This step will pass if the check box is already selected.

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

alt_title

This can be any of the attribute of the image alt or title.
Following will be the preference in which the action will assume the incoming data:
First preference then goes to title. If an image with specified title is found then click else search for an image with property
Alt = incoming data

Yes

String

Row

The Row

Enter the \row number of the cell in from which the image is presentcheckbox is to be clicked. Row number starts at 1.

Yes

String

ColColumn

The Enter the column number of the cell in from which the image is presentcheckbox to be clicked. Column number starts at 1.

Yes

String

Example:
ClickImageInCellTH         SelectCheckboxInCell             "2"        "2"       "3"

StoreExistence

ClickImageInCellTH

This action stores the existence of an object under the specified key. The key value can be retrieved using the key name.clicks the image in the specified cell of the table. 

Input Parameters:

Parameter Name

Parameter Description

Mandatory

Data Type

Key

The variable in which the existence (true/false) of the object is stored.

Parameter Name

Parameter Description

Mandatory

Data Type

Key

The variable in which the child count will be saved.

alt_title

Enter the attribute of the image alt or title. First preference then goes to title and if an image with specified title is found then click, else, search for an image with property. Alt = incoming data

Yes

String

Example:
StoreExistence                             "Key"

StoreChildCount

This action stores the child count of the specified object under the key name. The key value can be retrieved using the key name.

Input Parameters:

Row

Enter the row number of the cell from which the image is to be clicked. Row number starts at 1.

Yes

String

Col

Enter the column number of the cell from which the which the image is to be clicked. 

Yes

String

Example:

StoreChildCount   ClickImageInCellTH          "2"        "2"                 "Key"

ScrollIntoView

This action scrolls to view the specified object. 

This action does not have any parameters. 

Example:

ScrollIntoView

Insert excerptWebButton ActionsWebButton Actionsnopaneltrue"3"

Multiexcerpt include macro
nameStoreExistence
pageWebButton Actions

Multiexcerpt include macro
nameStoreChildCount-withoutlocator
pageWebButton Actions

Multiexcerpt include macro
nameScrollIntoView
pageWebButton Actions

Multiexcerpt include macro
nameActionClick
pageWebButton Actions

Multiexcerpt include macro
nameClickJS
pageWebButton Actions