+

Search Tips   |   Advanced Search


Import a CSV file into a datapool


Overview

If you need to create a new datapool with a large number of records, you can initialize it quickly by importing data that is contained in a comma-separated-value (CSV) file.


Import the contents of a CSV file into a datapool

  1. Using a spreadsheet or a simple text editor, create a CSV file containing the data to be included in the datapool. The first line of the file can contain the descriptive names of the variables (columns); for example, Inventory or Description.

    Here is an example of a spreadsheet file:

  2. Click File > Import, and expand Test.

  3. In Test, select Datapool, ...

  4. In the Import Datapool window:

    1. Click Browse to navigate to the CSV file.

    2. If the data in the CSV file is encoded differently from what the local computer expects, select the encoding from the Import Encoding list.

    3. The first row of the CSV file can contain column names. If it does, select the First row contains variable names and suggested types check box. If this check box is not selected, columns are named Variable1, Variablen ... You can change the names when you edit the datapool.

    4. Typically, leave the First column contains equivalence class names check box cleared. Equivalence classes are used in functional, rather than performance, testing. Select this check box if you are using a datapool for both functional and performance testing, and the datapool already contains equivalence classes.

    5. Select the datapool to receive the data.

  5. Click Finish. The data from the CSV file is imported into the datapool.


Example

The following figure shows the datapool with the imported data.


Related