Using TRACEUsing TRACE > Export-ImportExport-Import > Tree Structured Forms

Export to CSV

There are several ways to export a tree structure from TRACE: from the Export page, from the Sidebar and from Tree Editor.

A)   Export page allows export of the entire tree or a selection of branches:

1.    Click Export link in Tasks pane under the selected module. The Main pane displays the available tree structures under the module

2.    Select the Tree to export in Select Tree Data section

3.    Keep the default selection or unchecked/check branches of the tree. Expand/collapse branches to select whatever is needed it to be exported.

4.    Check the need it Export Options (see Export Options )

5.    Click Export button

The export generates a .csv file containing all selected forms of the tree structure in the same order as they are displayed in TRACE.

Each file record starts with the control fields: Form Type, UID (unique record ID), Form ID (visual ID), node Depth and Version and then continues with the selected fields.

B)   Sidebar allows export of a single branch at the time

1.    Click Exit Tree link in Tasks pane under the selected module. The tree displays options for reorder and creating forms.

2.    Click on the Export to CSV icon (Export)

The export generates a .csv file containing the form and its descendants in the same order as they are displayed in TRACE.

Each file record starts with the control fields: Form Type, UID (unique record ID), Form ID (visual ID), node Depth and Version and then continues all form fields.

C)   Tree Editor allows export of the entire tree or a selection of branches, see Export to CSV  

Export Options

·         Indent rows: Indent (add a tab character) to Form Type name for each row to highlight the forms hierarchy.

·         Add system fields: Add the system fields (Created By, Created On, Updated By and Updated On) to the output file.

·         Add header: Add tree header to the export file. A header row is added for each form-type in the structure.

For example, if the tree structure contains Test Group, Test Case and Test Step form-types, the tree header has 3 rows.

·         Select fields: By default, all the fields are exported. Using this option, you can customize the exported fields.

Example

·         Rows indented. System fields added. Tree header added

Form Type

UID

Form ID

Depth

Version

Created By

Created On

Updated By

Updated On

Form Type

UID

Form ID

Depth

Version

Created By

Created On

Updated By

Updated On

Form Type

UID

Form ID

Depth

Version

Created By

Created On

Updated By

Updated On

Test Group

798270

1

1

1

Jane Smith

2014-02-11 01:51 PM EET

Jane Smith

2014-02-11 01:51 PM EET

    Test Group

798271

1.1

2

1

Jane Smith

2014-02-11 03:51 PM EET

John Smith

2014-02-11 03:51 PM EET

        Test Case

798277

1.1.1

3

2

Jane Smith

2014-02-11 03:53 PM EET

Jane Smith

2015-03-06 03:18 PM EET

        Test Case

798280

1.1.2

3

2

Jane Smith

2014-02-11 03:54 PM EET

Jane Smith

2014-02-11 03:54 PM EET

    Test Group

798272

1.2

2

2

Jane Smith

2014-02-11 03:51 PM EET

Jane Smith

2014-02-11 03:51 PM EET

        Test Case

798281

1.2.1

3

1

Jane Smith

2014-02-11 03:54 PM EET

Jane Smith

2014-02-11 03:54 PM EET

        Test Case

798282

1.2.2

3

1

Jane Smith

2014-02-11 03:55 PM EET

Jane Smith

2014-02-11 03:55 PM EET

    Test Group

798274

1.3

2

4

Jane Smith

2014-02-11 03:52 PM EET

Jane Smith

2015-03-04 12:00 PM EET

        Test Case

798283

1.3.1

3

1

Jane Smith

2014-02-11 03:55 PM EET

Jane Smith

2014-02-11 03:55 PM EET

        Test Case

798285

1.3.2

3

1

Jane Smith

2014-02-11 03:55 PM EET

Jane Smith

2014-02-11 03:55 PM EET

Test Group

977267

2

1

1

Jane Smith

2015-03-03 11:41 AM EET

Jane Smith

2015-03-03 11:41 AM EET

Test Group

977266

3

1

1

Jane Smith

2015-03-03 11:41 AM EET

Jane Smith

2015-03-03 11:41 AM EET

Test Group

977370

4

1

1

Jane Smith

2015-03-04 09:27 AM EET

Jane Smith

2015-03-04 09:27 AM EET

Import from CSV

Using Import from CSV for tree structures you can create, update, delete forms or change and renumber the tree structure (refer to Table 5‑1).

When prepare the import file, before doing the actual import, take a closer look at Control Fields, Import Operations and Import Options.

Import file

      Prepare a valid CSV file, UTF-8 encoded

      Each file row represents a form and each column represents a form field

      Field data format respects the rules from Import Fields Data Format

      The best start up for an import file can be obtained by exporting from TRACE the tree itself. In this way the tree header has the correct tree header (field names).

      To update an existing tree structure, it is strongly recommended to first export the tree to.csv, update this file and then import it back in TRACE

      Import file could contain or not a tree header. If the tree structure has 3 form types (like Test Group, Test Case and Test Step) then the tree header must have 3 rows.

1.    Click Import link in Tasks pane under the selected module.

2.    Click Browse button in Import Data section (scroll down the page to see it) and choose a file

3.    Check First rows are tree headers checkbox if the file contain the tree header (rows having the field names)

If this option is check, the complete header of the tree must be provided regardless of the form imported.

For example, if you want to update and reorder only the Test Cases in a structure having Test Group, Test Case, Test Step, the import file needs to have three header rows, even the forms within are just Test Cases.

4.    Click Upload button. The import tool displays the first 4 rows of the import file for each form-type

5.    Select the operation in the Operations section (see Import Operations)

6.    Select how the numbering of forms is made: automatically by TRACE or by user (see Import Operations)

7.    Set a column for each field by selecting the appropriate item from the drop-down menus.

8.    Click Import button.

9.    A summary report is displayed when the import is completed.