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.