Importing a CSV file into a datapool

A new datapool can be initialized with data contained in a comma-separated-value (CSV) file.

If you require a datapool containing a large number of records, the quickest way to do it is to create a comma-separated-value (CSV) file using an external program (for example, Rational TestManager, your database, a Perl script, a spreadsheet).
You cannot import data into an existing datapool. However, you can initialize a new datapool with the contents in a CSV file at the time of creation. Here are the steps.
  1. Using a spreadsheet or a custom tool or script, create a CSV file containing the data to be included in the datapool. Optionally, the first line of the file can contain the descriptive names (lastname, acct-ID, etc.) of the variables (columns) and the first column in each line can contain an equivalence class (row) name. For example:
    csv file  with first row showing titles of cloumn

    As illustrated in the following figure, this file will produce a datapool with a single equivalence class (saleItem), 3 data columns (variables), and 9 rows (records) indexed as saleItem::0 through saleItem:8.

    Datapools that will be used by performance tests should contain only one equivalence class.

  2. At the end of the datapool creation dialog, as explained in Creating a datapool, browse to the CSV file and import its content into the new datapool.

Parent topic: Creating test data

Terms of use | Feedback
(C) Copyright IBM Corporation 2005. All Rights Reserved.