Extracting Ifc element material properties with ifcCSV

alaasquanalaasquan
in General

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!

Tagged:

Comments

  • theoryshawtheoryshaw
    edited June 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?

  • JohnJohn

    @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)

    alaasquansteverugi
  • JohnJohn

    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

    alaasquan
  • steverugisteverugi

    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

    theoryshawalaasquan
  • alaasquanalaasquan

    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

  • alaasquanalaasquan

    Thanks @John , this would be helpful !

  • alaasquanalaasquan

    Thank you sir @steverugi , Ive checked these , seems to be clear and insightful !

  • steverugisteverugi

    @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

    alaasquan
  • alaasquanalaasquan

    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 ?

  • steverugisteverugi

    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

    JohnalaasquanMassimo
  • alaasquanalaasquan

    Thanks for the response @steverugi , i tried this but still didnt work appropriatly , yet I really appreciate your time and help !

  • steverugisteverugi
    edited June 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?

  • alaasquanalaasquan

    @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!

  • steverugisteverugi

    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 :)

    emiliotassoJohnRoelalaasquan
  • alaasquanalaasquan

    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

  • chachi_wschachi_ws

    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

    atomkarinca
Sign In or Register to comment.