The IoT data connection feature in Krion 6D enables the analysis of all data related to the 3D structural model of a project. This tool allows users to connect any data in spreadsheets (XLS, CSV, DB) with the 3D model. The spreadsheet data is mapped through a unique ID, such as the IfcGUID. Once the data connection is established, users can use charts to slice and dice the data for further analysis.
Open the 3D model to be analysed from the Documents list. Once the Drawing/Model opens in the 3D viewer, Click on the External Data Tool.
Connection Settings Dialog Open up
· Select Connection: This lets you select the connections that has already being made.
· Connection Type: Select the Connection type from XLS, CSV, or DB based on the file format of the Data file.
Once the Connection type is selected an Icon to upload the Data file will show up
Select the file to upload the Excel Data file and click Attach.
Once the file is uploaded other options will populate for selection.
Identity Column: Select the specific column in a database table that uniquely identifies each Record like the IfcGUID (Industry Foundation Classes Global Unique Identifier)
Model Mapping Column: Model mapping column refers to aligning columns from the source data with the corresponding columns in your data model or schema. This ensures that data from the source fits correctly into the target structure.
Status Column: The status column is used to indicate the current state of a record, such as 'active', 'inactive', 'pending', etc. This is useful for tracking the lifecycle or workflow status of each record
Progress Column: The progress column is used to track the progress of a process related to each record. This could be a percentage, a completion status, or some form of milestone tracking, indicating how far along a record is in a given process
Model Properties: Model properties refer to the metadata and configuration settings of the data model. This can include attributes like data types, constraints, relationships, and other settings that define how the data should be structured and validated
Field Selection: Fields selection allows you to specify which fields (columns) from the data source should be included in the connection or operation. This is useful for filtering out unnecessary data and focusing only on the relevant fields
Timeline: The timeline feature, is typically used to display or conceal a timeline view of data or events. It is a chronological display of records, changes, or activities related to the data. The toggle button allows users to expand or collapse this view for better clarity or focus on other aspects of the inteARFce. When we Click on Show Timeline, Timeline related fields will show up like Planned Start, Planned End, Actual Start, Actual End.
After selecting all the fields, the click onto save the configuration settings.
Click on the to see the data. The Data Dialog will open.
· The Data Dialog window will display the Charts where Model properties can be selected and viewed.
· The Model Items to be displayed in the 3D Viewer can be also Filtered from the Chart Elements or by using the Filter tool
· For the Model Properties (Viz Area, Level, Length) that we have selected either Sum or Count of the elements can be shown in the Chart Data
· Chart Type can be switched between Histogram and Pie Chart
When we choose any Element in Chart 1 (Parent), A Child Chart is shown below for further data analysis on the selected element.
Multiple Child Charts can be generated based on the data we want to analyse.
Note: The tool available in the top right corner of the Data Dialog visualizes the data. Along with the timeline tool, it enables the user to view the project's progress at each instant of time. The Icon turns green when the timeline view begins
tool enables users to view or hide a chart.