I recently started making a script that will take a door schedule (Bumblebee package) and add a few additional parameters to the output before exporting to excel (Element ID, GUID, Ironmongery etc).
I’ve tested this in isolation with 3 door families and it worked as expected, however, when testing on a project I ran into a issue. I have a few different door families from different sources and my initial way of filtering only applied to our in-house doors, not the other family types downloaded/created etc.
I’ve been trying to find away to use the Revit schedule (door mark) to filter the list of doors in the project. I’ve tried a few ways and searched a bit but none of the obvious suggestions worked and I can’t figure out why.
I’d like to take the longer list of all door instances and compare it against the shorter one from the Revit schedule, then remove those doors which do not appear in the door schedule. The remaining doors I will match up the Mark numbers of the schedule with those in the project and use this to add additional parameters (I have this part working separately). In the example I have to get the 400oo down to 25. What I’ve noticed in excel is that the blank rows in the schedule are being populated with random (shared nested) doors from the project.