Test Data Management
The Data Table feature in Avo Assure allows users to create a structured format for storing test data, which helps in efficient data processing and retrieval during automated testing scenarios. It enables users to construct data tables directly from the Avo Assure interface, simplifying the integration of data into testing operations.
Additionally, the Data Table feature eliminates the need for external file dependencies and supports data sharing among multiple users by allowing data tables to be imported and exported within Avo Assure.
This document includes:
Creating data table in Avo Assure
Functions accessible in Data Table
Searching folder / data table in test data management
Assigning users to data table
Creating a Data Table
To create a data table, perform the following actions:
On Home page, from Projects list, select required project.
From Settings tile, select Manage Integration.
On Test Data Management page, select + icon to create folder.
Select Create main folder option and rename the folder.
Select ellipses (...) icon located besides your created folder.
Select Create Table Manually option and rename 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
+ Add Row
It helps you 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
It helps you to add a column at the right side of particular column in the data table . The maximum number of columns that can be added is 100.
Import Icon
It helps you to import the data in .xlsx, .xls, CSV and XML formats to Avo Assure data table. Note: The excel file’s column header names should not contain commas.
Export Icon
It helps you 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 helps you removes the last performed action in the data table.
Delete Icon
it helps you delete the unwanted column or row by selecting 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.
Searching Folder/ Data Table
To search folder/data table, perform the following actions:
On Home page, from Projects list, select required project.
From Settings tile, select Manage Integration.
On the Test Data Management page, select search Folder / Data table and search for table or folder.
Note:
If you are searching with the particular text, rest all items which doesn't contains that text gets eliminated.
If you are searching with a text that is not at all present, it gives no result.
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 or alphanumeric.
Assigning Data Table
To assign data table, perform the following actions:
On Home page, from Projects list, select required project.
From Settings tile, select Manage Integration.
On Test Data Management page, select ellipses(...) icon beside data table.
Select Assign Datatable option. The Datatable Assignment page opens.
Choose users from the Assign drop-down to assign the data table.
Select Assign.
Last updated
Was this helpful?