This Excel data validation tool is designed to automate the process of validating data records from Revit and IFC project data against specified criteria, converting data formats and exporting the results with detailed validation reports - which describe the percentage of parameter completion and their unique values.
- Group Parameter Customization: Ensures that the specified parameters exist for the groups specified in the tables.
- Report: Generates a report indicating the results of the validation, including whether the parameters for groups exist and are populated, and their unique values.
- Customizable Validation Rules: Users can define custom validation rules and criteria through the Excel interface.
- Automation: Accelerates repetitive tasks by automating data validation for both Revit and IFC projects.
- DDC RVT&IFC Converter: https://datadrivenconstruction.io/index.php/convertors/ necessary free libraries for data conversion from Revit 2015-2023 and IFC2x3.
-
Install Python:
- Download and install Python from the official website: Python.org.
- Make sure to add Python to your system's PATH during installation.
-
Verify Python Installation:
- Open Command Prompt (CMD) and run the following command to check the Python version:
python --version
- You should see an output similar to
Python 3.x.x.
- Open Command Prompt (CMD) and run the following command to check the Python version:
-
Install Required Libraries:
- You can install the necessary Python libraries using pip:
pip install pandas openpyxl
- You can install the necessary Python libraries using pip:
-
Open the
DDC Revit and IFC Validation.xlsxfile:- This file contains all the necessary parameters and settings for the validation process.
- In the Excel document, specify the path to the Revit (IFC, DWG, DGN) file.
- On the next line, specify the path to the corresponding converter for Revit (IFC, DWG, DGN).
- This path must end with the folder "datadrivenlibs".
-
Update the File Path in the Script:
- Open the
Revit and IFC Validation.pyscript. - Locate the variable
file_path_excelin the script. - Update this variable to the path where the
DDC Revit and IFC Validation.xlsxfile is located.file_path_excel = r'C:\Validation\DDC IFC Validation.xlsx'
- Open the
-
Specify Paths for Converter Libraries and Define Data Types to Validate:
- Ensure that all paths to the converter libraries are correctly specified in the Excel file.
- Define the data types to validate as required.
- In the Excel table, write the group of elements (e.g., walls, windows, etc.) you want to validate.
- For each category, specify the parameters you want to check for presence and completeness in the project.
- Execute the script from your terminal or command prompt:
python Revit_and_IFC_Validation.py
- Open the generated report Excel file to review the validation results.
- The report will include details such as data compliance rates, identified issues, and suggestions for corrections.
- Adjust validation settings in the Excel file if needed to fine-tune the results based on the initial output.
- Rerun the tool to apply the new settings.
Contributions to this project are welcome! Here's how you can contribute:
- Fork the Repository: Click on the 'Fork' button at the top right corner of this repository.
- Clone the Repository: Clone the forked repository to your local machine.
- Create a New Branch: Create a new branch for your modifications.
- Make Changes and Commit: Make your changes in the new branch and commit them.
- Push to the Branch: Push your branch to your GitHub fork.
- Create a Pull Request: Open a pull request from your forked repository and we'll review your changes.
If you encounter any issues or have questions, please file an issue on the GitHub repository or write to info@datadrivenconstruction.io
This project is licensed under the MIT License - see the LICENSE file for details.