CSV TCT Importer

Description

This funcionality allows to importing Test Case Templates from a CSV file.

Configuration

The Importer is available under Administration -> Add-ons -> TestFLO -> Import/Export Test Case Templates → Import from Comma-separated values (CSV)
 

To import TCTs from a file, follow these steps:

1. Select a project that the Test Case Templates will be imported into. Please note the list only contains projects where the Test Case Template issue type exists (i.e. is enabled in the plugin's configuration).
2. Pick a user which will be regarded as the TCT reporter.
3. Optionally select a text custom field for the values from the 10th column of the CSV file.
4. Click the Next button.

5. Choose the CSV file that contains the Test Case Templates to be imported. The structure of the file is described in Figure 2.

   File column delimiter

   A CSV file should be understandable in this context as any text file containing EOL-terminated lines of data separated by a distinctive character, each of which constitutes a single cell, not only a true comma-separated-values file. Please remember that the comma or the semicolon is not the best one, because characters of that kind do often take place in text strings or numbers that make up a cell data. As a column delimiter, please choose a character which is not likely to occur in the content of column cells, otherwise the file will be misinterpreted and the import process will fail. Currently there is no way to escape the occurrences of the delimiter in the cell textual content. We would recommend to use characters such as pipe

6. Optionally you can choose the character encoding for the file (UTF-8 is assumed) and delimiter (comma is the default value).
7. Click 'Begin Import' and the import will start.
8. Information about progress will show up. When the process is done, you will be notified.

Column headers in CSV file:

• issueIndex – ID of Test Case Template
• summary – Test Case Template name
• description – Test Case Template description
• stepGroup – Tests step group (optional)
• tctStepId – ordinal number of a TCT Step row
• Users Columns – List of users columns has to have the same size as in configuration
• components – TCT components
• assigneeId – TCT assignee
• textCfValue – Value of a text custom field
• requirements - Issuekey of issue type chosen as Requirement

Example file for default column setting in Steps configuration: TCT_sample_import.csv