Hi all, I have managed to use Dynamo to export schedules into excel including element ID’s. This is all pretty simple, the problem lies when I have manipulated the data in excel I want to be 100% that when I import back to revit the data finds the correct element.
Ideally I want a row on an excel sheet to correspond to and be “locked” an individual element in a model and if that row has either an incorrect or missing Element ID then it won’t write data to revit and hopefully flag up as an error somewhere.
I’m sure this is relatively straightforward but I can’t seem to find the solution - any help would be very much appreciated!
Select by Id or Ids to elements will select elements based on the matching Id. If an element is deleted it wouldn’t do anything. The method does have some concerns though - what if an element family type is changed? What if that element is moved to another place that it doesn’t want to be the excel item anymore? What if element IDs change entirely (this can happen)?
Post your graphs and a diagrammatic example workflow and I can give a bit more info on how this would work in your case.
