I’m new to Dynamo and have been working on my first script. So far so good, but I want to take it to the next level. I currently have a list of data in excel for tanks that I want to feed to Revit tank family’s parameters.
In my spreadsheet I will have ‘Tank number’ in Column A which is each tanks unique ID. In my Revit model each tank will have a Mark value representing the tank number. The tank family will have a a bunch of parameters that will match the data in my spreadsheet.
My question is, how do I get Dynamo to:
Read my ‘Tank no.’ column in Excel
Automatically find corresponding tank family in Revit by matching its Mark parameter
Assign the rest of the data in that row to matching parameters in that family
So far I have managed to do this but it is very much a long-hand way to do it I believe and for every tank (could be up to 400) i will have to create a new script manually, so it needs to be more dynamic with perhaps one script that will do any number of tanks.
I would be really interested to see how someone with more experience would go about it.
Thanks in advance,