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