Importing or exporting dataset

When you have a large amount of data stored in a CSV file, you can import that into a dataset instead of creating a new dataset. You can export variable data from the dataset into a CSV file to reuse in future tests when required.

Before you begin

  • You must have a .csv file that contains variable data to import into a dataset.

  • You must have a dataset that you want to export.

About this task

When you perceive that there might be many cells in the dataset that need to be changed, it might be better to export the dataset as a CSV file, edit the dataset outside of the CSV Editor, and then import the data in the CSV into a dataset.

You can export datasets that you created on Rational Test Automation Server so that the same dataset can be used in other projects on the desktop clients.

Procedure

  1. Go to the Datasets page and find the dataset into which you want to import the test data.
  2. Click the Edit icon edit_icon from the Actions column of the dataset.
    The dataset opens in the CSV Editor in a web browser.
  3. Click the Import icon import_icon and perform the following steps to append or overwrite data in the dataset:
    1. Click Choose File and select the CSV file that you want to import.
    2. Select the First row contains headers checkbox if the CSV file contains the header.
    3. Select one of the following options to append or overwrite data in the dataset:
    • Click Overwrite to add the rows and columns from the selected CSV file from the beginning of the dataset.
    • Click Append to add rows and columns from the selected CSV file to the end of the dataset.
To export a dataset as a .CSV file:
  1. Go to the Datasets page and find the dataset which you want to export as a .CSV file.
  2. Click the Export icon export_icon from the CSV Editor.

Results

  • You have imported the test data into the dataset from a CSV file.

  • You have exported the dataset as a CSV file.