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
To remove external file dependency
To remove external file dependency
To ensure availability of Data Table for all Avo Assure users
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.
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.
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:
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.
Last updated