Editing BlenderBIM Add-on/BlenderBIM IFCCSV

{{stub}}

The IFC CSV feature of [[IfcOpenShell]] is implemented in [[BlenderBIM Add-on]].

[[File:Name.png|thumb|IFC CSV panel in the BlenderBIM Add-on]]
[[Category:BlenderBIM Add-on]]

You can either query an external IFC model by loading it via file picker or load the currently active IFC file by ticking off the <code>Load from Memory</code> check box. 

You can either use the pipette to select objects currently selected in the 3D view or using the [[BlenderBIM Add-on/Facet Based Selector Syntax |Facet Based Selector Syntax]] specify which IFC classes will be queried.  For example, specify IFC classes manually like <code>IfcWall</code> or <code>IfcSlab</code> or you can use a comma <code>,</code> to select more than one class, like so: <code>IfcWindow, IfcSpace</code>.

You can save your query as a <code>.json</code> template or load an existing template. Here's an simple example. 

[[File:Example.png|none|left]]

Finally, you can save the output to CSV with the <code>Export IFC to CSV</code> button. One usecase of IFC CSV is to quickly bulk edit many values in an IFC file. So after exporting to CSV, you can edit some properties and load them into your model again with the <code>Import CSV to IFC</code> button.

Examples of how to fill out the CSV attribute field are shown in the table below.

{| class="wikitable" 
|- style="font-weight:bold;"
! Description
! IFC CSV Query
! Example output
|-
| colspan="3" style="text-align:center; font-weight:bold;" | Attributes
|-
| Name of element
| Name
| MyWall
|-
| Name of IFC type
| type.Name
| WAL300
|-
| Predefined type on element level
| PredefinedType
| ELEMENTEDWALL
|-
| Predefined type on type level
| type.PredefinedType
| SOLIDWALL
|-
| colspan="3" style="text-align:center; font-weight:bold;" | Property and Quantity Sets
|-
| A dictionary of a property set, its <br />properties with non-null values and <br />an id
| Pset_WallCommon
| {'IsExternal': True, 'id': 16041}
|-
| Value of a single property
| Pset_WallCommon.IsExternal
| TRUE
|- style="border-color:inherit;"
| Quantity set property value. Output is a <br />number (int or float).
| Qto_WallBaseQuantities.Length
| 7, 10.66
|-
| colspan="3" style="text-align:center; font-weight:bold;" | Materials
|- style="border-color:inherit;"
| Name of a single material name, <br />material constituent set name, <br />material profile set name. <br />Note that names of material layer <br />sets will not show here.
| material.Name OR mat.Name
| Concrete, WoodenWindow, SteelColumn
|- style="border-color:inherit;"
| Name of material items. This can be<br />name of a single material, material <br />layers, constituents or profiles
| material.item.Name OR mat.i.Name
| Concrete,['SteelProfile'],<br />['BrickLayer', 'InsulationLayer'],  <br />['WoodenFrame', '3-layer window pane']
|- style="border-color:inherit;"
| Name of the first material item.
| material.item.Name.0
| Concrete, SteelProfile, <br />BrickLayer, WoodenFrame
|- style="border-color:inherit;"
| Name of the material used in the <br />material item, eg. a material used <br />on a material layer.
| material.item.Material.Name
| ['Steel'], ['Brick', 'GlassWool'], <br />['Pine', '3-4-3-4-3 pane']
|- style="border-color:inherit;"
| Thickness of a material layer. In <br />case of a single material, output <br />will be empty. In case of a constituent <br />set or a profile set output will be [None].
| material.item.LayerThickness
| [0.3, 0.2], [3000.0], [None, None]
|- style="border-color:inherit;"
| Property value (eg. mass density) of each <br />material in a material set. Will be [None] if <br />material doesn't have the property. Output is <br />a list.
| material.item.Material.<br />Pset_MaterialCommon.MassDensity
| [15.0, 30.0], [30.0], <br />[2000.0, None], [None, None]
|- style="border-color:inherit;"
| Property value (eg. mass density) of a material. <br />Output is a number (int or float).
| material.Pset_MaterialCommon.MassDensity
| 20, 2000
|-
| Name of a material layer set.
| material.LayerSetName
| LayeredBrickWall
|-
| Names of material layers in a layer set. The same <br />as 'material.item.Name' but this query outputs <br />only for material layer sets.
| material.MaterialLayers.Name
| ['BrickLayer', 'InsulationLayer']
|-
| Thickness of material layers in a layer set. The same <br />as 'material.item.LayerThickness' but this query outputs <br />only for material layer sets.
| material.MaterialLayers.LayerThickness
| [0.3, 0.2]
|-
| Name of the material used in the <br />material layer. The same as 'material.item.Material.Name' <br />but this query outputs only for material layer sets.
| material.MaterialLayers.Material.Name
| ['Brick', 'GlassWool']
|-
| Names of material constituents in a constituent set. The same <br />as 'material.item.Name' but this query outputs <br />only for material constituent sets.
| material.MaterialConstituents.Name
| ['WoodenFrame', '3-layer window pane']
|-
| Name of the material used in the material constituent. The same <br />as 'material.item.Material.Name' but this query outputs only <br />for material constituent sets.
| material.MaterialConstituents.Material.Name
| ['Pine', '3-4-3-4-3 pane']
|-
| Names of material profiles in a profile set. The same <br />as 'material.item.Name' but this query outputs <br />only for material profile sets.
| material.MaterialProfiles.Name
| ['SteelProfile']
|-
| Name of the material used in the material profile.<br />The same as 'material.item.Material.Name' but this query <br />outputs only for material profile sets.
| material.MaterialProfiles.Material.Name
| ['Steel']
|-
| Property value (eg. mass density) of each profile in a <br />material profile set. Output is a list. The same as <br />'material.item.Material.Pset_MaterialCommon.MassDensity' <br />but this query outputs only for material profile sets.
| material.MaterialProfiles.Material.<br />Pset_MaterialCommon.MassDensity
| [20.0], [2400, 3000.0]
|-
| Property value of the first profile in a material profile set. <br />Output is a number.
| material.MaterialProfiles.Material.<br />Pset_MaterialCommon.MassDensity.0
| 20, 2400
|}