Extract Material Layer Number from System Families

[sandu_marinPN8F4]

I need to extract a csv file of a material takeoff, by instance, that also includes the number of the material layer in the Revit system family (Ceilings, Floors, Roofs, Walls). 

I know it is not possible with a Material Takeoff schedule. It is possible with a Parts schedule, but it would mean converting all these families to Parts, which is not feasible for large projects. Parts schedules also have limited information.

I have tried to make a pyRevit script with Chat GPT, but it doesn't quite work yet.

Did anybody find a way to do this with an add-in, a Dynamo or a pyRevit script? 

[jeremy_tammik]

It looks to me as if these numbers are simply sequentially assigned to the layers in the compound structure. This compound structure can be accessed, read and evaluated using the API without resorting to any schedule:

• Wall Compound Layers
• Compound Wall Layer Volumes
• Many Issues Resolved
• Migrating the Building Coder Samples to Revit 2012
• Iteration and Springtime – Change is the Only Constant
• Identifying Wall Compound Layers and Parts
• Updating the Wall Compound Layer Structure
• DevCamp Day One
• Validate Roof Type and View OBJ on Android
• What's New in the Revit 2012 API
• Export Wall Parts Individually to DXF
• Setting the Compound Structure Core and Shell Layers
• Wall Compound Layer, Other Geometry and Licenses
• Traditional, 3D Printed & Vertical Compound Structures
• Traditional, 3D Printed & Vertical Compound Structures
• What's New in the Revit 2022 API → 2.1.8. CompoundStructure API

[sandu_marinPN8F4]

Thank you jeremy for the references. I will check them out.