Menu

Create, Edit, and Delete Datasets

Overview

qTest Manager Parameters allows you to both view and create Datasets for given projects. This feature allows users to quickly view, create, and edit, data for large projects.

View Datasets

Select the Datasets tab to view all Datasets. Each dataset presents as a row in dataset table containing the following:

  • Name
  • Status
  • Description
  • Parameters used in the dataset
  • Creation and update dates

By default, last created datasets show at the top of the table.

ds-tab.png

Filtering and Sorting Datasets

Filtering Datasets

To filter Datasets, enter dataset name and status in the "Search" and/or "Status" field(s).

ds-filter.png 

Sorting Datasets

To sort Datasets, select the column containing the information by which you want to sort in the dataset table. 

ds-sorting.png

Create a new Dataset

To create a new Dataset, follow these steps:

  1. Select the + CREATE icon from the Datasets page.ds-create-btn.png
  2. The Create dataset dialog displays. Input basic Dataset information:
    • Dataset Name (required): enter the name of the new dataset
    • Status: Active or Inactive
    • Description: description of the datasetcreate-ds-01.png
  3. Select your Parameters for the Dataset by searching in the "Select Parameter" field.
    Note: You can only see Parameters currently belonging to qTest Manager Projects.
    Select_Parameters.png
  4. To add a new column, select the + icon. To delete a column, select the icon.
    NOTE: A Dataset can have a maximum of 25 columns. 
    Columns.png
  5. To add Dataset Values, search for your desired value in the "Select Value" field. Select your desired Value. 
    HINT:
    when selecting data for each row, press Tab to move to the next cell, press the Up or Down Arrow to select a value from the drop-down menu.
    Select_Values.png
  6. To create more row(s), enter the number of the rows you want to create in the "Add" field near the bottom of the dialog. Select the Add icon.create-ds-05.png

NOTE: 

  • A Dataset can contain a maximum of 1 million rows
  • Your maximum amount of rows is restricted by the size of the page.

To remove an unwanted row, select the X icon in the last column of the row.

create-ds-06.png

Hint: You can remove multiple rows at a time by selecting the checkbox in the first column of each row and then selecting the DELETE ROWS icon.create-ds-07.png

Clear Dataset data

  • Clear values: All values/data of the Dataset will be cleared out, but its structure (selected columns) will be unchanged.
  • Reset Table: The dataset's structure and data are removed. The Dataset reverts to its initial state from which you can rebuild it from scratch.

create-ds-08.png

Automatically Generate Data

There are two ways to automatically generate data in qTest Manager: 

  1. Select GENERATE. The "Generate Data" dialog displays.
  2. In the "Select Method" section, choose either:
    • Unique Values: Parameter values will not repeat, and no two rows will have the same parameter value.
    • Unique Combinations: Each row in the data grid will contain a unique combination. Parameter values can repeat; however, no two rows will have the same combination of data.create-ds-09.pngNOTE: The number in the blue circle beside each method is the maximum possible rows that can be generated using that method. For example, in the screenshot shown below, the maximum amount of combinations is 1488.                                                                                                                   

Associate Dataset to qTest Manager Projects

By default, the Dataset will associate with all of your qTest Manager projects.

You can modify associated projects by following these steps:

  1. In the dialog, select the Projects tab. The Projects currently associated with the Dataset display.
  2. Select the +PROJECT icon, and select the checkbox(es) next to the Projects which you no longer want associating with your Dataset. Select OK.

create-ds-11.png

When you finish entering information for the new Dataset, select SAVE.

Create a New Dataset from Selected Parameters

You can also create a new Dataset from Selected Parameters within the "Parameters" section. To do so, follow these steps:

  1. Select the Parameters tab.
  2. Select parameters that you want to include in the new Dataset by selecting the checkbox(es) associated with each parameter.
  3. Select the ACTIONS icon. In the drop-down menu, select Create Dataset. In the "Confirmation" dialog, select OK.create-ds-13.png
  4. The "Create Dataset" dialog displays. Input your Dataset information just as you did within the "Dataset" section.

Edit and Delete Dataset(s)

Edit Dataset

To edit an existing dataset, follow these steps:

  1. In Parameters, select the Datasets tab. 
  2. Select the Name of the Dataset that you wish to Edit. The Dataset dialog displays.
  3. Edit the existing information as you wish.
  4. When finished, select Save.

create-ds-12.png

Delete/Deactivate a Dataset

From the Dataset table, select the action icon in the last column of an active Dataset, and select the Delete or Deactivate menu item.

delete-deactivate-a-ds.png

Bulk Dataset actions

From Dataset table, you can select multiple datasets and apply actions to the selected datasets from the ACTIONS drop-down menu. Select the checkboxes next to the multiple Datasets upon which you want to act. Choose from these options in the drop-down menu:

  • Delete: delete selected datasets
  • Activate: activate selected datasets 
    • Note: only Inactive datasets are affected by this action
  • Deactivate: deactivate the selected dataset.
    • Note: only Active datasets are affected by this action

bulk-ds-actions.png

 

Powered by Zendesk