Assigning test data to templates

If a TestCase is marked as a TestCase Template, it must refer to a template, which is provided as the data source, so that TestSteps can be associated with test data.

TestCase-Design Sheet or Class

For further information on combining TestCase-Design data sources, please refer to the Tosca TestCase-Design AddIn Manual.

Microsoft® Excel template

To refer to an Excel worksheet as a DataSource, the path to the Excel file has to be entered in the TestCase properties under SchemaPath.

Syntax:

<Path>\<name of the Worksheet>

C:\Tosca_Projects\Test\Personaldata.xls\Person

It is also possible to choose the Excel file in a dialog window and to select the corresponding worksheet.

SchemaPath - Excel DataSourceWizard

Documents in Microsoft® Excel 97-2003 formats can be specified as Microsoft® Excel references.

Use file reference as schema definition

In Tosca Commander, Excel templates can be embedded or referenced (see chapter "Manage file attachments"). It is also possible to use these files as data source for a TestCase template.

  1. Select the embedded Excel template to be used as data source.

  2. Drag the Excel template to the TestCase template and drop it there.

  3. Select the option Assign SchemaDefinition from the pop-up menu.

Assign schema definition

  1. The Data source wizard opens.

  2. Press the OK button to accept the assigned data source.