Export/import of Test Data

TESSY can import and export test data

  • TESSY can import test data from Excel workbooks or ASCII files
  • TESSY can export test data to Excel workbooks or ASCII files
  • TESSY can import test data from the Classification Tree Editor (CTE)

Import/export of test data from/to Excel workbooks lets you easily generate additional test cases and enables you to calculate expected values automatically.

Import/export of test data from/to ASCII files lets you easily exchange test data with various tools, e.g. to import existing test data. Converting test data to/from the ASCII file format of TESSY is simple.

Test data in an Excel Workbook

Import Test Data

TESSY can import test data from Excel workbooks or ASCII files.

The Import button opens the Import dialog
The Import dialog allows importing test data

Export Test Data

TESSY can export test data from Excel workbooks or ASCII files.

The Export button opens the Export dialog
The Export dialog allows exporting test data in various formats

Import from CTE

TESSY can import test data from the Classification Tree Editor (CTE).

The Test Data Editor (TDE) with test data imported from the CTE

TESSY can import specifications and descriptions from the Classification Tree Editor (CTE).

The Test Definition view shows a specification imported from the CTE

Test Data in Excel Workbook Format

An Excel workbook in TESSY format has several sheets.

The test cases reside in the “Values” sheet of an Excel workbook.

The first test case for a sorting function
Add lines to create additional test cases

Hint: If you want to create test cases in an Excel workbook, first create this Excel workbook by exporting a (dummy) test case from TESSY to the Excel workbook. Then edit the workbook and add test cases.

Calculate the expected values using Excel

Test Data in ASCII Format

Example for test data in an ASCII file suitable for TESSY:

Two test cases for the minimum function

In the figure above, the values of the columns are separated by tabs. CSV (Comma Separated Values) and YAML (YAML Ain’t Markup Language) is also possible.