Creating a dataset by using a CSV file

When you use variable data that is contained in a CSV file, you can import the data from the CSV file and create a dataset in HCL DevOps Test Hub (Test Hub).

Before you begin

You must have completed the following tasks:

Ensured that you are assigned a role as a Project Owner or Tester in the project. See Managing access to the server projects.
Created a project in your team space in Test Hub. See Adding a project.
Added the remote Git repository that contains the test resources to the project. See Adding repositories to a server project.
Saved a CSV file that contains variable data on your computer.

About this task

When you want to create or modify any dataset, you must have an Edit branch. You can create the Edit branch during the creation of dataset. All your dataset reside in the Edit branch until you publish or discard the changes.

After you create the dataset, you can either publish your changes to a remote Git repository or you can discard the changes made to the dataset. The Edit branch automatically disappears from the Branch list as well as from the remote Git repository and sets the global branch to the previously selected branch in the following conditions:

When you publish changes to the remote Git repository.
When you discard the changes made in the dataset.

Procedure

Log in to Test Hub.

The team space that contains your project is displayed.
Click Active projects > My projects > project_name to open the project that contains the test assets.

The Overview page of the project is displayed.
Click Author > Data.

The Data page and the Data navigator are displayed.
Select the branch in the project repository from the Branch list.
Perform any of the following actions:
- Click the Open action menu icon in the Data navigator, and then click Dataset.
- Click Add files in the right panel, and then click Dataset.
The Edit branch dialog is displayed.
Select your action to either select an existing Edit branch or create an Edit branch:
- Perform the following steps to select the Edit branch:
  1. Select an Edit branch from the Select branch list if Edit branches already exist in the selected branch of the repository.
  2. Click Ok.
  You selected an existing Edit branch.
- Perform the following steps to create the Edit branch:
  1. Select Create new branch.
  2. Enter a name for the Edit branch.
  3. Click Save.
  You created an Edit branch.
Create a folder, if you want to use a new folder to contain the resource by performing the following steps:
1. Select the project or a logical folder in the Data navigator, right-click, and then click Folder.
  
  Alternatively, select the project or a logical folder in the Data navigator, click the Open action menu icon , and then click Folder.
  
  The Create new folder dialog is displayed.
2. Enter a name for the folder.
  
  For example, enter MyFolder as the name of the folder.
3. Click Create.
  
  The folder is created under the project and displayed in the Data navigator.
Perform the following steps in the Create Dataset dialog:
1. Enter a name for the Dataset.
2. Select a folder in the Location field.
3. Click Next.
4. Select the Import from a CSV file option from the Select source list.
5. Click Select File and choose the CSV file that contains variable data to import into the dataset.
6. Enable First row contains headers by using the toggle icon if the CSV file contains the header.
7. Click Create.
The dataset is displayed in the Data page. The dataset created is listed under the logical folder Datasets under the physical folder MyFolder that you created.

Results

You have created the dataset by using the CSV file in your project.

What to do next

You can perform the following tasks:

Add, modify, or remove data in the dataset. See Editing a dataset.
Publish the dataset to the Git repository so that other members of the project can use the dataset. See Publishing changes in datasets.