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.
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 firstname.lastname@example.org if you come across any issues during this process or have ideas about its improvements.