BBIM | starting with Selector Syntax to export to CSV?

edited May 25 in General

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

carlopavJohnMassimoOwura_quNigelAceGerardTtheoryshaw

Comments

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

    steverugiMassimoOwura_quJohnNigel
  • edited May 25

    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

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

    steverugiJohn
  • @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

    Owura_quJohnAceGorgiousKoAra
  • 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

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

  • 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

    Nigel
  • 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?

  • 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

    JohnNigelMassimoGorgious
  • 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

    MassimoJohn
  • 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

    theoryshawJohnMassimoAce
  • edited June 2

    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

    emiliotassoAceGerardTJohn
Sign In or Register to comment.