{"id":2413,"date":"2025-08-07T10:30:00","date_gmt":"2025-08-07T00:30:00","guid":{"rendered":"https:\/\/digitalbbq.au\/?p=2413"},"modified":"2025-07-12T08:07:02","modified_gmt":"2025-07-11T22:07:02","slug":"setting-ifc-material-overrides-for-cable-tray-and-conduit","status":"publish","type":"post","link":"https:\/\/digitalbbq.au\/index.php\/2025\/08\/07\/setting-ifc-material-overrides-for-cable-tray-and-conduit\/","title":{"rendered":"Setting IFC Material Overrides for Cable Tray and Conduit"},"content":{"rendered":"\n

In a previous post, we looked at how to set IFC material overrides for pipe fittings<\/a>. But when it comes to cable tray and conduit, things get a bit trickier. Unlike pipe and duct, cable tray and conduit don\u2019t belong to a system in Revit, so there’s no MEP System parameter to piggyback off.<\/p>\n\n\n\n

That\u2019s why most teams colour them using the Service Type<\/em><\/strong> parameter instead. And if you don\u2019t do anything else? You’ll get dull, grey IFC exports. Every time.<\/p>\n\n\n\n

Here’s how to fix that \u2014 properly..<\/p>\n\n\n\n

The Problem With Cable Tray and Conduit<\/h2>\n\n\n\n

Electrical teams often rely on filters to colour tray and conduit in Revit which is driven by the Service Type<\/em><\/strong> parameter. But filters don’t carry through to IFC exports. Without materials applied directly to the elements, your exports stay grey.<\/p>\n\n\n\n

To solve this, we need to generate materials based on the Service Type<\/em><\/strong>, then apply them via the IfcSingleMaterialOverride<\/em><\/strong> parameter.<\/p>\n\n\n\n

The most reliable approach is to set the Service Type at the type level, using predefined conduit and tray types in your template. This means the parameter applied automatically as you model, just set the view filters in your template and voila! No manual intervention. No forgotten elements.<\/p>\n\n\n\n

A caveat \u2014 this will mean duplicating cable tray and conduit fitting types<\/strong> (one for each service type) and updating routing settings to use those fittings for each cable tray and conduit service. While some people don\u2019t love the idea of duplication or growing the template size, the overhead is minimal, and it\u2019s a one-time job that pays off every time you get stuck into actual modelling work.<\/p>\n\n\n\n

Common Pitfalls to Avoid<\/h3>\n\n\n\n

While we’re on the topic, let\u2019s be real. A lot of teams make working with electrical services harder than it needs to be by.<\/p>\n\n\n\n

    \n
  • Using shared parameters instead of native ones.<\/li>\n\n\n\n
  • Manually updating Service Type on every tray run.<\/li>\n\n\n\n
  • Using worksets to override colours (yuck!).<\/li>\n<\/ul>\n\n\n\n

    These hacks might seem<\/em> faster, but they break your data consistency and create more rework later. Especially when IFC or asset data is part of the deliverable.<\/p>\n\n\n\n

    The Solution<\/h2>\n\n\n\n

    Update your materials, collect your elements, and push the correct override \u2014 all based on Service Type.<\/p>\n\n\n\n

    \ud83e\udde0 Pro tip: watch out for inconsistent abbreviations, in the example below, both “E” and “LV” refer to Low Voltage. Either clean them up in your current file or template or handle them in the mapping of your code.<\/p>\n\n\n

    \npublic<\/span> void<\/span> SetElectricalMaterialOverrides<\/span>(<\/span>)<\/span>\n\u00a0 {\n\u00a0\u00a0 UIDocument uidoc = this<\/span>.ActiveUIDocument;\n\u00a0\u00a0 Document doc = uidoc.Document;\n\n\u00a0\u00a0 \/\/ Define service type to material name mapping<\/span>\n\u00a0\u00a0 Dictionary<string<\/span>, string<\/span>> serviceToMaterial = new<\/span> Dictionary<string<\/span>, string<\/span>>\n\u00a0\u00a0 {\n\u00a0\u00a0\u00a0 { \"LV\"<\/span>, \"EL_LV\"<\/span> },\n\u00a0\u00a0\u00a0 { \"E\"<\/span>, \"EL_LV\"<\/span> }, \/\/ No consistency! E is also LV!<\/span>\n\u00a0\u00a0\u00a0 { \"HV\"<\/span>, \"EL_HV\"<\/span> },\n\u00a0\u00a0\u00a0 { \"S\"<\/span>, \"EL_Security\"<\/span> },\n\u00a0\u00a0\u00a0 { \"C\"<\/span>, \"EL_Comms\"<\/span> },\n\u00a0\u00a0\u00a0 { \"F\"<\/span>, \"EL_Fire\"<\/span> }\n\u00a0\u00a0\u00a0 \/\/ Add more mappings as needed<\/span>\n\u00a0\u00a0 };\n\n\u00a0\u00a0 \/\/ Define material colors (RGB)<\/span>\n\u00a0\u00a0 Dictionary<string<\/span>, Color> materialColors = new<\/span> Dictionary<string<\/span>, Color>\n\u00a0\u00a0 {\n\u00a0\u00a0\u00a0 { \"EL_LV\"<\/span>, new<\/span> Color(255<\/span>, 128<\/span>, 0<\/span>) },\u00a0\u00a0\u00a0\u00a0 \/\/ Orange<\/span>\n\u00a0\u00a0\u00a0 { \"EL_HV\"<\/span>, new<\/span> Color(128<\/span>, 0<\/span>, 0<\/span>) },\u00a0\u00a0\u00a0\u00a0 \/\/ Brown\/Maroon<\/span>\n\u00a0\u00a0\u00a0 { \"EL_Security\"<\/span>, new<\/span> Color(0<\/span>, 128<\/span>, 255<\/span>) },\u00a0\u00a0\u00a0\u00a0 \/\/ Blue<\/span>\n\u00a0\u00a0\u00a0 { \"EL_Comms\"<\/span>, new<\/span> Color(0<\/span>, 128<\/span>, 0<\/span>) },\u00a0\u00a0\u00a0 \/\/ Green<\/span>\n\u00a0\u00a0\u00a0 { \"EL_Fire\"<\/span>, new<\/span> Color(128<\/span>, 0<\/span>, 255<\/span>) }\u00a0\u00a0\u00a0\u00a0 \/\/ Purple<\/span>\n\u00a0\u00a0 };\n\u00a0\u00a0 \n\u00a0\u00a0 int<\/span> updatedCount = 0<\/span>;\n\n\u00a0\u00a0 using<\/span> (Transaction tx = new<\/span> Transaction(doc, \"Set Electrical Material Overrides\"<\/span>))\n\u00a0\u00a0 {\n\u00a0\u00a0\u00a0 tx.Start();\n\n\u00a0\u00a0\u00a0 \/\/ Step 1: Ensure materials exist<\/span>\n\u00a0\u00a0\u00a0 foreach<\/span> (var<\/span> kvp in<\/span> materialColors)\n\u00a0\u00a0\u00a0 {\n\u00a0\u00a0\u00a0\u00a0 string<\/span> matName = kvp.Key;\n\u00a0\u00a0\u00a0\u00a0 Color color = kvp.Value;\n\n\u00a0\u00a0\u00a0\u00a0 Material existingMat = new<\/span> FilteredElementCollector(doc)\n\u00a0\u00a0\u00a0\u00a0\u00a0 .OfClass(typeof<\/span>(Material))\n\u00a0\u00a0\u00a0\u00a0\u00a0 .Cast<Material>()\n\u00a0\u00a0\u00a0\u00a0\u00a0 .FirstOrDefault(m => m.Name == matName);\n\n\u00a0\u00a0\u00a0\u00a0 if<\/span> (existingMat == null<\/span>)\n\u00a0\u00a0\u00a0\u00a0 {\n\u00a0\u00a0\u00a0\u00a0\u00a0 ElementId newMatId = Material.Create(doc, matName);\n\u00a0\u00a0\u00a0\u00a0\u00a0 Material newMat = doc.GetElement(newMatId) as<\/span> Material;\n\n\u00a0\u00a0\u00a0\u00a0\u00a0 if<\/span> (newMat != null<\/span>)\n\u00a0\u00a0\u00a0\u00a0\u00a0 {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 newMat.Color = color;\n\u00a0\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0 }\n\n\u00a0\u00a0\u00a0 \/\/ Step 2: Collect cable trays and conduits<\/span>\n\n\u00a0\u00a0\u00a0 FilteredElementCollector elements = new<\/span> FilteredElementCollector(doc)\n\u00a0\u00a0\u00a0\u00a0 .WherePasses(new<\/span> LogicalOrFilter(new<\/span> List<ElementFilter>\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 {\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 new<\/span> ElementCategoryFilter(BuiltInCategory.OST_CableTray),\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 new<\/span> ElementCategoryFilter(BuiltInCategory.OST_CableTrayFitting),\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 new<\/span> ElementCategoryFilter(BuiltInCategory.OST_Conduit),\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 new<\/span> ElementCategoryFilter(BuiltInCategory.OST_ConduitFitting)\n\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 }))\n\u00a0\u00a0\u00a0\u00a0 .WhereElementIsNotElementType();\n\n\u00a0\u00a0\u00a0 \/\/ Step 3: Apply material override<\/span>\n\u00a0\u00a0\u00a0 foreach<\/span> (Element elem in<\/span> elements)\n\u00a0\u00a0\u00a0 {\n\u00a0\u00a0\u00a0\u00a0 Parameter serviceParam = elem.LookupParameter(\"Service Type\"<\/span>);\n\u00a0\u00a0\u00a0\u00a0 if<\/span> (serviceParam == null<\/span> || !serviceParam.HasValue)\n\u00a0\u00a0\u00a0\u00a0\u00a0 continue<\/span>;\n\n\u00a0\u00a0\u00a0\u00a0 string<\/span> serviceType = serviceParam.AsString();\n\u00a0\u00a0\u00a0\u00a0 if<\/span> (string<\/span>.IsNullOrEmpty(serviceType))\n\u00a0\u00a0\u00a0\u00a0\u00a0 continue<\/span>;\n\n\u00a0\u00a0\u00a0\u00a0 if<\/span> (!serviceToMaterial.ContainsKey(serviceType))\n\u00a0\u00a0\u00a0\u00a0\u00a0 continue<\/span>;\n\n\u00a0\u00a0\u00a0\u00a0 string<\/span> materialName = serviceToMaterial[serviceType];\n\n\u00a0\u00a0\u00a0\u00a0 Parameter overrideParam = elem.LookupParameter(\"IfcSingleMaterialOverride\"<\/span>);\n\u00a0\u00a0\u00a0\u00a0 if<\/span> (overrideParam != null<\/span> && !overrideParam.IsReadOnly)\n\u00a0\u00a0\u00a0\u00a0 {\n\u00a0\u00a0\u00a0\u00a0\u00a0 overrideParam.Set(materialName);\n\u00a0\u00a0\u00a0\u00a0\u00a0 updatedCount++;\n\u00a0\u00a0\u00a0\u00a0 }\n\u00a0\u00a0\u00a0 }\n\n\u00a0\u00a0\u00a0 tx.Commit();\n\u00a0\u00a0 }\n\n\u00a0\u00a0 TaskDialog.Show(\"Done\"<\/span>, \"Electrical material overrides applied to \"<\/span>+updatedCount+\" elements.\"<\/span>);\n\u00a0 }<\/code><\/span>Code language:<\/span> C#<\/span> (<\/span>cs<\/span>)<\/span><\/small><\/pre>\n\n\n
    How It Works<\/h3>\n\n\n\n
      \n
    1. Define mappings for Service Type \u2192 Material name and colour<\/li>\n\n\n\n
    2. Create missing materials automatically<\/li>\n\n\n\n
    3. Collect tray and conduit elements<\/li>\n\n\n\n
    4. Apply the override to IfcSingleMaterialOverride<\/em><\/strong><\/li>\n<\/ol>\n\n\n\n
      This method ensures your IFC exports look how they should \u2014 with accurate colours, clean data, and zero manual effort once it’s set up.<\/p>\n\n\n\n
      Have you run into the same grey export issue? Let me know how you solved it, or didn’t, in the comments.<\/p>\n\n\n\n
      <\/p>\n","protected":false},"excerpt":{"rendered":"
      In a previous post, we looked at how to set IFC material overrides for pipe fittings. But when it comes to cable tray and conduit, things get a bit trickier. Unlike pipe and duct, cable tray and conduit don\u2019t belong to a system in Revit, so there’s no MEP System parameter to piggyback off. That\u2019s why most teams colour them…<\/p>\n","protected":false},"author":1,"featured_media":2414,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"How to set IFC material overrides for cable tray and conduit using Service Type, improve your exports with consistent data and automated materials.","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"Grey IFC exports? If you're working with cable tray and conduit, the issue is probably missing materials. Here's how to fix it using Service Type and automation. \ud83d\udc47\n#Revit #BIM #IFC #ElectricalDesign #Automation #DigitalDelivery","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[1],"tags":[77,73],"class_list":["post-2413","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-digital","tag-automation","tag-process"],"jetpack_publicize_connections":[],"jetpack-related-posts":[{"id":2403,"url":"https:\/\/digitalbbq.au\/index.php\/2025\/07\/17\/why-your-pipe-fittings-are-missing-materials-in-ifc-exports-and-how-to-fix-it\/","url_meta":{"origin":2413,"position":0},"title":"Your Pipe Fittings Are Grey in IFC? Here’s Why (And How to Fix It)","author":"Ryan Lenihan","date":"17 July 2025","format":false,"excerpt":"You\u2019ve exported your model to IFC. Pipes look great. Fittings? Grey. Again. What\u2019s going on? This one trips up a lot of teams, because pipe fittings in Revit don\u2019t actually carry system data, even though they look like they do. So when you rely on system-assigned materials for your IFC\u2026","rel":"","context":"In "How to guides"","block_context":{"text":"How to guides","link":"https:\/\/digitalbbq.au\/index.php\/category\/how-to-guides\/"},"img":{"alt_text":"Set of blue PVC pipe fittings isolated on dark background. Blue plastic water pipe. PVC accessories","src":"https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2025\/07\/set-of-blue-pvc-pipe-fittings-isolated-on-dark-background-blue-plastic-water-pipe-pvc-accessories.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2025\/07\/set-of-blue-pvc-pipe-fittings-isolated-on-dark-background-blue-plastic-water-pipe-pvc-accessories.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2025\/07\/set-of-blue-pvc-pipe-fittings-isolated-on-dark-background-blue-plastic-water-pipe-pvc-accessories.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2025\/07\/set-of-blue-pvc-pipe-fittings-isolated-on-dark-background-blue-plastic-water-pipe-pvc-accessories.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2025\/07\/set-of-blue-pvc-pipe-fittings-isolated-on-dark-background-blue-plastic-water-pipe-pvc-accessories.jpg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2025\/07\/set-of-blue-pvc-pipe-fittings-isolated-on-dark-background-blue-plastic-water-pipe-pvc-accessories.jpg?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":2672,"url":"https:\/\/digitalbbq.au\/index.php\/2026\/07\/09\/a-short-story-about-how-nested-families-work-when-exported-to-ifc\/","url_meta":{"origin":2413,"position":1},"title":"A Short Story About How Nested Families Work When Exported to Ifc.","author":"Ryan Lenihan","date":"9 July 2026","format":false,"excerpt":"I had a question come through that\u2019ll sound familiar if you\u2019ve ever pushed Revit \u2192 IFC on a live job: Nested families are carrying asset data in Revit, but that data disappears in the IFC. LOI attributes, classification, IDs.. gone. What's going on? This comes up more than it should,\u2026","rel":"","context":"In "How to guides"","block_context":{"text":"How to guides","link":"https:\/\/digitalbbq.au\/index.php\/category\/how-to-guides\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2026\/07\/house-model-on-floor-real-estate-and-housing-aspi-2026-03-25-09-14-22-utc.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2026\/07\/house-model-on-floor-real-estate-and-housing-aspi-2026-03-25-09-14-22-utc.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2026\/07\/house-model-on-floor-real-estate-and-housing-aspi-2026-03-25-09-14-22-utc.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2026\/07\/house-model-on-floor-real-estate-and-housing-aspi-2026-03-25-09-14-22-utc.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2026\/07\/house-model-on-floor-real-estate-and-housing-aspi-2026-03-25-09-14-22-utc.jpg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2026\/07\/house-model-on-floor-real-estate-and-housing-aspi-2026-03-25-09-14-22-utc.jpg?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":2686,"url":"https:\/\/digitalbbq.au\/index.php\/2026\/07\/16\/data-on-the-host-data-in-the-ifc-not-so-fast\/","url_meta":{"origin":2413,"position":2},"title":"Data on the Host, Data in the IFC? Not So Fast.","author":"Ryan Lenihan","date":"16 July 2026","format":false,"excerpt":"A few days after the last post, I got handed a model that seemed like it should have worked perfectly. The nested families were already set up as Shared. The IFC export was running. The geometry was coming through. But the asset data? Completely missing. When this happens, it\u2019s easy\u2026","rel":"","context":"In "How to guides"","block_context":{"text":"How to guides","link":"https:\/\/digitalbbq.au\/index.php\/category\/how-to-guides\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2026\/07\/colorful-wooden-toy-blocks-on-wood-floor-2026-01-07-06-18-37-utc.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2026\/07\/colorful-wooden-toy-blocks-on-wood-floor-2026-01-07-06-18-37-utc.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2026\/07\/colorful-wooden-toy-blocks-on-wood-floor-2026-01-07-06-18-37-utc.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2026\/07\/colorful-wooden-toy-blocks-on-wood-floor-2026-01-07-06-18-37-utc.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2026\/07\/colorful-wooden-toy-blocks-on-wood-floor-2026-01-07-06-18-37-utc.jpg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2026\/07\/colorful-wooden-toy-blocks-on-wood-floor-2026-01-07-06-18-37-utc.jpg?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":2005,"url":"https:\/\/digitalbbq.au\/index.php\/2024\/05\/02\/extracting-ifc-metadata-directly-in-power-bi-using-power-query\/","url_meta":{"origin":2413,"position":3},"title":"Extracting IFC Metadata Directly in Power BI Using Power Query","author":"Ryan Lenihan","date":"2 May 2024","format":false,"excerpt":"If you work with Industry Foundation Classes (IFC) files and want an easy way to access and analyze the metadata, there's a great article you should check out. \"How to extract data from IFC files\" by Matthew Osment on Medium demonstrates how to use Power Query in Power BI to\u2026","rel":"","context":"In "Digital"","block_context":{"text":"Digital","link":"https:\/\/digitalbbq.au\/index.php\/category\/digital\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2024\/04\/Shift_PowerBi_IFC.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2024\/04\/Shift_PowerBi_IFC.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2024\/04\/Shift_PowerBi_IFC.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2024\/04\/Shift_PowerBi_IFC.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2024\/04\/Shift_PowerBi_IFC.jpg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2024\/04\/Shift_PowerBi_IFC.jpg?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":2400,"url":"https:\/\/digitalbbq.au\/index.php\/2025\/09\/04\/optimising-ifc-files-in-python\/","url_meta":{"origin":2413,"position":4},"title":"Optimising IFC Files in Python","author":"Ryan Lenihan","date":"4 September 2025","format":false,"excerpt":"I came across a Python-based IFC optimiser built on top of IfcOpenShell. It was solid, removing unused spaces, orphaned entities, and redundant metadata, but I saw room to push it further. The original script handled: Removing empty attributes Cleaning up orphaned or unused relationships Removing tiny geometry Flattening the spatial\u2026","rel":"","context":"In "Digital"","block_context":{"text":"Digital","link":"https:\/\/digitalbbq.au\/index.php\/category\/digital\/"},"img":{"alt_text":"Big and small yellow rubber ducks on pink background","src":"https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2025\/07\/big-and-small-yellow-rubber-ducks-on-pink-background.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2025\/07\/big-and-small-yellow-rubber-ducks-on-pink-background.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2025\/07\/big-and-small-yellow-rubber-ducks-on-pink-background.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2025\/07\/big-and-small-yellow-rubber-ducks-on-pink-background.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2025\/07\/big-and-small-yellow-rubber-ducks-on-pink-background.jpg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2025\/07\/big-and-small-yellow-rubber-ducks-on-pink-background.jpg?resize=1400%2C800&ssl=1 4x"},"classes":[]},{"id":2018,"url":"https:\/\/digitalbbq.au\/index.php\/2024\/05\/16\/expanding-on-ifc-metadata-extraction-in-powerbi\/","url_meta":{"origin":2413,"position":5},"title":"Expanding on IFC Metadata Extraction in PowerBI","author":"Ryan Lenihan","date":"16 May 2024","format":false,"excerpt":"In a previous post, \"Extracting IFC Metadata Directly in Power BI Using Power Query,\" we explored how to use Power Query in PowerBI to directly extract metadata from IFC files using a Power Query shared by Shift Construction. If you haven't read that post, I recommend checking it out first\u2026","rel":"","context":"In "Digital"","block_context":{"text":"Digital","link":"https:\/\/digitalbbq.au\/index.php\/category\/digital\/"},"img":{"alt_text":"Currency exchange data graph and charts data","src":"https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2024\/05\/currency-exchange-data-graph-and-charts-data.jpg?resize=350%2C200&ssl=1","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2024\/05\/currency-exchange-data-graph-and-charts-data.jpg?resize=350%2C200&ssl=1 1x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2024\/05\/currency-exchange-data-graph-and-charts-data.jpg?resize=525%2C300&ssl=1 1.5x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2024\/05\/currency-exchange-data-graph-and-charts-data.jpg?resize=700%2C400&ssl=1 2x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2024\/05\/currency-exchange-data-graph-and-charts-data.jpg?resize=1050%2C600&ssl=1 3x, https:\/\/i0.wp.com\/digitalbbq.au\/wp-content\/uploads\/2024\/05\/currency-exchange-data-graph-and-charts-data.jpg?resize=1400%2C800&ssl=1 4x"},"classes":[]}],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/digitalbbq.au\/wp-content\/uploads\/2025\/07\/low-angle-view-of-steel-network-cable-trunking-box-.jpg","_links":{"self":[{"href":"https:\/\/digitalbbq.au\/index.php\/wp-json\/wp\/v2\/posts\/2413","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/digitalbbq.au\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/digitalbbq.au\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/digitalbbq.au\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/digitalbbq.au\/index.php\/wp-json\/wp\/v2\/comments?post=2413"}],"version-history":[{"count":2,"href":"https:\/\/digitalbbq.au\/index.php\/wp-json\/wp\/v2\/posts\/2413\/revisions"}],"predecessor-version":[{"id":2416,"href":"https:\/\/digitalbbq.au\/index.php\/wp-json\/wp\/v2\/posts\/2413\/revisions\/2416"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/digitalbbq.au\/index.php\/wp-json\/wp\/v2\/media\/2414"}],"wp:attachment":[{"href":"https:\/\/digitalbbq.au\/index.php\/wp-json\/wp\/v2\/media?parent=2413"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/digitalbbq.au\/index.php\/wp-json\/wp\/v2\/categories?post=2413"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/digitalbbq.au\/index.php\/wp-json\/wp\/v2\/tags?post=2413"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}