When you create test data, you import data from a comma
separated values (CSV) file.
About this task
To create test data:
Procedure
- Create a CSV file:
- Open an Excel spreadsheet.
- 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.
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.
- When you are finished typing the data, click .
- Type a name for the file.
- In the Save as type field, select CSV (Comma delimited).
- Click Save.
- Close the spreadsheet.
- 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.
- Point to Construction (
), and click Create Test Data.
- Type a name for the test data.
- Optional: Type a description.
- In the Data File section, browse for the CSV file, and
click Open.
- Save the test data.
Results
The test data records are displayed in the
Data
Records section.