Create, Edit, and Delete Datasets

qTest Manager Parameters allows you to both view and create Datasetsfor 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 the 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 theDataset 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.

  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 Dataset

  3. Select your Parameters for the Dataset by searching in the "Select Parameter" field.

    You can only see Parameters currently belonging to qTest Manager Projects.

  4. To add a new column, select the +icon. To delete a column, select the Xicon.

    A Dataset can have a maximum of 25 columns.

  5. To add Dataset Values, search for your desired value in the "Select Value" field. Select your desired Value.

    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.

  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.

Notes:

  • A Dataset can contain a maximum of one 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

You can remove multiple rows at a time by selecting the check box in the first column of each row and then selecting the DELETE ROWS icon.

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. SelectGENERATE.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.

      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 check box(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 check box(es) associated with each parameter.

  3. Select the ACTIONS icon. In the drop-down menu, selectCreate Dataset. In the "Confirmation" dialog, select OK.

  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 check boxes 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

    Only inactive Datasets are affected by this action.

  • Deactivate: Deactivate the selected Dataset

    Only active Datasets are affected by this action.

bulk-ds-actions.png