A
by alaasquan on 24 Jun 2024, edited 18 Feb 2025
#
Hello guys, i hope you are good!
I'm trying to extract Ifc element materials properties with ifcCSV , like for exemple for a door material layers , want to have the density or thickness of each material layer . I wonder if this is possible to do or not ! doesnt matter if the solution is by using ifccsv or any other tool
Your help matters alot , thank you in advance guys!
T
by theoryshaw on 24 Jun 2024, edited 24 Jun 2024
#
IfcWalls and IfcSlabs can have intelligent layers that you can pull out the material and thickness, but doors typically don't have this 'layer' information.
When say 'layers', as it applies to doors, what do you mean exactly?
J
by John on 25 Jun 2024
#
+2 votes
@alaasquan in IFC4x3 the following works for walls, slabs etc (not doors, windows etc as theoryshaw explains above):
material.item.0.Material.Name Material1
material.item.0.LayerThickness Material1_thick(mm)
material.item.1.Material.Name Material2
material.item.1.LayerThickness Material2_thick(mm)
material.item.2.Material.Name Material3
material.item.2.LayerThickness Material3_thick(mm)
J
by John on 25 Jun 2024
#
+1 votes
the file attached below is my experimental file. To upload to this forum I had to change the file extension to .txt, so to use it, you'll need to download and change the file extension to .json you should then be able to import into BBim in the spreadsheet import/export function
S
by steverugi on 25 Jun 2024
#
+2 votes
Hi @alaasquan
if intereseted please have a look at this link to a folder where I stored an excel file with around 20 possible queries that can be used to export your model as csv, it also includes material layers, profiles, etc..
in the same folder I copied all queries as .JSON files
cheers
A
by alaasquan on 25 Jun 2024
#
hi @theoryshaw , i mean by layers to doors or windows like : glazing layer , framing layer .. Maybe Im not refereing correctly cause im still new to the world of BIM . Thank u
A
by alaasquan on 25 Jun 2024
#
Thanks @John , this would be helpful !
A
by alaasquan on 25 Jun 2024
#
Thank you sir @steverugi , Ive checked these , seems to be clear and insightful !
S
by steverugi on 25 Jun 2024
#
+1 votes
@alaasquan said:
Thank you sir @steverugi , Ive checked these , seems to be clear and insightful !
You are welcome, I am glad you found it useful, I can update the files if you think something needs to be added
A
by alaasquan on 25 Jun 2024
#
I really appreciate it !
I have another question , I wonder if i can extract these thermal elements of a material (material of a wall ) shown in this picture that ive assigned through revit , like emissivity , themal conductivity etc.. is there a way with ifccsv ?

S
by steverugi on 26 Jun 2024
#
+3 votes
Hi @alaasquan
I really appreciate it !
I have another question , I wonder if i can extract these thermal elements of a material (material of a wall ) shown in this picture that ive assigned through revit , like emissivity , themal conductivity etc.. is there a way with ifccsv ?
try going to Geometry and Materials > Materials > Material Property Sets to check if your IFC model rightly imported them in BBIM
I just entered some values like:

and used them in the Spreadsheet Import/Export

I need to investigate it further as to how to show this not as IfcMaterial but in the IfcElement .csv list, I suspect it can be done by using relational objects, will try later this week to get something to share ( materials is uncharted territory for me)
interesting topic btw! cheers
A
by alaasquan on 26 Jun 2024
#
Thanks for the response @steverugi , i tried this but still didnt work appropriatly , yet I really appreciate your time and help !
S
by steverugi on 26 Jun 2024, edited 26 Jun 2024
#
@alaasquan said:
Thanks for the response @steverugi , i tried this but still didnt work appropriatly , yet I really appreciate your time and help !
did you check if material properties were copied in the BBIM model after importing them from the .rvt file? were they properly mapped during the export in the first place?
A
by alaasquan on 27 Jun 2024
#
@steverugi i guess that is the problem , I'm not sure if they were correctly mapped during the export ! I'll try to make sure for their export firstly
Thanks!
S
by steverugi on 29 Jun 2024
#
+4 votes
Hi @alaasquan
I need to investigate it further as to how to show this not as IfcMaterial but in the IfcElement .csv list, I suspect it can be done by using relational objects, will try later this week to get something to share ( materials is uncharted territory for me)
interesting topic btw! cheers
to list porperties of materials by element is even easier than I thought, you can do it this way:
After assigning a value to the material as indicated above use mats.
followed by the same Selector like:
mats.Pset_MaterialCommon.MassDensity
for density or any other material property value assigned to the material

that nicely exports like:

hope it helps, happy modeling :)
A
by alaasquan on 2 Jul 2024
#
Thank you so muck sir for investigating on this issue , it seems interesting ! I have found that we can also use dynamo in Revit to extract the material properties
C
by chachi_ws on 18 Feb 2025
#
+1 votes
The link underneath can be helpfull. I've also been struggling with the syntax of the spreadsheet tool, but when you get the hang of it it's fantastic.
https://docs.ifcopenshell.org/ifcopenshell-python/selector_syntax.html
