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.
About this task
To import the contents of a CSV file into a datapool:
Procedure
- Using a spreadsheet or a simple text editor, create a CSV
file that contains 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:
- Click , and expand Test.
- In Test, select Datapool,
and then click Next.
- In the Import Datapool window:
- Click Browse to navigate to the
CSV file.
- If the data in the CSV file is encoded differently from
what the local computer expects, select the encoding from the Import
Encoding list.
- 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.
- 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.
- Select the datapool to receive the data.
- Click Finish. The data from the
CSV file is imported into the datapool.
Example
The following figure shows the datapool with the imported
data.