Hi all!
I have been using ‘Schedule keys’ with telephone devices as the category for my sheet drawing lists. Works great, unless you need to rearrange or make changes to all dates at once, ect.., all things easily done in excel. I was using DiRoots sheetlink, but they now want +$100/month so I want to make dynamo do the sheet link and not get burned by another free add in going expensive.
Exporting to excel was fairly easy, importing excel also not too bad. (Except the XML version of the import excel node was quirky, so I got the older node) Even found a python node which updates the list in dynamo, but that doesn’t update in my revit schedule. Any help on what I am doing wrong is very much appreciated.
Most excel related posts on here show how to push data to families placed in the model, (doors, rooms, whatever) and not how to update a cell in a schedule key with all data rows.
Oh yes, after importing data from Excel, you should extract it using the first item for the titles and the remaining items for the values. Then, use ‘Group By’ to ensure that Dynamo sets the values in the correct order
Thank you, but it unfortunately I am still getting stuck in essentially the same spot.
The schedule is for telephone devices, but none are placed in the revit model so there is no instance of a family with an element id to replace the parameter value of. All just “data row” info…
In the image below, you will see the all elements of category list is empty.
What do you suggest as a next step?
