Creating a datapool

A datapool is a test dataset, a collection of related data records which supplies realistic data values to the variables in a test script during test script playback. You can create data from scratch or import existing data into a new datapool from another datapool or a .csv file.

Before you begin

When you work with datapools, you must follow the following rule:
  • When you import data, you must import the data into the same Functional Test project as the test scripts that access the data.

Procedure

  1. Click Create a Test Datapool (Create a Test Datapool button).
  2. Perform the following steps:
    1. Either type the path to the folder you want or use the navigation tools (Home Home button, Back Back button, and Go Into Go Into button) to select the path.
    2. Type the name of the new datapool.
      Note: The datapool name is appended to the project path. The project path and datapool name together should not exceed 230 characters.
    3. If you create the Functional Test project in a ClearCase® directory, optionally, select Add the datapool to ClearCase.
    4. Perform one of the following steps:
      • To create an empty datapool, if there is a filename in the Import From list, select the filename and delete it, and then click Finish.
      • To import data into the datapool, click Next, and then go to next step.
  3. To import data from a Functional Test or from a .csv file perform one of the following steps:
    • To import a .csv file:
      1. Type the path and filename of an existing .csv file, click the Import From arrow to select from a list of ten recently imported files, or click Browse to select the path and filename.
      2. Type one to three field separator characters to use in the file you want to import.

        HCL OneTest™ UI must use the same field separator character as the one used in the .csv file from which you are importing data. If you are not sure which field separator characters to specify, use a text editor to open the .csv file and see the field separator characters that are used.

      3. Select First Record is Variable Information to make the first row of the imported data, the header of a new datapool.

        If you clear First Record is Variable Information, the first record in the .csv file is imported as data and the headers use the default headers, such as data0, data1, etc. First Record is Variable Information is unavailable if the file you select to import is not a .csv file

    • To import a datapool, perform any one of the following steps:
      • Click the Import From arrow to display a list of ten recently imported files, and then select a Functional Test datapool from the list.
      • Type the path and filename of an existing datapool.
      • Click Browse to select the path and filename of an existing Functional Test Datapool.
  4. Click Finish. A new datapool appears.
Feedback