Test Data Management

Data Table feature in Avo Assure allows creating a structured format for storing test data. This helps with data processing, retrieval, and when automating testing scenarios. It also helps users to construct data tables directly from the Avo Assure interface, further simplifying data integration into testing operations.

Data Table eliminates the need for external file dependencies while also allowing data sharing among multiple users utilizing Avo Assure by importing and exporting data tables.

Note: The Data Table allows only one assigned user to edit it at a time, preventing conflicts when multiple people work on shared tables in a project.

This document includes:

Creating Data Table Steps to create Data Table in Avo Assure

Functions of Data Table Functions accessible in Data Table

Search Folder/ Data Table

User can perform Folder / data table Search without case sensitivity

Assigning Users to Data Table

Steps to assign users to Data Table

Creating a Data Table

Creating a Data Table in Avo Assure allows the users to efficiently manage and utilize structured data for their testing using Avo platform.

The step-by-step process to create a data table in Avo Assure:

1. On Home page, select Manage Integration link from Settings card.

2. On Test Data Management page, select + icon to create folder.

3. Select ellipses(...) icon and select Create Table Manually to create the data table

Functions	Usage
Project Dropdown	For selecting an existing project to link with data table
Search Box below the Test Data	To search a data table folder

Functions of Data Table

Functions	Usage
+ Add Row	Select the + Add Row icon in the data table to add a row below the last row in the table. The maximum number of rows that can be added in a table is 200.
+ Add Column	Click the + Add Column icon in the data table to add a column at the right side of particular column. The maximum number of columns that can be added is 100.
Import Icon	It helps the users to import the data in .xlsx, .xls, CSV and XML formats to Avo Assure data table.
Export Icon	It helps the users to export the data table created in Avo Assure to .xlsx, .xls, CSV and XML formats for future reference.
Copy Row Icon	Select the checkbox on the left side of the specific row(s) that needs to be copied and click on the copy row icon to copy it.
Paste Row Icon	Select the checkbox on the left side of the specific rows(s) that need to be pasted and click on the paste row icon to paste it.
Redo	It restores the last undone action in the data table.
Undo	It removes the last performed action in the data table.
Delete Icon	Select a column(s) or row(s) and click the delete icon to delete the data of the selected column(s) or row(s).
Remove Selected Row Icon	Select the checkbox on the left side of the rows(s) that need to be deleted and click the Remove Selected Row icon to delete it from the table.
Delete Column Dropdown	Select checkbox of the specific column(s) that needs to be deleted by selecting the in the dropdown and click the Delete icon in the dropdown to delete the selected column(s).
Save Button	Click the save button to save the data table after the final changes.

Search Folder/ Data Table

1. Click search bar and search for Table or Folder.

Note:

• If searched with the particular text, rest all items which doesn't contains that text should will get eliminated.

• If searched with a text that is not at all present it will give no result or blank out the panel.

• This search is applicable for tables as well as folders

• The search value is not case-sensitive

• Search value can be alphabets, numbers, special characters, alphanumeric

Assigning Data Table

1. Select on three dots beside data table, select Assign Datatable option, to bring Datatable Assignment pop-up

   
2. Choose users from the Assign drop-down to assign the Data table, click Assign button.