Editing a dataset

You can add, modify, or remove data from a dataset by using the CSV Editor. The working principle of the CSV Editor is similar to that of a spreadsheet.

Before you begin

You must have created a dataset or configured a repository that contains the dataset.

About this task

When you want to run a test asset with different dataset values, you can either edit the existing dataset or create a new dataset and use it during the test asset run. When the number of edits is minimal, it is easier to edit the dataset within the CSV Editor.

If you are a project Owner or Tester in Rational® Test Automation Server V10.1.0 or later, you can perform basic tasks in the CSV Editor by right-clicking any row, column, or cell in the dataset to organize your data in a better way. For example, you can perform tasks such as updating data in a cell, inserting or deleting rows and columns, or renaming column names.

When you edit the dataset in the CSV Editor, you can use the following keyboard shortcuts to control the cursor selection in the CSV Editor:

  • Tab - To move the cursor control to the next available option.

  • Shift-Tab – To move the cursor control to the previous option.

  • Shift+F10 – To open the context menu from the dataset cell.

After you edit the dataset, you can save the changes made to the dataset, and then you can publish the dataset to the Git repository. If you save and close the edited dataset, the Changes page lists the edited dataset and later you can publish to the Git repository for other members to use.

When you or other members of the project edit the same dataset, you can see an icon with the initials of the member next to the name of the dataset on the Datasets and Changes pages. If you do not see the icon, you must refresh the Datasets page to view the icons. The Changes page denotes conflicting edits when another member publishes their edited dataset first.

who_is_editing_dataset

conflict indicator

When a member with conflicting edits tries to publish the edited dataset, an error about conflicting changes is displayed. However, the member can use the Save As option to save and publish a copy of the dataset edits under a new asset name. The member must discard the edits that were made to the original dataset.

For example, consider a scenario when Amy Smith and John Doe edit the same dataset, and Amy Smith edits and publishes the dataset. On the Changes page, a message that indicates a conflict is displayed when John Doe tries to publish the same dataset.

Note:

You cannot resize the width of rows in the CSV Editor. When you have a large amount of data in a cell, you can right-click the cell and select Copy (or Ctrl+C), and then paste it into a text-editing program to view the content. Alternatively, you can hover the mouse over the cell to view the content.

Procedure

  1. Go to the Datasets page and find the dataset which you want to edit.
  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. Perform the following actions to use the options available in the CSV Editor:
    Option Description
    Find and Replace fina_and_replace_icon To find:
    1. Click the Find and Replace icon fina_and_replace_icon.
    2. Enter the content that you want to search in the Find field.
    3. Select any or all the following options to find the search content more effectively:
      • Select the Case sensitive checkbox to search the content that is the exact letter case of the content entered in the Find field.
      • Select the Match entire cell contents checkbox to search for cells that contain only the characters that you have entered in the Find field.
      • Select the Search using regular expression checkbox to search the pattern that matches strings.
        For example, to search a cell that contains any number between 0 to 9, do the following:
        1. Enter \d in the Find filed.
        2. Select the Search using regular expression checkbox.
        3. Click Find.
    4. Click Find. If the text is found, the cell containing that text is selected.
    5. Click Find again to find further instances of the search text.

    To find and replace:

    1. Click the Find and Replace icon fina_and_replace_icon.
    2. Enter the content that you want to search in the Find field.
    3. Enter the content that you want to replace in the Replace field.
    4. Select any or all the following options to find and replace the content more effectively:
      • Select the Case sensitive checkbox to find the content that is the exact letter case of the content entered in the Find field.
      • Select the Match entire cell contents checkbox to find and replace for cells that contain only the characters that you have entered in the Find and Replace fields.
      • Select the Search using regular expression checkbox to find and replace the pattern that matches strings.
    5. Click Replace to replace the individual instances.
    6. Click Replace All to replace every instance of the content throughout the dataset.
    Undo undo_icon
    1. Click the Undo icon undo_icon.
    2. Select the recent changes from the list that you want to undo, and then click the list.
    The Undo option undoes anything you do in the dataset. The CSV Editor saves the unlimited undo-able action. You can perform the undo action even after you save your changes made to the dataset.
    Redo redo_icon
    1. Click the Redo icon redo_icon.
    2. Select the recent changes from the list that you want to redo, and then click the list.
    The CSV Editor saves the unlimited redo action.
    Import import_icon 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 must have a .csv file that contains variable data to import into a dataset.
    1. Click the Import icon import_icon.
    2. Click Choose File and select the CSV file that you want to import in the Import File dialog box.
    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.
    4. Select the First row contains headers checkbox if your CSV file contains the header.
    Export export_icon You can export variable data from the dataset into a CSV file to reuse in future tests when required. You must have a dataset that you want to export.

    Click the Export icon export_icon to download the dataset as a CSV file.
    Set as current row During the test run, if you want variable data to be selected from a current row instead of the first row in a dataset, right-click any cell in a row and select Set as current row.

    Also, you can set the current row from the Datasets page by clicking Menu, and then the Configure option.

    When rows are deleted:

    If you delete any row between row 1 to current row, the current row data is taken from the next row. For example, when you set the current row as 6, and then you delete any row between row 1 to row 6, the current row remains at row 6, but the content of row 7 is moved to row 6.

    When rows are inserted:

    If you insert any new row between row 1 to the current row, the current row data is taken from the previous row. For example, when you set the current row as 6, and then you insert any row between row 1 to row 6, the current row remains at row 6, but the content of row 5 is moved to row 6.
    Dataset configuration settings ds_configuration_settings In the Configure Dataset window, you can change the row and column settings and configure the string values in the dataset that contains variable data for tests to use when they run.
    1. Click the Menu icon menu_icon and select Configure option.
    2. Configure the following options in the Configure Dataset window:
      • Column header - To change the column header, use an up-down control button to increment or decrement the value.

      • Data start point - To change the data starting pointer, use an up-down control button to increment or decrement the value.

      • Current row - To set the current row, use an up-down control button to increment or decrement the value. You can also see the Current row number on the upper-right side.

      • Treat empty text as null -If a dataset contains any blank cells, the value of those blank cells is interpreted as null when you select this field.

      • Treat as null - Enter a string value that is to be treated as null when running test.

      • Treat as empty - Enter a string value that is to be treated as empty when running test.
    Discard discard_icon Click the Menu icon menu_icon and select Discard to discard the changes made to the dataset.
  4. Click the Save icon save_icon to save the changes made to the dataset.
  5. Click the Publish icon publish_icon to publish the dataset to the Git repository, and then close the CSV editor.

Results

You have edited the dataset.