BBIM | starting with Selector Syntax to export to CSV?

steverugi

For those, like me, who struggle with selector syntax in Quality and Coordination > Spreadsheet Import/Export I created a table and relevant .json files to start using this great feature in BlenderBIM
in this folder you can access to an .xlsx file with a summary and the .json files named after the summary index number (1st column)

At the end I added some making use of Query and REGEX for advanced criteria

To load a .json file use the DOWN arrow

happy modeling

Moult

This is great! Would you be interested in contributing some of these as presets? That way users can select from a preset dropdown. Stuff like "room schedule" or "door schedule" or "types list" etc sound pretty generic :)

steverugi

hi @Moult

This is great!

thanks

Would you be interested in contributing some of these as presets? That way users can select from a preset dropdown. Stuff like "room schedule" or "door schedule" or "types list" etc sound pretty generic :)

yes, with pleasure

Moult

Nice! If you help isolate a set of JSONs perhaps with feedback from other OSArch users to confirm they work generically across multiple disciplines / projects, I can help build a "preset built-in template feature" :)

steverugi

@Moult said:
Nice! If you help isolate a set of JSONs perhaps with feedback from other OSArch users to confirm they work generically across multiple disciplines / projects, I can help build a "preset built-in template feature" :)

I added
18. Door Schedule
19. Window Schedule
20. Type Schedule

to the ones already in the folder
10. Profile Schedule
12. Space Schedule

I am going to add more if something else comes to mind, or other users post some request here
cheers

steverugi

added
21. Lintel Schedule
22. Beam Schedule
23. Column Schedule

Help

I don't know how to identify IfcElementAssembly , otherwise it would be handy to also add that piece of information in the schedule, like Walls + Coverings (upcoming)

cheers

Nigel

Hi @steverugi could a Plumbing fixtures schedule be useful? taps/faucets sinks/basins toilets showers baths etc

steverugi

hi @Nigel

Hi @steverugi could a Plumbing fixtures schedule be useful? taps/faucets sinks/basins toilets showers baths etc

good idea, let me see if I can translate it into something useful, thanks

condur

I'll try to make one for reinforcement models. @Moult do we already have any presets that we can use, or they are not implemented yet?
I'd like to do the same for IfcClash, try to build up a library of rules to check for specific scopes. What do you think?

steverugi

Hi @Nigel

Hi @steverugi could a Plumbing fixtures schedule be useful? taps/faucets sinks/basins toilets showers baths etc

this should work:

I also added storey and most importantly space, I'd expect sanitaryware to be part of one specific bathroom space for instance

it's nr 24 on the Excel list/JSON files

steverugi

update

thanks to @Moult 's efforts (despite being busy due to the upcoming new release) now we have a new selector parent to identify elements by their aggregate, I am going to add a new query to the list soon
cheers
ping @theoryshaw

steverugi

update

Parent selector now available in Spreadsheet Import/Export and Grouping and Filtering

25. Aggregated elements schedule added

An example to list all elements aggregated in IfcElementAssembly with name ending in "_wall", note parent.Name to list the aggregator

the above might look trivial to some but for models organized and grouped by IfcElementAssembly it is quite a big deal

cheers

steverugi

update (after 240602 release)

now all queries related to elements using a profile are using the new profiles selector

• name = profiles.ProfileName
• X dimension = profiles.XDim
• Y dimension = profiles.YDim

all .JSON files and Excel tables are updated accordingly