You can import manual tests from a CSV file and associate them with the system of your choice.
Preparing the CSV
The import process reads data from a CSV file. This file must contain a name for the test and can contain additional useful information such as external test ID & URL, description, and requirement ID & URL. It's OK if your CSV has other data, but it won't be usable by CTP and will be ignored by the import process.
The first row of the CSV file should contain column name headers. You will use these headers to associate the data in the file with data elements in CTP, so they should be recognizable. The data that can be imported is described in the table below.
| Data Element | Description | Required? |
|---|---|---|
| Test ID | Identifying name or number for the test. | No |
| Test URL | URL for the test. This should be a properly formed URL, including the protocol (http(s)://). | No |
| Name | Name for the test. | Yes |
| Description | Description of the test. | No |
| Requirement ID | Identifying name or number for the requirement. | No |
| Requirement URL | URL for the requirement. This should be a properly formed URL, including the protocol (http(s)://). | No |
Each element except for Description has a limit of 255 characters and the URLs should be properly formatted. The order of the data in your CSV is not particularly important; you will be able to associate the data in the CSV with CTP data columns during the import process.
Importing the CSV
The import process supports CSV files. See Preparing the CSV for more information about what is expected of the files you import.
To import a file:
- Open the Manual Testing module. Your systems and their environments, as defined in the Environment Manager, are listed here alphabetically. Choose the system into which you want to import manual tests.
- Click Import Tests.
- Click Browse in the dialog that opens and navigate to the CSV file you want to import. Once the file has been read, the dialog will show the CSV's file options plus a table for associating its data with CTP data columns. The CSV headers are shown on the left and the CTP data elements are shown along the top.
- Use the table to associate your CSV data with the appropriate CTP data elements. Since Name is required, it is enabled by default as the first row. If Name is not the first column in your CSV, change it to the correct association, then choose the remaining data associations as appropriate for your CSV.
- Click Import. The tests will be shown in the system's table on the page. You can edit or delete tests from there.
