A new documentation is available for Squash TM 2.0 and later versions, check it here
The import/export button lets you manage all your test cases from .zip, .xls, .xlsx or .xlsm files.
You can create, update or delete all test cases you want, but the import tables have to hold mandatory marks.
Depending on your action, files must correspond to a project in the tree structure.
To import:
Reach the Test cases worskpace
Click on [Import/Export] in the library toolbar (described here)
Click on [Import...] in the drop down menu
A pop-up window "Import Excel data" opens up:
Select zip/excel file by clicking on zip/excel button.
Click on [Choose file] and select the file to import
Click on [Download the import template .zip] to download a template for zip file
Click on [Download the import template .xls] to download a template for excel file
You can also choose which encoding you prefer between Windows and UTF-8 by clicking on the drop down box [Encoding] (default value is Windows, this is the most used encoding type. If you don't have to, there is no need to change it).
Click on [Import] to continue or [Cancel] to stop the import
5. A confirmation pop-up window "Import Excel data" opens up, with the following information:
Where your data will be read from
In which project your data will be uploaded
Click on [Confirm] if you want to proceed or [Cancel] to stop the operation
6. A pop-up window summarizing the import opens up. It resumes how many test cases, test steps, parameters and datasets have been successfully uploaded or not.
Click on [Download import log (xls)] if you want more information from the import.
7. The imported test cases have been added to the tree structure, in the project mentioned in your zip/excel file.
The import file must be in .xls, .xlsx or .xlsm format to be interpreted by Squash. It also must follow the different rules listed below.
If you select excel type to import your test cases, the import table needs to have five tabs with mandatory and unrequired columns (ignored columns are not mentioned in the summary tables below). Moreover, you must respect order of the tabs and columns as below.
ACTION mark management:
You must add an ACTION mark to manage test case action. If this column does not exist, the file will not be imported. To use this mark, you will need to add it in all tabs of the import file exept "LINK_REQ_TC" tab. Moreover, ACTION mark is always the first column. It also must follow the different rules listed below:
The file is read in order of appearance: TEST_CASES > STEPS > PARAMETERS > DATASET
If there are several actions in different lines of a same object, they will be dealt with in order of appearance.
To get the standard model, download "From_V1.13_Test-case_import_template_xls.xls" at the bottom of the page.
tab 1: TEST_CASES
tab 2: STEPS
tab 3: PARAMETERS
tab 4: DATASETS
tab5: LINK_REQ_TC
Like mentioned above, the import file must be in .xls, .xlsx format to be read by Squash.
So the zip file has to contain an excel table with one tab (the name of the tab is the name of the test case you want to import), the other ones are ignored.
To import several test cases, you have to create several files (1 file = 1 tab = 1 test case)
To see the standard model, download "test-case_import_template_zip.xlsx" on the bottom of the page.
The table must hold marks in the same order as below:
Other rules for excel and zip files:
The mark is always placed on the first column
The value(s) are placed in the column which follow in the same line
The upload is made line by line, no matter the order of the lines
The field names of the first column are not case sensitive
The lines for which the first column text is not recognized as a mark will be added in the test case description (after the description itself)
The empty lines and formatting are ignored
The cells can not be merged
It must not have empty column between the mark column (first one) and the value column
It is possible to have an infinite number of cells in a line, but only the two (or three for the actions) will be taken in charge