Search…
Data Table
Data tables are a form of storing the data (within Avo Assure) which can be used to represent the data in a series of rows and columns. The data tables consist of a header row (which contains the names for the columns. These can be considered as the attribute name.) and the cells under these headings should contain meaningful values for the associated header (These can be considered as the attribute values).

Need for Data Table

  1. 1.
    To remove external file dependency.
  2. 2.
    Availability of Data Table for all Avo Assure users.
  3. 3.
    A platform to share the same data among multiple users (via import and export of data tables).

Create Data Table

  1. 1.
    Log in as a valid Avo Assure user, and click on the 'Utilities' plugin from the landing page.
Avo Assure Landing Page
2. Click on the 'Data Table' icon.
Utilities Landing Page
3. The 'Create Data Table' screen is displayed.
4. Enter a unique Data Table Name.
Data Table – Empty Data Table
5. Populate the data values in rows and columns for data parameterization.
Data Table - Creation
6. Components of data table:
  • The first column will show row numbers and can be clicked to select the entire row.
Data Table – Row Number
  • The user can select multiple rows/columns with “Ctrl + Click”.
  • The user can delete row(s)/column(s).
Data Table – Delete icon
  • The user can add a row/column by selecting a single row/column. The new row/column will be added next to the selected row/column. Note:
    • The maximum number of rows supported is 200.
    • The maximum number of columns supported is 50.
Data Table – Adding new row/column
  • The user can rearrange the rows/columns by toggling the 'Drag and Drop' button and dragging the row/column to the desired location.
Data Table – Dragging and Dropping rows/columns
  • The user can undo or redo up to 5 cell changes in the Data Table.
Data Table – Undo/Redo Cell changes
  • The Row '1' is reserved for custom header names which the user can change. These names will be unique. An error message will be displayed, on entering duplicate values in multiple column headers or on leaving any column header empty.
Data Table – Headers
  • The user can copy multiple rows/columns, by selecting multiple rows/columns.
Data Table – Selecting steps to copy
  • The user can paste copied rows/columns by specifying a particular row/column number in the pop-up. Rows/Columns will be copied after the specified row/column identifier.
Data Table – Pasting copied row(s)/column(s)
Data Table – On pasting copied rows
Data Table – On pasting copied columns
Note: The copied rows/columns can be pasted only once. Multiple paste are not allowed.
7. Click on the ‘Create’ button to create/save the populated data table.
Data Table – Created Successfully

Edit Data Table

  1. 1.
    Log in as a valid Avo Assure user, and click on the 'Utilities' plugin from the landing page.
Avo Assure Landing Page
2. Click on the 'Data Table' icon.
Utilities Landing Page
3. Click on the ‘Edit’ button.
Navigating to Edit Data Table Screen
4. Select an existing data table from the dropdown.
Edit Data Table – Data Table Selection
5. Modify the selected data table as required and click on the ‘Update’ button.
6. Data Table gets updated.
Data Table Updated Successfully

Delete Data Table

  1. 1.
    Log in as a valid Avo Assure user, and click on the 'Utilities' plugin from the landing page.
Avo Assure Landing Page
2. Click on the 'Data Table' icon.
Utilities Landing Page
3. Click on the ‘Edit’ button.
Navigating to Edit Data Table Screen
4. Select an existing data table from the dropdown.
Edit Data Table – Data Table Selection
4. Click on the ‘Delete’ button.
Data Table – Edit Screen
6. A confirmation dialogue box will pop up on click of the ‘Delete’ button. Note: If the table is referenced in any of the test cases, a warning message will also be displayed within the confirmation dialogue box.
Data Table – Delete Confirmation
7. If the user wants to continue with deletion, the user can click on the ‘Yes’ button, else the user can click on the ‘No’ button.
8. Data Table gets deleted if the user clicks on ‘Yes’ and a message informing of successful deletion is displayed.
Data Table deleted successfully

Import Data Table

  1. 1.
    Log in as a valid Avo Assure user, and click on the 'Utilities' plugin from the landing page.
Avo Assure Landing Page
2. Click on the 'Data Table' icon.
Utilities Landing Page
3. Click on the ‘Import’ button.
Data Table – Create Screen
4. Select an import format (Excel workbook (.xls, .xlsx)/ XML/ CSV) from the dropdown.
Importing Format
5. Select the file based on the import format.
  • Excel Workbook: .xls, .xlsx
  • XML: .xml
  • CSV: .csv
Importing Data File
Note: If .xls or .xlsx files are selected the user is prompted to select the ‘Sheet’ from the file and click on the ‘Import’ button.
Sheet Selection for Excel file (data table) import
Note: If .xml file is selected the user is prompted to enter the row and column tags (both optional) and click on the ‘Import’ button.
  • The following is the basic XML format (for which row and column tag need not be specified).
Default XML format for Data Parameterization
Sheet Selection for Excel file (data table) import
  • If the XML is of any other structure or is nested, row and column tags need to be specified:
Complex XML format used for Data Parameterization
Row and Column Tags for XML file (data table) import
  • Column tags, if multiple, must be specified by separating each column tag name with semicolons.
6. Once successfully imported, the content from the file is populated and displayed in a data table format.
Imported Data File Content
7. Provide a unique Data Table Name and click on ‘Create’.
Saving imported data table
8. Data Table imported from the data file (.xls, .xlsx, .xml or .csv) is now successfully created.
Imported data table saved successfully

Export Data Table

  1. 1.
    Log in as a valid Avo Assure user, and click on the 'Utilities' plugin from the landing page.
Avo Assure Landing Page
2. Click on the 'Data Table' icon.
Utilities Landing Page
3. Click on the ‘Edit’ button.
Navigating to Edit Data Table Screen
4. Select an existing data table from the dropdown.
Edit Data Table – Data Table Selection
5. Click on the ‘Export’ button.
Edit Data Table Screen
6. A dialog will appear prompting the user to enter the file name (by default it takes the data table name as the file name) and a dropdown to select the export file format. Select the required file format and click on ‘Export’ to export the selected data table into the selected file format
Export Data Table Pop Up
7. The selected data table is exported as a file of the specified file format.
Data Table exported successfully

Usage of Data Tables

Data from Data tables can be fetched and used during execution via the getParam keyword.

Keyword: GETPARAM

Description: This keyword or action instructs ICE to execute the steps within the “StartLoop” and “EndLoop” of getParam.
Keyword
Input Syntax
Output Syntax
Supported Input Formats
getParam
<file path>; <sheetname in case of excel> (optional) <row count> OR <start row-end row> as third input
NA
  • Text
  • Static values
  • Dynamic variables
  • Supported File Types: .xml, .xls, .xlsx, .csv and Avo Assure data tables
Note:
  • The user is advised to specify the number of rows in a range to be executed in the getParam, else the iterations may run for the maximum number of rows in that worksheet irrespective of the reference column.
  • Input format for Avo Assure data table, for example- avoassure/DataTableName
  • The user can give the range as follows- avoassure/DataTableName;;2-4
  • If the user wants to execute a single row, then input is given as below: avoassure/DataTableName;;3
Find the snippet of the keyword below, while using an Assure data table for data parameterization:
In the above example, after the test case debug, it takes the input from the "SampleDataTable" and executes the displayVariableValue keyword within the “StartLoop” and “EndLoop” of getParam”.