Update Column Types from excel spreadsheet

Hello there.

I made a Dynamo script with the purpose of updating the column types to a new sizes according to excel spredsheet and it is working perfectly, but for some reason, nothing is happening to my Revit model. Any idea what am I missing? Any help will be highly appreciated. Thank you in advance.

Use FamilyInstance.SetType from Clockwork Package if you are trying to change the family type.

image

Hi @Allan_Cantos not sure, is the element in setparameter instance ?

Revit_PZSd2k0eBI

1 Like

Looks correct at a glance. Can you expand your inputs to confirm? Also just to confirm 100%, those types are setup correctly in the model? I.e. your 254x254 type isn’t still set to 203x203 or something so it looks like nothing is happening but that types are updating?

1 Like

Hi @sovitek, thaks for your reply. Basically I want to change the column type to a new size; i.e. in index zero from old column size of 203x203x71 to a new column size of 254x254x73. I have all the member sizes I needed loaded already in the project.

1 Like

arhhh yeah is see :wink:

Hi @Hamish, yeah I wonder why nothis is happening. The output gave me the new sizes I needed as you can see in the screenshot but nothing is happening in the Revit when I check one of the column, i.e. the one at index zero, after running the script and close the Dynamo, the column remains at UKC203x203x71 instead of the new UKC254x254x73. As I’ve mentioned in the other reply. all steel column sizes I needed are already loaded in the project. I’m using Revit 2022 by the way.

y u no use my node suggested?
I literally used it for exactly this purpose. to change column types based on an excel sheet…

Hi @pyXam, I haven’t tried it but I will coz I want to get this working so any suggestions are very much appreciated. I’ve got my model open now and will let you know. Thanks for your reply by the way.

Update: I made it to work now by only replacing the Categories node to Select Model Elements instead.

1 Like