Writing excel data into Revit

Revit
1

I’m in the process of setting up Dynamo so it can read in data from excel and upload it into various pieces of equipment in Revit. I’ve found another problem with my current setup.

Here’s what I have at the moment:

image.jpg1227×884 375 KB

image.jpg1214×872 382 KB

image.jpg976×522 157 KB

image.jpg1015×581 256 KB

I’ve assigned a parameter “Mark” in Revit, and then I name the AHU’s in this parameter, corresponding to those from the schedule

image.png921×353 13.3 KB

This is all working fine, however it’s not very robust. For example, I have AHU-10-01 up to AHU-10-08 in the schedule. If I want to delete AHU-10-03 in Revit, but leave the column in the schedule in case I want it in the future, it will incorrectly assign the data, as it will just do the first 7 columns, rather than skipping the third column, and continuing on.

Another problem is it also assigns only in alphabetical order. The schedules should almost always be in alphabetical order, however if someone was to add another column to the end, and it wasn’t the last piece of equipment in an alphabetical sense, it would again mess up the order.

What I need is some sort of “check” happening. I have the names of the equipment from excel (seen in the List.Deconstruct (first) box). But I need to go through the equipment in Revit, see if the “mark” value matches a certain column, and then upload the data, but I’m not sure how to do this.

Thanks

2

You would need to use either a dictionary (search on the forum) or a database where you can use an SQL query.
I’d recommend the latter.
In your case, you would use the AHU mark as the key to join up relevant data.

Refer to

Alternatively, you could use the Datalink tool to synchronise with a database

Andrew

5

@Andrew_Hannell just got it to work, thanks for your suggestion