All Revisions per sheet written to Excel

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 extract the sheet information as well as the revision information but I am struggling to get it to export correctly to Excel, If you see my script it writes the information to Excel but it writes everything to the first cell in Excel, or it seems to overwrite to the first cell continuously, leaving me with only the last item in the list.

Can someone please tell me where I am going wrong.

Thanks heaps,

I would like to put the actual Dynamo script here but I get a message saying that new users can not upload attachments.

@desmond.bolton I cannot see your graph. Could you post your dyn or a link to it?

Here is a DropBox link to the dyn file.

Thanks

https://www.dropbox.com/s/y1d7wedns7mwggq/Revisions%20on%20Sheet%203.dyn?dl=0

Check your data after the List.Transpose node. If you get Empy List like shown below, clean your data before to write to Excel.

Hi Salvatore,

Thanks for your response but I am still experiencing the same issue after adding the list.clean

Here is the new Excel output…

image

Nothing changed :frowning:

Please show your last List.Transpose node output

Hi Salvatore,

Here is the screen grab of the latest .dyn output…

please send a link to your Revit file.

Hi again,

Unfortunately I can not publish the model I am working on as it is a government building that is sensitive. But I have created a test project and the Dynamo graph behaves exactly the same.

If I only have one sheet in the project the information comes out correctly but as soon as I add more sheets the information overwrites itself in the Excel file. If you keep the Excel file open while you run the graph, you can observe the information being written and you can see how it overwrites the information to the first cell in Excel.

There definitely seems to be an issue in the Dynamo graph that is not spreading the information across the Excel spreadsheet and it is sending each entry to the first cell in Excel, leaving me with only the information of the last sheet.

Thanks again,
Des

Test Project.rvt (488 KB)

it has to do with your list structure. For the first sheet in the dummy Revit file, how would like the data to be exported in the Excel File? What would you expect to see?

Hi Salvatore,

I am trying to extract all the sheets from the project and then I want to see all the revisions that are assigned to each sheet, so the output should show the sheet name and number and then list all revisions (whether they be from revision clouds or from the “Revision on Sheet” function), I want to see ALL revisions assigned to each sheet and the revisions will show their sequence number the date of the revision and the description of the revision. Something like this…

Sheet Number: A-102
Sheet Name: Slab Setout
Revision Numbers: 1, 5, 7, 15
Revision Dates: 01/05/18, 02/06/18, 03/07/18, 04/08/18, 05/09/18
Revision Descriptions: For Information, For CD, For CC, Walls Ammended, For Construction

Thanks again,
Des

Hi @desmond.bolton ,

What I meant was that you have you have clear how your data will look in Excel.

For example it could look like that:

Once you have decided that, you have to manipulate your data.

The Excel.WriteToFile node writes each list in a Excel row.

So you need to arrange your data accordingly. Also your structure has to be this type and not … (which you have at the moment)

Read this article about list structure:

http://dynamobim.org/what-does-var-mean/

I hope this helps

1 Like

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 information from []…[] to [][]?

I have tried to flatten the list at various levels but it does not give me the correct output, it will output just the sheet numbers or just the sheet names etc.

As I have mentioned before, I am a newby to Dynamo and I have no previous programming experience, but I am definitely learning as we go along.

Do you have any suggestions on how I can get my list from []…[] to [][] and have it export the data in the format that you have illustrated in your Excel screengrab?

Thanks heaps,
Des

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

You’ll need to use List@Level with your nodes to manipulate your data.

http://dynamobim.org/introducing-listlevel-working-with-lists-made-easier/

Give it a try a post where you get stuck.

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 where I started. The output was even more weird than before I did the split. Am i doing it right?

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

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

@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?