Replace family type of multiple generic models

Revit
, ,
1

Hello everyone,

I have a penetration family (it is a generic model) and it has 4 types Approved, Rejected, Canceled and Pending.

I am trying to replace the type of the generic model (from pending to approved for example) according to an excel spreadsheet that has a column for the status of the penetration.

I can’t seem to be able to do that with OOTB nodes, unfortunately I don’t know python.

Can anyone point me to the right direction?

I have link the sample Revit file and the excel table. Any inputs will be highly appreciated!
I70_BBH_LOP_KXX_MXX_F3_N4XX_Penetration Model.rvt (4.7 MB)

Penetration management sheet.xlsx (11.4 KB)

2

Hi @simo18d2, this can be achieved by setting the element’s Type parameter. Here’s an example. However, you’ll need to determine a method for collecting/sorting the instances in the same order you have in Excel. Since you are working in Excel, you can also use BIMLink if that is a tool you have access to.

image
image2130×1027 177 KB

3

Hey Pete, thank you for your example. I was pretty sure that I had already tried this but apparently I was wrong eheh.

Have a nice day!

1 Like