2 - How to import test cases ?

The import/export button lets you manage all your test cases from .zip and .xls files.

You can create, update or delete all the 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.

2.1 Importing a test case from zip or xls files

To import, go to workspace test cases.

  1. Reach the Test case worskpace

  2. Click on the button [Import/Export] in the library toolbar (described here)

  3. Click on the link [Import...] in the drop down menu

  4. 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 files

      • Click on [Download the import template .xls] to download a template for excel files

      • You can also choose which encoding you want 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 carry on or [cancel] to stop the operation

5. A confirmation pop-up "Import Excel data" opens up, announcing:

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

2.2 Creating an Excel import test case file

The import file must be in .xls, .xlsx format to be interpreted by Squash. It also must follow different rules listed below.

If you select excel type to import your test cases, the import table has to hold four tabs with mandatory and unrequired columns (ignored columns aren't mentioned in summary tables below). More over, you must respect order of the tabs and columns as below .

To see the standard model, download "test-case_import_template_xls(1).xls" on the bottom of the page.

tab 1: TEST_CASES

tab 2: STEPS

tab 3: PARAMETERS

tab 4: DATASETS

2.3 Creating a zip import test case file

Like mentioned above, the import file must be in .xls, .xlsx format to be interpreted by Squash.

So, zip file has to contain an excel table with one tab (tab's name is test case's name 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 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 do 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

2.4 ACTION mark management

To import a test case with excel type, you must add ACTION mark to manage test case action. If this column doesn't exist, file won't be imported.

To use this mark, you will have to add it in all tabs of your file. More over, ACTION mark is always placed on first column.

tab 1: TEST_CASES

tab 2: STEPS

tab 3: PARAMETERS

tab 4: DATASETS

It also must follow different rules listed below:

  • File is read in order of appearance: TEST_CASES > STEPS > PARAMETERS > DATASET

  • If there's several actions in different lines of a same object, there're treated in order of appearance.