Creating test data

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

Procedure

  1. Create a test data CSV file:
    1. Open a spreadsheet or a text editor.
    2. In a CSV file, the first row of data must be the column definitions. Follow this format: ColumnName:TYPE, where type can be STRING, NUMBER, BOOLEAN, or ENUMERATION. If you are using a text editor, type each row of data on a new line and include a comma between each column value. If you are using a spreadsheet, your data should look similar to the following image:

      Example spreadsheet with column definitions

      Note: The suggested type is for informational purposes and data in the table column does not have to be of the suggested type.
      If you are using a text editor, your data should look similar to the following:
      Composer:STRING,Item:STRING,Quantity:STRING,CardNumber:STRING,CardType:ENUMERATION,Total:String
      Haydn,Violin Concertos,1,1234 1234 1234 1234,Visa,15.99
      Haydn,Violin Concertos,2,1234 1234 1234 1234,Visa,30.98
      Haydn,Violin Concertos,5,1234 1234 1234 1234,Visa,75.95
      Haydn,Violin Concertos,10,1234 1234 1234 1234,Visa,150.9
      Haydn,Violin Concertos,50,1234 1234 1234 1234,Visa,750.5
      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, save the file. Specify .csv as the file extension, or select CSV (Comma delimited) for the file type when you save.
      Note: To ensure that text with special characters will be imported correctly, use a text editor, such as Windows Notepad or Microsoft Excel, to convert the CSV file to UTF-8 format.
      • 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.
  2. Create the test data artifact in the Quality Management application. In the main menu, click Construction > Create > Test Data.
  3. Type a name for the test data.
  4. Optional: Type a description.
  5. Optional: Create and assign categories to group the test data. Test data categories make it easier to find test data by allowing you to sort test data artifacts by the categories you apply.
    1. To add, edit, or further define test data categories, click the Manage Test Data Categories icon (Manage Test Data Categories icon).
    2. To set a test data category value, in the list next to a category type, select a value.
  6. In the Data File section, browse to the CSV file, and click Open. The CSV file is imported and the data records are displayed in the Data Records section.
  7. Save the test data artifact.

video icon Video

Jazz.net channel
Software Education channel

learn icon Courses

IoT Academy
Skills Gateway

ask icon Community

Jazz.net
Jazz.net forums
Jazz.net library

support icon Support

IBM Support Community
Deployment wiki