Data Table

Data Tables are a form of storing data within Avo Assure by representing it in rows and columns. The Data Tables consist of a header row (which contains the names for the columns and are considered as the attribute name.), and the cells under these headings that have meaningful values for the associated header (which are regarded as the attribute values).

Functionality of Data Table

The Data Table feature allows users to create a structured format for storing test data. This enables easier data manipulation, retrieval, and usage during automated testing scenarios. Users can create Data Tables directly from the Avo Assure interface, streamlining the integration of data into testing workflows.

Need for Data Table

1. To remove external file dependency

2. To remove external file dependency

3. To ensure availability of Data Table for all Avo Assure users

4. To provide a platform to share the same data among multiple users (via import and export of data tables)

Create Data Table

Creating a Data Table in Avo Assure involves a straightforward process that allows users to efficiently manage and utilize structured data for their testing activities. Below are the step-by-step instructions on how to create a Data Table in Avo Assure.

1. Navigate to Avo Assure lading page

Log into Avo Assure and navigate to the landing page. This is the main interface from where all functionalities can be accessed.

2. Click Utilities Plugin

Next, click Utilities plugin. This action will open the Utilities window, which provides access to various tools, including the Data Table feature.

3. Click Data Table

In the Utilities window, locate and click Data Table button. Doing so will open the Data Table window where further configurations will take place.

Enter the data table name in the Enter Data table Name box.

Note: Make sure to enter a unique Data table name.

4. Configure the Data Table

Once the Data Table window is displayed, configure the data table by adding relevant columns and populating it with the necessary data.

Following is the action to perform on Data Table.

A. Add rows and Column

To add multiple row(s)/column(s), click the + (Add) icon

Note: User can select multiple rows/columns with Ctrl + Click

B. Add row/column in a specific place

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

C. Delete row/column

To delete row(s)/column(s), select the desired row(s)/column(s) and click the Delete icon

D. Copy and Paste row/column

To copy row(s)/column(s), select the desired row(s)/column(s) and click the Copy icon. To paste row(s)/column(s), select the desired row(s)/column(s) and click the Paste icon.

E. Paste in a particular place

To paste copied rows/columns, specify 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.

F. Undo/Redo

To undo/redo the cell changes, click undo/redo icon

Note: The user can undo or redo up to 5 actions in the Data Table.

G. Change header name

Remember to change the header names according to required attribute name

Note: These names will be unique.

H. Data parameterization

For data parameterization, enter the data values in rows and columns and click the Create button to create/save the entered data table

After clicking the create button, a conformation will be displayed that reads Data Table Saved Successfully.

---

Steps of Edit Data Table in Avo Assure

​Editing a Data Table in Avo Assure is a straightforward process that allows users to modify existing data tables as needed for test automation.​ Below are the step-by-step instructions to guide you through the process.

1. Click on Data Table

Begin by navigating to the Avo Assure landing page. From this main interface, locate the Data Table section where existing tables are managed.

2. Click the Edit Button

Once you are in the Data Table section, click the Edit button.

This action will open the Edit Data Table window.

3. Search for the Required Data Table

In the Edit Data Table window, utilize the Search Data Table box to find the specific data table you wish to edit. You can enter the name or relevant details of the table to help expedite the search process.

4. Select the Data Table

After locating the desired data table, select it from the search results. This will allow you to view its current configuration and data entries.

5. Modify the Data Table

With the data table selected, make the necessary modifications as required. This could involve changing data entries, adding new data, or modifying existing fields within the table

6. Save the Changes

Once all modifications are complete, click the Update button to save your changes. This action ensures that all edits to the data table are recorded and that the table is updated accordingly.

7. Confirmation

Upon successfully saving the changes, a confirmation that the Data Table has been updated successfully will appear.

---

Steps of Delete Data Table in Avo Assure

​Deleting a Data Table in Avo Assure is a straightforward procedure that can be completed in a series of specific steps.​ Below is a step-by-step guide to help you navigate this process effectively.

1. Click Data Table

Begin by navigating to the Avo Assure landing page. From this main interface, locate the Data Table section where existing tables are managed. And click the Edit button, the Edit Data Table window will be displayed.

2. Search for the Appropriate Data Table

Use the Search Data Table box to find the specific Data Table you want to delete. Enter the name or any identifiers associated with the table to facilitate your search.

3. Click Delete Button

With the Data Table selected, click the Delete button. This action will prompt a confirmation dialogue box to appear, asking if you are sure you want to proceed with the deletion.

4. Confirm the Deletion

In the confirmation dialogue box, review your choice and confirm the deletion by clicking the Yes button. This finalizes the deletion process, and the Data Table will be removed from the system.

---

Steps of Import Data Table

​Importing a Data Table in Avo Assure is a systematic process that enables users to integrate datasets into their testing environment effectively.​To Import a file, Avo Assure supports Excel workbook, CSV and XML file format. Below is a detailed step-by-step guide outlining the steps for importing a Data Table.

1. Click on Data Table

Begin by navigating to the Avo Assure landing page. From this main interface, locate the Data Table section where existing tables are managed.

2. Click Import

In the Data Table interface, find the Import Data Table button and click it to initiate the import process. This will open the Import Data Table window to proceed with.

3. Choose the File for Import

In the Import Data Table window, select the appropriate file that contains the data to import. This file is usually in a structured format like CSV or Excel. Navigate to the file location on the local machine and select the desired file.

5. Confirm the Import

Click the Import button. This step finalizes the import and integrates the data into Avo Assure.

Note: 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.

6. Verify Import Success

Review the Data Table to ensure that the entries have been accurately imported and are accessible for testing purposes.

---

Export Data Table in Avo Assure

​Exporting a Data Table in Avo Assure allows users to save their data in a preferred format for further use.​ To Export a file, Avo Assure supports Excel, CSV and XML file format. Below is a detailed step-by-step guide outlining the steps necessary for exporting a Data Table effectively.

1. Click Data Table

Begin by navigating to the Avo Assure landing page. From this main interface, locate the Data Table section where existing tables are managed.

2. Click Export Button

After selecting the desired Data Table, look for the Export button. Click this button to initiate the export process.

3. Export Data Table

An Export Data Table window will appear. In this window, you will need to enter a suitable file name for your exported data file in the File Name box. Ensure that the name is descriptive enough for easy identification later.

4. Confirm the Export

Once you have entered the file name, click the Export button to finalize the export. This step will convert your Data Table into the specified format and save it accordingly.

5. Verify Export Success

After completing the export process, navigate to the designated file location to ensure that the exported Data Table is available and correctly formatted.

---