Property Checker Estimated reading: 7 minutes 633 views Bexel Manager offers advanced BIM data checks for automated IDS verification based on predefined check rules. These property checks are based on international standards or any project specific information delivery specifications (IDS). Property Checker add-in, integrated within the software since BEXEL Manager 23 version, allows automated verification if all BIM elements have properties required for each project stage based on predefined check rules. The add-in checks BIM elements (based on their category) for properties, their value types, inclusion in particular property set (property group), whether their values are within a defined range or have a specific value.Property Checker can generate selection sets based on results such as:Property ‘…’ is not defined in property group ‘…’ Property ‘…’ in property group ‘…’ doesn’t have defined value The value of the property ‘…’ in property set ‘…’ is not within the specified range The value of the property ‘…’ in property set ‘…’ does not match any values in the pick list Also, in addition to these checks, it is possible to check the names of specific data based on a defined regex pattern, such as:Family namesSources namesBuilding namesBuilding storey namesEvery selection set description will provide steps to correct failed checks and warnings.Properties can be checked through different phases of the project predefined in the information delivery specification (Concept Design, Design Development, Issue for Construction, As-Built, and Facility Maintenance).Activate the Add-Ins tab within the main ribbon at the top of the screen → Click on the Property Checker add-in → The Property Checker tab with its window will open at the bottom of the screen → Click Import → Choose the proper Excel spreadsheet from Knowledge Base folder, or import the custom created one, as input for data verification → Select project stage from the Phase drop-down menu → Click Evaluate to execute all BIM checks for all elements, or choose Selected Elements Only command from the Evaluate drop-down menu, to run BIM checks for selected elements → After the completion the Info window will be shown with the information that the Data evaluation was successfully finished. While the property checker is running, the progress of the check can be tracked. In the column Result different colored flags will be placed. There are three types of flags:Yellow flag – there are warnings for this element type. Missing property values or wrong property types are classified as warnings.Red flag – there are failed results. Completely missing properties are classified as failed.Green flag – The check was completely successful.In addition, it is possible to monitor the status, how many elements have been checked, how many passed the check, and in what percentage the analysis was successful.Once the check process is complete, selection sets from these results can be created and data exported to the Power BI report or BEXEL Portfolio Manager. Creating selection sets from results To create a selection set for all elements → Click on the Create Selection Set command → Finish the process by clicking the OK button. To create a selection set for selected elements → Select the rule from the list → Choose the Selected Rule Only from the Create Selection Set drop-down menu → Finish the process by clicking OK. Created selection sets will be displayed within the folder named Property Check Results. Selection sets are made only for negative results (passed elements are not shown), and result messages are contained in the name of the selection sets.All created issues organized into selection sets can be sent directly to BCF Manager using the drag-and-drop option. This way, all stakeholders on the project can be informed about found project issues and proceed with resolving them. Export data to Power BI To export data to the Power BI report → Activate the Manage tab at the top of the screen → From the Publish Reports drop-down menu, choose the Property Checker Results → Choose the desired location for the Power BI report → Finish the process by clicking Save. Export data to Power BI with BEXEL Viewer To export data to the Power BI report with BEXEL Viewer → Activate the Manage tab at the top of the screen → From the Publish Report with BEXEL Viewer drop-down menu, choose Property Checker Results (Property Data Check, Property Naming Check, Project Naming Check) → Choose Export Template → The Power BI Export Wizard window will open → Active project and version will be selected by default (if the project is previously published to BEXEL CDE) → Click Finish → Choose the location for Power BI report → Finish the process by clicking Save. Export data to BEXEL Portfolio Manager To export data to BEXEL Portfolio Manager, activate the Add-Ins tab at the top of the screen → Click on the Bexel Portfolio Manager Publish command → The Publish Data to Bexel Portfolio Manager window will open → Choose the option Add a New Project to the Cloud or choose an existing project from the list → Define the Project Name if needed → Click Publish → The message will be shown with the information that the publishing process finished successfully → Finish the procedure by clicking Yes to open Bexel Portfolio Manager in the browser. How to use a sample Excel spreadsheet Populate an Excel spreadsheet with properties for desired element types and sheets related to verifying naming convention data. A sample of the excel file comes with an add-in in the Knowledge Base folder. It should be used as a template, and its formatting should not be altered, but you can create a custom template by editing the data in the file based on the specific project needs. All columns in the sheet Element category must be populated. The exception is column E (Condition) and F (Key). If one of the cells remains empty, that property will not be included in the check (again, the exception is column E and column F).If there is a defined set of values that the property can have, then it is necessary to determine the key in column F. Values with this key will be read from the sheet Pick Lists from column E. Sheet Pick Lists must be in the same place as in the template. If the property can have a defined range of values, then it is necessary to define the condition in column E.List project phases in the sheet named Project Information. It is required to list phases in order of their execution. Also, in this sheet (Project Information) in column C, it is necessary to define the property name that will be used to read the names of the element types from the model (Category Name Property). The category name of the elements in the Excel file must match the names read from the properties of the model defined in the “Project Information” sheet. Also, in the sheet (Property Naming Convention), it is necessary to define the category name in column A, the naming pattern in column B, and the property for a check in column E, row 2. The property values for check are checked based on the defined regex pattern.In the sheet (Project Naming Convention), it is necessary to define a domain in column A, a property for a check in column B, and a naming pattern in column C. All names used for the domain defined in column A are checked. The latest version of this add-in will be automatically pre-installed within BEXEL Manager starting from version 23.0.0.0. A check for a newer version of this plugin will be performed every time BEXEL Manager is started.