OSArch Community

BBIM | starting with Selector Syntax to export to CSV?

  1. S by steverugi on 25 May 2024, edited 2 Jun 2024 # +10 votes

    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

  2. M by Moult on 25 May 2024 # +5 votes

    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 :)

  3. S by steverugi on 25 May 2024, edited 25 May 2024 # +2 votes

    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

  4. M by Moult on 25 May 2024 # +2 votes

    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" :)

  5. S by steverugi on 25 May 2024 # +5 votes

    @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

    1. Door Schedule

    2. Window Schedule

    3. Type Schedule

    to the ones already in the folder

    1. Profile Schedule

    2. Space Schedule

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

    cheers

  6. S by steverugi on 27 May 2024 # +1 votes

    added

    1. Lintel Schedule

    2. Beam Schedule

    3. 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

  7. N by Nigel on 28 May 2024 #

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

  8. S by steverugi on 28 May 2024 # +1 votes

    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

  9. C by condur on 28 May 2024 #

    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?

  10. S by steverugi on 28 May 2024 # +4 votes

    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

  11. S by steverugi on 1 Jun 2024 # +2 votes

    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

  12. S by steverugi on 1 Jun 2024 # +6 votes

    update

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

    1. 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

  13. S by steverugi on 2 Jun 2024, edited 2 Jun 2024 # +6 votes

    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

Login or Register to reply.