Tosca Commander allows to import test data from an Excel file as long as it follows a specific format (source).

Since several of our clients have expressed interest in more seamless integration between Hexawise and Tosca, we have released a new option in the export dialog which will streamline the process.

First, let us ensure the common understanding of terminology:

Now, we will provide the step-by-step instructions for the export-import process.

Video Demo

Note: while the UI in the video above is outdated, the steps remain consistent.

Step 1: Finalize the model inside Hexawise, keeping in mind Tosca features

  • Leverage Nominal Parameters (name preceded by #'s and 1 value) to represent the attribute folder structure.

  • Include parameters/values in the formats closer to the execution state.

Keep in mind the dynamic syntax from Tosca (e.g. Effective Date), if applicable.

  • Make sure the model is 100% complete before exporting because applying design changes to the TestSheet afterwards complicates keeping track of the differences between Hexawise and Tosca.

To expand on the first bullet point above, specially-named parameters in the test model can be used to represent folders / hierarchy in the Tosca Commander export.

These parameters should have just 1 value so as not to effect the generated scenarios, and use a parameter naming scheme that starts with a # (e.g. # Folder Name ). The number of # indicates the depth of the folder (e.g. ### This is 3 deep).

This scheme was originally limited to folder depth only ever staying the same or getting deeper, but not returning to a more shallow depth. With the recent update, it now works more flexibly and you can specify a higher depth after lower depths (for both folder names and individual parameters).

Example:

# Folder A: blank (column A in export)

Param 1: value 1, value 2, value 3 (column B)

Param 2: value 1, value 2 (column B)

## Folder A Deeper Child: blank (column B)

Param 3: value 1, value 2, value 3, value 4 (column C)

## Param 4: value 1, value 2, value 3 (column B)

# Folder B: blank (column A)

### Param 5: value 1, value 2, value 3, value 4 (column C)

Step 2: Export into Tosca Commander option

  • Remember to select the appropriate coverage strength.

Step 3: Copy the content of the exported Excel file. Create an empty Tosca TestSheet and generate its structure from the clipboard.

  • To fill the empty TestSheet with Hexawise scenarios, right-click it, then click the dots to see more options, and select "Create Element Structure from Clipboard".

Step 4: Finalize the TestSheet with all the details necessary for execution

  • Convert the values to instances.

  • Add the required test data that was not part of the Hexawise model, if applicable.


Please let us know at support@hexawise.com if you come across any issues during this process or have ideas about its improvements.


Did this answer your question?