Skip to main content

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


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

Comments

  1. Hi,

    I was unable to finish the script. Could you help me to finish the script. I will send you the script?

    Best Regards,
    Abdullah

    ReplyDelete
  2. Really a beautiful blog.It is very astonishing and marvelous design.

    หนังออนไลน์

    ReplyDelete
  3. what about sending back the excel data back to Revit panel schedules after editing it in excel. Isn't that possible. ?

    ReplyDelete
  4. THANKS FOR SHARING SUCH A AMAZING WORK
    NICE WORK
    Bim consulting UK

    ReplyDelete
  5. is it possible to export these schedules into one sheet?

    ReplyDelete

Post a comment

Popular posts from this blog

Tunnel modeling with Dynamo

Introduction Last week I had a nice conversation with one of my Italian friends. The focus of the conversation was how to model a tunnel in Revit starting from an Excel list of points coming out from Civil 3D.
So the answer was: Dynamo of course!

First input, the section of the tunnel with his diameter; I can't share the details but lets say that we have:

Theoretical excavation profile: 200 mm Precast segment thickness: 500 mm Whit this two elements and the excel of the theoretical cent alignment, we can do everything! Revit profile family The first family we're going to create is a simple circle profile with a diameter parameter. This family will be as a mass category to be able to nest it later in an adaptive component family for the tunnel.  Just save this family...easy!
Tunnel model Now we can create a new family as generic adaptive component and load the profile just created. It's important that the family is able to host rebars for future structural modeling. Whit th…

Multi-pipe support configurator with Dynamo

As always everything is coming from my childhood…ops no, that's another story.
As always everything starts on a white recycled paper just in front of my keyboard; a simple idea becomes immediately a sketch with Revit parameters.


I tried many times different kind of plugins for automatic supports placement, but no one of these is able to create a multi-pipes supports (if I'm wrong, please let me know the name of the plugin). The idea for this script in Dynamo, is to create a support for a bounce of pipes going parallel for a while, and create a group that is possible to copy along the path. I'll not focus on the creation of the families that you need for the support but just to explain the main idea, I have 3 different pieces (steel bar, u-bolt and threaded rod) that I'll compose together to create the final support. The first challenge is to align the pipes to the same BOP (bottom of pipe) because they have to stand on the steel bar and locked with the u-bolt.  The bas…