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:
- Select in Ribbon "OctoMesh", the "Import" button.
- A side pane will appear, allowing you to select the "TreePath" import type.
- Select with pressed CTRL key the columns that contain the path and the description.
- Click on the "Read selection" button to read the selected data.
- Search for the tree name in the drop-down list to assign the data to the correct tree.
- Select in the table for each row the type and field:
- Type 'Path' for the path column.
- Type 'Scalar' for scalar values like the description.
- Type 'Ignore' for columns that should be ignored.
- Click on the "Synchronize" button 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:
- Select in Ribbon "OctoMesh", the "Import" button.
- A side pane will appear, allowing you to select the "TreeColumn" import type.
- Select with pressed CTRL key the columns that contain the path and the description.
- Click on the "Read selection" button to read the selected data.
- Search for the tree name in the drop-down list to assign the data to the correct tree.
- Select in the table for each column the type and field:
- Type 'TreeLayer1' for the column contains Level 1
- Type 'TreeLayer2' for the column contains Level 2
- Type 'TreeLayer3' for the column contains Level 3
- Type 'TreeLayer4' for the column contains Level 4
- Type 'Ignore' for columns that should be ignored.
- Click on the "Synchronize" button to import the data into OctoMesh.