Importing Test Cases

 Top  Previous  Next

It is possible to import existing test cases into TestLog from a comma separated variable (CSV) file. TestLog requires that the CSV file be saved in the Excel CSV format. For a description of the Excel CSV format, see below.

 

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;

DATE

YYYY-MM-DD or DD/MM/YYYY

TIME

HHH:MM or HH:MM:SS

TEXT

Plain text

SEPARATED

Plain text separated with “,” eg Dave, Tim

NUMBER

An integer

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

 

30000

Test Phase

TEXT

 

30000

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

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

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 Link

TEXT

 

30000

Priority

NUMBER

Priority value of test case from 0 (highest) – 4 (lowest)

-

Requirements

TEXT

 

512

 

*Max length corresponds to the number of characters that can be stored in a field.

 

For a 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 below for more on CSV format).

To import test cases…

▪Click File – Import – Import Test Case..
Import test cases dialog

Import test cases 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.
▪Click OK to import.

 

The Preserve new lines option will preserve new lines that have been entered in fields that support them.

 

Test suites will be created corresponding to the first column of the CSV file “Test Suite”, and subsequent test cases will be created in these test suites. If a test suite already exists the test cases will be created in the existing test suite. If a test case with the same name already exists in a test suite then a message box will appear asking for permission to overwrite the existing test case, and whether to overwrite all conflicting test cases.