|
Each line of the CSV import file should contain the following fields, in the following order. The fields correspond to the generic test case dialog fields described above.
The formats are the same as described in section Importing Test Cases.
Field Name
|
Format
|
Comments / Example
|
Max Length*
|
Type
|
TEXT
|
Indicates whether this record is a test case or a test suites. Use “case” to indicate it is a test case and “suite” for a test suite
|
5
|
Test Suite
|
TEXT
|
|
64
|
ID
|
TEXT
|
|
64
|
Title
|
TEXT
|
|
256
|
Expected Duration
|
TIME
|
1:20
|
-
|
Test Type
|
TEXT
|
|
-
|
Test Phase
|
TEXT
|
|
-
|
Recommended Config Ids
|
SEPARATED
|
It is advised to leave this field blank if no configs are already defined
|
30000
|
Test Resources
|
SEPARATED
|
It is advised to leave this field blank if no resources are already defined
|
30000
|
Status
|
TEXT
|
Should correspond to one of the 5 available (Pass, Fail, Other etc)
|
-
|
Attempts
|
NUMBER
|
5
|
-
|
Last Attempt Date
|
DATE
|
2004-05-13
|
-
|
Last Attempt Time
|
TIME
|
12:44:00
|
-
|
Actual Duration
|
TIME
|
1:15
|
-
|
Testers
|
SEPARATED
|
It is advised to leave this field blank if no testers are already defined
|
30000
|
Fault ID
|
TEXT
|
|
30000
|
Change Request ID
|
TEXT
|
|
30000
|
Results Obtained
|
TEXT
|
|
40000
|
Version Tested
|
TEXT
|
|
30000
|
Build Tested
|
TEXT
|
|
30000
|
External Results Link
|
TEXT
|
|
30000
|
Result Notes
|
TEXT
|
|
40000
|
Requirements
|
TEXT
|
|
512
|
Created Date
|
DATE
|
2004-05-13
|
-
|
Created Time
|
TIME
|
12:44:00
|
-
|
Last Update Date
|
DATE
|
2004-05-13
|
-
|
Last Update Time
|
TIME
|
12:44:00
|
-
|
Created By
|
TEXT
|
|
30000
|
Last Update By
|
TEXT
|
|
30000
|
Prerequisites and Initial Condition
|
TEXT
|
|
40000
|
Test Description and Steps
|
TEXT
|
|
40000
|
Expected Results
|
TEXT
|
|
40000
|
Notes 1
|
TEXT
|
|
40000
|
Notes 2
|
TEXT
|
|
40000
|
External Description Link
|
TEXT
|
|
30000
|
Priority
|
NUMBER
|
Priority value of test case from 0 (highest) – 4 (lowest)
|
-
|
*Max length corresponds to the number of characters that can be stored in a field.
For a project test case, the Type, Test Suite, and ID fields must be present. Any subsequent fields must be ordered as above. For a test suite, a line with the type “suite”, only the values for Type, Test Suite, ID, Title and Description are used. An empty field can be denoted by the sequence ,, (see above for more on CSV format).
To import project test cases…
| ▪ | Click File – Import – Import Project Test Case |
 Project test case import dialog | ▪ | In the Input Source Filename edit box, enter the path to the CSV file your import data is saved to. You may click the browse button and browse to the file. |
| ▪ | In the Import Destination Import to… select a project to import the project test cases into |
The Preserve new lines option will preserve new lines that have been entered in fields that support them.
When importing project test cases a test suite will be created corresponding to the Test Suite values for each line in the CSV file, if the test suite already exists it will create the new project test case in that suite.
Also note that when importing test cases and project test cases warning messages may appear if certain fields are empty or do not conform to the expected definition. In some cases a default value my be used, such as the current date, and you will be given the option to skip further warning messages for that import.
| 
