Extract Data from IFC file | Create Door Schedule with Bonsai (formerly BlenderBIM) Spreadsheet Tool
Channel: SPB Production
Date: 06/11/2023

In this tutorial I demonstrate, how to extract data straight from IFC file with Bonsai (fromerly BlenderBIM) IFC authoring software. The data will be extracted to a spreadsheet format, such as xlsx, ods or csv.

In the demonstration example, I received an IFC model of a residential building and nothing else. I need to get information of door types and count from this file, for me to be able to request a quote from contractor. I will use Bonsai (fromerly BlenderBIM) to create such a door schedule.

The same technique can be used for other schedules and quantity takeoffs. Any non-graphical data included in the IFC model can be extracted with Bonsai (formerly BlenderBIM). The tool used for creating schedules is the Spreadsheet tool. This tool uses ifccsv library at the backend.

The resource page with query examples, which can be used with the Spreadsheet Tool:
https://docs.ifcopenshell.org/ifcopenshell-python/selector_syntax.html

Bonsai (formerly BlenderBIM) is a Blender add-on, which enables native IFC authoring. It is a free open source software (FOSS), so it can be downloaded and used freely. 

You can get more information about Bonsai (formerly BlenderBIM) here:
https://bonsaibim.org/

Chapters:
0:00 Intro
0:46 Bonsai (formerly BlenderBIM) Spreadsheet Import/Export tool basic setup
5:07 Add attribute data to the schedule
6:18 Add property data to the schedule
12:02 Group data in the schedule
13:10 Add count and total sum
16:01 Query example source


This video was created with the help of OBS:
https://obsproject.com/

This video was created with the help of GIMP:
https://www.gimp.org/

This video was created with the help of KDEnlive:
https://kdenlive.org/

#BlenderBIM #SPBproduction