Advertisement

Thursday, March 23, 2017

Exporting Schedules to Excel with Dynamo

From the BIM and Others blog:

Dynamo, Revit, Excel, UI...what a wonderful day!

Introduction

Today I'll show you two examples of how to use Dynamo to export existing Revit schedules and how to compose a custom schedule on the fly, to be exported to Excel.

Both of them with a very nice graphical user interface thanks to Data-Shapes (https://data-shapes.net/) package.

Export Schedules

Let's start from the easier. The idea behind this script is to export a list of existing schedules to an Excel file, creating for each schedule a separate tab.
To be able to complete this script you'll need two packages:
  • Data-Shapes for the graphical interfaces
  • BimorphNodes to extract schedules data

The script is very easy and you have to focus only on how to create an interface


Then you can use your input to feed the next nodes.


Finished!

So just push the run button (or use Dynamo Player is you are in Revit 2017.1 or 2017.2) and enjoy the interface.




Export parameters to Excel

In the second script I'll focus on something more interesting. Many times we need to just extract a list of elements in a specific category and we need to extract that damned parameter that is there but that you can't place in a schedule, simple exaple, the Level or the Offset for a Duct! :@

Ok, Dynamo can do this but you've to know the name of the parameter, you've to create a new script and you've to know Dynamo!

This script is exactly for those who don't know Dynamo and for lazy people, like me.

So let's start as always from the interface. This time I want to build an interface able to understand if a category is empty or not and, if the category is empty, produce an alarm and, if the category is not empty, list all the parameters related to that specific category.

First step create the interface to list all categories. As always with Data-Shapes nodes.



Now a very nice trick...if the first interface node is False, the count of element is 0 and only if the first interface is on true, it will count the number of elements ;)

I know sometimes I'm crazy but you like this if you're a Dynamo addicted!


Anyway, let's continue. So now we selected one category and we have elements in this category, we have to build a new interface based on this.


And finally export the values extracted for the selected parameters to an Excel file


Cool!

But what if you don't have elements in the category? Easy you just inform the user!


I love this!

So let's see the script in action





And this is if the category is empty



Known issues

For the export parameters script, if you choose and empty category and empty excel will be opened and saved automatically in your document folder, just delete it!

Dynamo scripts

[ExportSchedules][ExportParameterToExcel]

Rememeber to choose an image as a logo...and enjoy!

Cesare



The original post may be found on the BIM and Other blog.

Dynamo is brought to you by Autodesk. Dynamo for Revit is free.

This add-in is compatible with Revit 2017, 2016, and 2015.

There's more information available on the Dynamo website.

5 comments:

mpguru66 said...

Oh....my....gosh... this is so cool! I'm going to try it out now. Thank you!!

Unknown said...

Hi,

I tried to follow the steps and the snap shot to recreate the dynamo script. I am unable to get the result. The link between the parameters are unable to follow due to multiple snapshots.

Can you help me with finishing the final step? Let me know how can i send you the script.

Best Regards,
Abdullah

Unknown said...

Does this work with 2018.2?

Kind Regards,

Tom

Brenda said...

I don't know if you're still following thie comments here, but I'm having a hitch with using this in Revit 2020, I got a few things tweaked/updated, but it will only output one line of data. Any help would be appreciated, I'm happy to share the specific graph.

Edoardo Pruneri said...

Very useful. Thanks!!