Import Tree data

The Import section allows the initial import of tree data into OctoMesh.

Trees enable entities to be organized according to various perspectives—such as technical or business-related locations, or functional groupings. As a result, entities in OctoMesh can be filtered and located based on different views.

The Import section is used to load various types of existing Excel data. Currently, OctoMesh supports the following formats:

• TreePath: A single column contains a path that defines each level of the tree. This path is split into segments, from which the tree structure is constructed.
• TreeColumn: Multiple columns each represent a level of the tree. By reading these columns, OctoMesh builds the tree hierarchy accordingly.

TreePath

A typical sample of the original Excel data is shown below:

Path	Description
L1 L2 L3 M1	Machine 1
L1 L2	Level 2
L1 L2 L4	Line 4
L1 L2 L4 M2	Machine 2

To import this data into OctoMesh, follow these steps:

1. Select the OctoMesh tab in the Ribbon and click the Import button.
2. A side pane will appear, allowing you to select the TreePath import type.
3. Select the columns containing the path and the description (hold CTRL to select multiple columns).
4. Click Read selection to read the selected data.
5. Search for the tree name in the drop-down list to assign the data to the correct tree.
6. Configure each column in the table:
   • Path: For the column containing the tree path
   • Scalar: For scalar values like the description
   • Ignore: For columns that should be skipped
7. Click Synchronize to import the data into OctoMesh.

TreeColumn

The original Excel data for the TreeColumn import type is shown below:

Layer 1	Layer 2	Layer 3	Layer 4
L1	L2	L3	M1
L1	L2
L1	L2	L4
L1	L2	L4	M2

To import this data into OctoMesh, follow these steps:

1. Select the OctoMesh tab in the Ribbon and click the Import button.
2. A side pane will appear, allowing you to select the TreeColumn import type.
3. Select the columns containing the tree levels (hold CTRL to select multiple columns).
4. Click Read selection to read the selected data.
5. Search for the tree name in the drop-down list to assign the data to the correct tree.
6. Configure each column in the table:
   • TreeLayer1: For the column containing Level 1
   • TreeLayer2: For the column containing Level 2
   • TreeLayer3: For the column containing Level 3
   • TreeLayer4: For the column containing Level 4
   • Ignore: For columns that should be skipped
7. Click Synchronize to import the data into OctoMesh.