This article details how the Hierarchy Tree Configuration spreadsheet works. The Hierarchy Tree Configuration spreadsheet can be uploaded through the Hierarchy Tree Configuration page.

IMPORTANT:  Please make sure to review the "read me" section within the file and follow all of the directions.

Note: The examples in this article were based on sample file available for download in the Hierarchy Configuration page.

Hierarchy Tree Configuration Spreadsheet tabs

Details about each tab in the configuration file are provided below:

Read Me

Gives some information related to the excel file

Config

The Config tab shows where is the sections of the hierarchy tree are configured what will be imported. It's just informative.

Specs

Each row in the Specs tab represents a node in the hierarchy tree.

• Level 1 to 10: Unique code value for the spec. Must be unique, and only one level column can be filled for each row.
• Description: Spec name
• Inspection Group: Inspection group related to the spec. Each spec can be associated with multiple form groups, separated by semicolon (;).
• AttributeFormDef: Attribute form related to the spec. It's match the Attribute Form by the name.