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

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.

One # = level 1 (core folders); two #s = level 2 (folders for attribute groups), etc.

  • 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.

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 plan, 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?