4.11 - Import Test case

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.

4.11.1 Import test case from zip or xls file

To import:

1. Reach the Test cases worskpace

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

3. Click on [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 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.

4.11.2 Create an import test case file, excel type

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

4.11.3 Create an import test case file, zip type

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