All Revision Clouds Per Sheet Written to Excel

@irenec Your example Excel file seems to show you’d like Sheet Number, Sheet Name, Revision Description, Revision Date, Comments. These are parameter values that come from 3 different element types you will pull the parameter values from- the revision cloud’s owner view (sheet or view element to get sheet number/name), the revision cloud’s revision (to get revision description/date), and the revision cloud itself for the comments.

Right now the graph you are showing is attempting to obtain “Sheet Number” from the Revision Cloud elements, and this is not a parameter that Revision Clouds have. You need to first obtain the Revision Cloud’s owner view, and then get the Sheet Number and Sheet Name parameter values from the owner view. (This will not matter if the revision cloud is drawn on a view or a sheet as @Marcel_Rijsmus has mentioned, as both view and sheet elements have the Sheet Number and Sheet Name parameter). The package Clockwork has a node Element.OwnerView that you will want to use.

For Revision Description and Revision Date, you can get the “Revision” parameter value from your Revision Clouds. This will give you the Revision element which you can obtain the description and date parameter values from. The node Revision Properties from the package archi-lab will help you do this.

The “Comments” parameter value is the only one you will be obtaining directly from your revision cloud elements

I suggest using the Excel.ReadFromFile node with the Excel file that you created to demonstrate how you want your data displayed; this will show you how you will want to structure your lists and you will see for blank values you will want to have nulls in their place. The graph pictured here (although it is for writing revisions on sheet and not clouds) shows how to create lists with nulls for blanks to achieve a similar outcome to yours in Excel: All Revisions per sheet written to Excel

Hope this helps! If you get stuck, post back and include an image of your graph

1 Like