Previously, I used Dynamo to create a feature that imports drawing information into Revit. However, while applying it in a project, I encountered a significant issue: the drawing numbers in Excel conflicted with those already existing in Revit, causing the update to fail. To address this, I implemented a small but crucial fix.
The solution involves temporarily changing the drawing numbers before importing them. Essentially, the drawing numbers from the imported data are replaced with a temporary set using List.replaceItemAtIndex. After the import, a separate correction process updates the drawing numbers to their correct values.
Ideally, the workflow should include nodes at the beginning to identify drawing numbers directly from the Excel file, rather than recording them in the second column. Due to time constraints, I have postponed this optimization and plan to improve it in the future.
Here is the current format of the Excel file:
Drawing Title | Drawing Number | & Drawing Information 1 >; & Drawing Information 2 >; ··· | & Drawing Name 1 >; & Drawing No. 1 >; ······
Below is the updated Dynamo node setup:














Must log in before commenting!
Sign Up