Good day everybody, I am a noob to Dynamo and I need some assistance, please. I am trying to write all the revisions that are associated to each sheet in a Revit project so that the management can track the design changes quickly and see what sheets the revision happened on. I have managed to ext…

Ah there are two conditions that the current graph will fail by the List.Deconstruct node: Sheets with no revisions, because they produce an Empty List Sheets with only one revision, because they produce a list with only one item The graph I shared above failed to account for these conditions bec…

Hi Salvatore, Thanks for sticking with me on this, and that image that you have posted is exactly what I want to see in Excel, sorry for the confusion. This is where I am getting stuck though… I see what you mean about the [][] being required by the Excel.WriteToFile node but how do I get my infor…

it will take you a few nodes in order to get the data how you want it: I would start splitting the data because of the different structure [image] You’ll need to use List@Level with your nodes to manipulate your data. http://dynamobim.org/introducing-listlevel-working-with-lists-made-easier/ G…

Hi Salvatore, I have tried that already and I got stuck again because once you split the data you can not put two streams of data into the Excel.WriteToFile node, you can only wire one at a time. So, I put in a List.Combine node and put that into the Excel.WriteToFile node but I just ended back whe…

Hi @desmond.bolton you need split it first and put back together at the end

[image] desmond.bolton: to write all the revisions that are associated to each sheet in a Revit project so that the management can track the desig What I do is utilize Pivot Tables in Excel than to get Dynamo to List out Data as you desire. Have you tried testing that route?

similar/same topic [image] Sheet List with Revision Matrix Revit @dmiller This is certainly on my (very long) list of “things that Revit really should be able to do by now”. Most design offices resort to a time consuming and error prone method of Excel to produce drawing …

@Andrew_Hannell - do you have a Revit Ideas feature request in for this?

Hi @desmond.bolton you need split it first and put back together at the end Hi Salvatore, This is my problem… How do you do this?

[image] cftrevizo: What I do is utilize Pivot Tables in Excel than to get Dynamo to List out Data as you desire. Have you tried testing that route? Hi, I have no experience with pivot tables so unfortunately I can’t do this. :frowning:

Hi Everyone, Still struggling but still trying :slight_smile: I have made some progress, I think… Here is my latest .dyn version with each list split from the rest and then combined and flattened. At least I am getting the information spread across the Excel sheet now and it is in a readable forma…

All Revisions per sheet written to Excel

Revit

Andrew_Hannell May 12, 2018, 9:34am 18

similar/same topic

Topic		Replies	Views
HELP! All Revisions Per Sheet to Excel Revit dynamo	25	414	February 12, 2025
Export Sheet Revisions Report Mass Data Revit excel , dynamo , list-filter	6	2849	May 9, 2019
Exporting the list of Revisions to Excel Revit	9	2399	May 26, 2018
Dynamo/Python script for document transmittal Revit revit , python , dynamo	29	634	April 1, 2024
Revision on Sheet Property Revit	27	4218	December 20, 2018

All Revisions per sheet written to Excel

Related topics