Replace Room Name based on Excel File

Revit
, ,
1

Hi to All Dynamo users and masters! :slight_smile:

Im BJ and Im still on the learning curve of using dynamo.

I’d like to ask around if there is a way where I can directly retrieve room info
from my Revit file automatically match it with my excel file to rename the room name parameter?

I have a sample file here. Dynamo Files - Google Drive

My current workflow is having a separate script for exporting the data and importing it back,

Basically, I use dynamo to export the room names and numbers then
I match and editing the excel file manually by copying the information from the reference excel file that corresponds to each data (company name and room name)

then after editing the excel file, I use again dynamo to import the revised exported excel to the revit file.

I felt like there’s a much easer process. Like using only one dynamo file instead of two. and also like a dynamo script where it automatically match the room numbers from Revit to the reference excel file.
if there’s a much simpler process than Im doing right now, that would be amazingly helpful.

Thanks in advance!

BJ

2

Generally two scripts works best in this workflow given that export and import work quite differently.

I generally recommend getting element id as column 1, then other parameters after that - this way you have a unique way of retrieving the room on the import step.

I’ve got a video here showing how to use element Id to retrieve objects in a roundtrip scenarios like this one:

2 Likes
3

Thank you so much for the reply, Gavin. and Thanks for the video as well.
It seems like the safest way for now is to stick with two different script and utilize element ID instead of using directly the room number.

1 Like
4

Hello i recommend you to create Rooms Key schedule in Revit to define any parameter of rooms so you use it as your Excel. You could use Dynamo to change values of key schedule but unless you got many rooms in the project, task looking silly