Creating test data

When you create test data, you import data from a comma separated values (CSV) file.

About this task

To create test data:

Procedure

  1. Create a CSV file:
    1. Open an Excel spreadsheet.
    2. In the spreadsheet, the first row of data must be the column definitions. Follow this format: ColumnName:TYPE, where type can be STRING, NUMBER, BOOLEAN, or ENUMERATION.
      CSV Example CSV file with column definitions
      Note: Defining columns is required when manually creating test data in the preceding step. It is optional when migrating manual test scripts that include test data; however, do not include actual data in the first row of a CSV file.
    3. When you are finished typing the data, click File > Save.
    4. Type a name for the file.
    5. In the Save as type field, select CSV (Comma delimited).
    6. Click Save.
    7. Close the spreadsheet.
  2. Next, import the CSV file.
    Note: To ensure that text with special characters is imported correctly, use a text editor, such as Windows® Notepad or Microsoft® Excel, to convert the CSV file to the UTF-8.
    • For Notepad, open the file in the text editor, and click Save as. In the Files of type field, select All Files; In the Encoding field, select UTF-8. Click Save.
    • For Microsoft Excel, click Save as. From the Action Bar at the top of the dialog, click Tools, and then select Web Options. In the Web Options dialog, click the Encoding tab. In the Save this document as field, select Unicode (UTF-8). Click OK and then Save.
    1. Point to Construction (Construction), and click Create Test Data.
    2. Type a name for the test data.
    3. Optional: Type a description.
    4. In the Data File section, browse for the CSV file, and click Open.
    5. Save the test data.

Results

The test data records are displayed in the Data Records section.

Feedback