Data Table

Data tables are a form of storing the data (within Avo Assure) that can represent the data in rows and columns. The data tables consist of a header row (which contains the names for the columns. These can be considered 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. To remove external file dependency.

2. Availability of Data Table for all Avo Assure users.

3. A platform to share the same data among multiple users (via import and export of data tables).

Create Data Table

1. The user has to Log in to Avo Assure with valid credentials.

2. The user has to click the Utilities plugin, and the Utilities window will be displayed.

3. The user has to click the Data Table button, and the Data Table window will be displayed.

4. The user has to enter the data table name in the Enter Data Table Name box. Note: The user has to enter a unique Data Table Name.

5. To add multiple row(s)/column(s), the user has to click the + (Add) icon.

   Note:

   • The first column will show row numbers and can be clicked to select the entire row.

   • Users can select multiple rows/columns with “Ctrl + Click”.

6. The user has to select the required row and click the + (Add) icon to add the row below it. The new row will be added next to the selected row.

   Note:

   • The maximum number of rows supported is 200.

   • The maximum number of columns supported is 50.

7. To rearrange the rows or columns, the user has to drag and drop the row or column to the desired location by toggling the "Drag and Drop" icon.

8. To delete row(s)/column(s), the user has to select the desired row(s)/column(s) and click the Delete icon.

9. To copy row(s)/column(s), the user has to select the desired row(s)/column(s) and click the Copy icon.

10. To paste row(s)/column(s), the user has to select the desired row(s)/column(s) and click the Paste icon.

11. 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. Note: The copied rows/columns can be pasted only once. Multiple pastes are not allowed.

12. To undo/redo the cell changes, the user has to click the Undo / Redo icon. Note: The user can undo or redo up to 5 cell changes in the Data Table.

13. Row '1' is reserved for custom header names which the user can change.

    Note:

    • These names will be unique.

    • An error message will be displayed on entering duplicate values in multiple column headers or leaving any column header empty.

14. For data parameterization, the user has to enter the data values in rows and columns.

15. Click the Create button to create/save the entered data table.

Edit Data Table

1. The user has to click the Utilities plugin, and the Utilities window will be displayed.

2. The user has to click the Data Table button, and the Data Table window will be displayed.

3. The user has to click the Edit button, and the Edit Data Table window will be displayed.

4. The user has to search and select an existing data table from the Search data Table box.

5. The user has to Modify the selected data table as required.

6. The user has to click the Update button.

Delete Data Table

1. The user has to click the Utilities plugin, and the Utilities window will be displayed.

2. The user has to click the Data Table button, and the Data Table window will be displayed.

3. The user has to click the Edit button, and the Edit Data Table window will be displayed.

4. The user has to search and select an existing data table from the Search Data Table box.

5. The user has to click the Delete button.

6. A confirmation dialogue box will be displayed with the 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.

7. If the user wants to delete the data table, click the Yes button. If the user doesn't want to delete the data table, click the No button.

Import Data Table

1. The user has to click the Utilities plugin, and the Utilities window will be displayed.

2. The user has to click the Data Table button, and the Data Table window will be displayed.

3. The user has to click the Import button, and the Import Data Table window will be displayed.

4. The user has to select the import format from the Import Format drop-down (Excel workbook (.xls, .xlsx)/ XML/ CSV).

5. The user has to select the required file format from the folder. Select the file based on the import format.

   • Excel Workbook: .xls, .xlsx

   • XML: .xml

   • CSV: .csv

1. If .xls or .xlsx files are selected, the user is prompted to select the Sheet from the file and click on the Import button.

2. If the .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 tags need not be specified).

   

• If the XML is of any other structure or is nested, row and column tags need to be specified:

• Column tags: if multiple, must be specified by separating each column tag name with semicolons.

1. Once successfully imported, the content from the file is populated and displayed in a data table format.

2. The user has to enter the data table name in the Data Table Name box.

3. The user has to click the Create button.

4. The data Table imported from the data file (.xls, .xlsx, .xml, or .csv) is now successfully created.

Export Data Table

• The user has to click the Utilities plugin, and the Utilities window will be displayed.

• The user has to click the Data Table button, and the Data Table window will be displayed.

• The user has to click the Edit button, and the Edit Data Table window will be displayed.

• The user has to search and select an existing data table from the Search Data Table box.

• The user has to click the Export button, and the Export Data Table window will be displayed.

• The user has to enter the file name in the File Name box. Note: By default, it takes the data table name as the file name.

• The user has to select the required file format from the Export Format drop-down.

• The user must click the Export button to export the selected data table into the file format.

• The selected data table is exported as a file of the specified file format.

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.

• The input format for the 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 debugs, it takes the input from the "SampleDataTable" and executes the displayVariableValue keyword within the “StartLoop” and “EndLoop” of getParam”.