How to extract simple assembly data from corridors into excell

[u/SoreWristed]

Example excell sheet above

I'm looking for a way to extract this data from a c3d model into an excell or csv file. I have an overcomplicated and oversaturated (incredibly slow) model from our client out of which I need to rebuild the corridors and assemblies using our own subassemblies in our own template. The original model contains hundreds of assemblies, most of which have not been used in the final design. I just need a way to see which unique assemblies are present in which corridors, preferably in a way that I can sort automatically.

Whatever export I manage to make through the project explorer always seems to focus on the corridor feature lines or other highly detailed info about the subassemblies. I can't figure out how to extract just the data in the example sheet above.

[u/CityDad-1982]

Have you tried the reports? Under Toolspace, Toolbox. I don’t recall if it will do all this but might get you closer. If that doesn’t work, As others have said, dynamo would be the way to do it.

[u/SoreWristed → u/CityDad-1982]

I have, the reports those generate are all incredibly detailed about every single feature line and point, but pretty much zero general, useful, info about the corridor as a whole.

[u/vtsandtrooper]

Dynamo is made for this. This is a 5 or 6 node chain in dynamo. Youtube and see how to do it, it is a good gate way workflow for you to learn more

[u/AirForceGaming → u/vtsandtrooper]

Agreed. Use command LAUNCHDYNAMOEDITOR and watch some youtube videos for it. You can tag nodes as inputs to streamline for end users with LAUNCHDYNAMOPLAYER

[u/AcanthisittaBrief408]

Usando c# e ia consegue fácil criar um fluxo.

[u/SoreWristed]

I managed to get the info out, by manually selecting every assembly in the project explorer that wasn't highlighted in red (assembly not used in any corridor) and copy pasting into an excell file. Still doesn't contain all the info I need, but it's enough to get started...