Dynamo/Revit tutorial for beginners: Creating Sheets from Excel

Подписаться 48 тыс.

Просмотров 18 тыс.

50% 1

Time to take a step back and revisit the basics of Dynamo to help bring people up a few steps, it can be hard to find where to begin but I hope this helps!
Sign up for my course platform at;
courses.bimguru.education/pag...
I hope you enjoy the session and learn something new! Feel free to comment any feedback/questions below, or follow my channel if you enjoyed this.
Learn more about Dynamo at;
primer.dynamobim.org/
Software used;
Autodesk Revit 2020: www.autodesk.com/products/rev...
Dynamo: dynamobim.org/
DaVinci Resolve: www.blackmagicdesign.com/au/p...
OBS: obsproject.com/
Hardware used;
Camera: www.teds.com.au/blog/canon-eo...
Lapel Mic: www.rode.com/microphones/smart...
Webcam: support.logitech.com/en_us/pr...
Laptop: www.msi.com/Workstation/WT75-...
Microphone: www.jbhifi.com.au/products/ro...
Audio interface: focusrite.com/en/usb-audio-in...
#revit #dynamo #bim

Опубликовано:

20 апр 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 74

@Zlajudin 3 года назад

Perfect example for beginners. I would definitely love to see more of these beginner tuts. Nicely explained. Tnx

@AussieBIMGuru 3 года назад

You're welcome! I'll line a few more up.

@LBprojects-sk2yr Месяц назад

Thank you! Great vid, excelent content

@AussieBIMGuru Месяц назад

Glad you enjoyed it!

@srirambonagiri3635 3 года назад

Hi Gavin. This is very useful content for the beginners like me. Thanks for making such useful content. Looking forward to seeing more in future.

@AussieBIMGuru 3 года назад

You're welcome, glad it was useful!

@ravinderkamboj9649 3 года назад

Thanks Gavin, the way you are explaining excellent.

@AussieBIMGuru 3 года назад

Thanks Ravinder, I'm glad to hear that :)

@mexirio 3 года назад

Starting to understand this dynamo stuff! Thanks Gavin!

@AussieBIMGuru 3 года назад

Glad to hear! Keep up the learning, itll fall into place over time :)

@georgetyson2 3 года назад

Awesome video. you explained it very well and covered a lot of different topics. I also liked that it was simple. For me that is great as I work a specialty not firm so I don't need sheets in all of the other fields. Thank you for the education.

@AussieBIMGuru 3 года назад

You're welcome, glad it was useful!

@sridharelumalai5735 2 года назад

Really a great tutotrial gavin thanks a lot..

@AussieBIMGuru 2 года назад

You're welcome!

@sandeepbhatia2519 2 года назад

Great Dynamo exercise for beginners! Thanks Gavin. Looking forward to some more videos like this suited for beginners.

@AussieBIMGuru 2 года назад

Glad it was helpful!

@sandeepbhatia2519 2 года назад

@@AussieBIMGuru Hi Gavin, I am trying to incorporate other fields like Project Name, Project Number, Drawn by, Revision etc in the same script that you explained in the video to get a fully filled sheet in one go but I am not able to find their respective parameter nodes (nodes for project name, project number, drawn by etc) to feed the data from excel. Any advise? Thanks in Advance.

@AussieBIMGuru 2 года назад

@@sandeepbhatia2519 many of those fields are not actually stored in the sheet object. For example, revisions are applied to sheets separately, and project number/name is stored and set using project information. Project information can be obtained using it's respective category in the dropdown, and then get/set parameter nodes can be used as needed. I have a tutorial here on how to apply/remove revisons in bulk: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kxZOOwgYyy0.html

@sandeepbhatia2519 2 года назад

@@AussieBIMGuru Thank you. That was really helpful.

@mohamedfaisal6654 3 года назад

Thanks for this tutorial really appreciate your work, please make a tutorial on placement of view on sheets

@AussieBIMGuru 3 года назад

You're welcome Mohamed!

@Stevomanguitar 3 месяца назад

Great video. Wondering how we might add more information to our sheets from the excel document. Such as sheet classification and sub discipline?

@AussieBIMGuru 3 месяца назад

You can add additional columns of data, and then index them and use Element.SetParameterByName after sheet creation in order to add extra data in the same workflow. If you store the parameter names in the header row, you can read those as the parameter name to set in order to develop a dynamic amount of parameters/value columns.

@JHG_DZN Год назад

Hi Gavin, I love the videos. I am trying to use your custom node to create new sheets from an excel file. My sheet numbers are formatted with letters (FZ0-0-1001-A6) which are accepted in revit. I am able to get the lists to output the correct lists as strings, but when i input it into the sheets.create node the output is null. when I try with just numbers (1, 2, 3, ...10) the sheets are created. Is there a way to create the sheets with my original sheet names using your node?

@AussieBIMGuru Год назад

I've tested that sheet number and a few similar ones and it worked for me. Make sure there aren't any rogue characters (e.g. whitespace, or UTF-8 incompatible ones like the c in Facade).

@arq.stephanypaolanevarezre5216 5 месяцев назад

Hi, I have a new version, so I dont have the "titleblock type", what can I do?

@AussieBIMGuru 5 месяцев назад

The Rhythm package should have this. Alternatively you can use select model element on a titleblock, then get its type.

@dylanholmes3502 Год назад

Thanks for another great video Gavin. Was wondering if I could ask a couple of questions to add different functionality to the script? Its to do with the Sheet name to be used in Excel. Could I add a functionality where instead of having the node (and subsequent player option) of typing in a sheet name, I could have a predetermined set of options? Like pick from Sheet 1, Sheet 2, Sheet 3 etc? My thinking behind this was , the company I work for would be better suited having one master excel file but with multiple sheets that reflect different stages of the project. So sheet 1 could be for schematic design, sheet 2 contract documentation etc etc Thanks again for all the content

@AussieBIMGuru Год назад

Generally for a final version of this tool I'd suggest sourcing the sheet names/set names etc. from within the Excel file in extra columns. If you want predetermined dropdown lists I believe this was added in Revit 2023 recently or is on the way soon (saw a Dynamo developer showing it on Twitter a while back now). Before then the next best thing is using Data Shapes and a dropdownList UI component.

@lenikrof 3 года назад

How do you link project documentation with Revit? Do you have a linked automated system for it? If you do, do you write the whole documentation in excell? Also, nice tutorial as always.

@AussieBIMGuru 3 года назад

I'm not 100% sure what you mean here. If you mean connecting a document register to Revit, the key is to isolate the pieces of the Excel file that matter (e.g. sheet number/name), and then you can match sheets by their number if you need to update name for example. The Bumblebee package can be used to edit Excel files without destroying the file structure as well.

@samdddify Год назад

Thanks for the tutorial, Gavin. One question, I follow the steps in the video, Titleblock Types node give me the error of Dictionary.ByKeysValues operation failed. (An element with the same key but a different value already exists. Key: titleblockType) The node automatically create another row of titleblockType , I have delete the node and put it back again to make it work.

@AussieBIMGuru Год назад

Potentially an old version of the node maybe. You can also get titleblocks as an element category if needed without custom nodes.

@986523100 3 года назад

Hi Gavin. Thanks for the great tutorial! I have an issue with mine for some reason. I loaded it into the player and it runs fine. The input options don't show though... Any idea why this would be?

@AussieBIMGuru 3 года назад

Hi Cuan. Make doubly sure you have informed your inputs in dynamo that they are in fact inputs. This can be done by right clicking the node and ensuring 'is input' is ticked on.

@986523100 3 года назад

Ah! Thanks @@AussieBIMGuru - I inadvertently switched them to outputs.

@AussieBIMGuru 3 года назад

@@986523100 no worries, I've done that before myself many times!

@oc723 Год назад

Hi Gavin, When i use string to sheetName, it shows a warning. operation failed. but I'm sure the sheet name is correct. Do you know how to fix it? thank you.

@AussieBIMGuru Год назад

It might possibly contain a character that Revit can't support, try naming them with the same name manually and see if Revit gives an error.

@paul-morgan 3 года назад

Fantastic content as always Gavin. Quick question; - How would you go about feeding in more input into sheet creation beyond Number and Name? For example Sheets are created and organised by: Set (Town planning/ Construction etc) > Sheet Series (Shared Parameter) > then Sheet number and name. The "SheetsCreate" Node used only has an expected input of number and name. The excel drawing list would look like this: Column 1 = Sheet Series (Again, shared Parameter within the titleblock - Which can then be used to sort sheet browser) Column 2 = Sheet Number Column 3 = Sheet Name Any guidance would be greatly appreciated!

@AussieBIMGuru 3 года назад

The sheet creation nodes will always output a set of elements, in this case the created sheets. You can take this output and apply a 'setparameterbyname' node after this.

@branopaulik5963 2 года назад

@@AussieBIMGuru I have two parameters in sheets, frst - “Parametr vykresov“, second - “Delenie“ . I tried to add these two parameters to creating sheets in dynamo, frst - “Parametr vykresov“ with value of “OC-NJ“ a second - “Delenie“ with value of “120“. I used these parameters to filter/sort the sheets in Revit. I used “setparameterbyname“, but i don´t know how to set up the element part of the node. I don´t know what i did wrong, but it doesn´t work. Hope you can help. Here is a reference picture of what i made: drive.google.com/file/d/1VozrywrVKUGQ0d7kDuS_aplfpzbtWisc/view?usp=sharing

@AussieBIMGuru 2 года назад

It's hard to say without reading the warnings, but you are feeding over null data into the set parameter node which should not be null, and I suspect that the parameter might not exist at the project level as it is failing to set to the objects in the node anyway. Check for typos in the parameter name to be sure, and also that it is of the storage type 'Text'.

@ArtursCu 2 года назад

Hi Gavin! If you look closely when you try to run system for second time it gives you correct output information but in reality under property browser it created numbers that you did not specify in excel and added same names for it (1005,1006, etc.). I am new in dynamo but I want to introduce this system at work as a basic starting template that can be updated during process maybe you can describe how this can be fixed. Maybe there is some way to tie name directly to number so that this could be updated during work without a chance to loose or create unneeded sheets?

@AussieBIMGuru 2 года назад

Yes with this workflow these days I usually check the existing sheets by number and filter them out if they already exist before creating them.

@emmabnz Год назад

@@AussieBIMGuru Are you able to share this workflow and how we filter out existing sheets? Is there also a way to get it to update to a new name, for example if I change the sheet name of A5.01 in Excel is it possible to get this to update A5.01 in Revit without triggering an error?

@marycarver2500 Год назад

Is there a way to create placeholder sheets instead of the actual sheet?

@AussieBIMGuru Год назад

Yes the Revit API enables this. I have a node in Crumple for creating sheets these days and there is an optional input to make placeholders instead of sheets.

@iftekharkhan8879 3 года назад

Hi sir..how r u..i want to know .how much of Dynamo knowledge need to become revit modeller .and for documentation purpose...thanku

@AussieBIMGuru 3 года назад

Many people learn no Dynamo at all - it is just a tool that can enhance productivity and do things in more intelligent ways than working manually by hand.

@craigjeffcoat6463 2 года назад

How can this be done with a naming strategy that involves Project Code - Originator - Level - Zone - ect.

@AussieBIMGuru 2 года назад

Usually these are best stored as shared parameters associated to sheets at project level. You can then break up the combined number using excel or dynamo and set the sheet number in revit from discipline onwards (A-xxxx).

@adambulpitt7002 2 года назад

Hi Gavin. I'm receiving the error message "No worksheet matches the given string" under the data.importexcel node. Any ideas why that might be?

@AussieBIMGuru 2 года назад

Usually that means the specified name doesnt exist for the worksheets in the target excel file. Make sure you have the case correct and no typos in the sheet name and cross check the excel file.

@adambulpitt7002 2 года назад

@@AussieBIMGuru I'm doing just a test project at the moment to write out and test the script on here. Will the information in my Excel document need to match up with what's in the project? I really appreciate the quick response btw!

@adambulpitt7002 2 года назад

I should add that it reads "Parameter name: sheetName" underneath

@adambulpitt7002 2 года назад

I ran through your video again and noticed I had put a space in the Sheet name string node. Seems to be working now!

@adambulpitt7002 2 года назад

Apologies for the spam my friend. I've got this working in revit 2020 but I'd like to create something similar in 2019. I'm not able to use your Crumple addin and specifically the SheetsCreate node that you've created. Is there a way I can use an older alternative node to work in the way your one does?

@giannidavies3594 2 года назад

Hey I am using Revit 2020. I’ve downloaded the software packages but I get a notification that the data excel import has failed

@AussieBIMGuru 2 года назад

There is a bug with Windows lately that might be the cause, the workaround is to run a repair on your windows build.

@giannidavies3594 2 года назад

@@AussieBIMGuru thank you, have managed to fix my program now

@mthelion1194 2 года назад

Great job, could you please share the script please :)

@AussieBIMGuru 2 года назад

github.com/aussieBIMguru/Dynamo_Scripts

@wtfvladi 2 года назад

I get 'Warning: Data.ImportExcel operation failed.' What can i do about this?

@AussieBIMGuru 2 года назад

Try repairing Excel/MSOffice using the online repair option via add/remove programs.

@wtfvladi 2 года назад

@@AussieBIMGuru will try that 🙏🏼 Thanks

@hyunsulee1212 Год назад

Can I Control name the file?

@AussieBIMGuru Год назад

Not sure what you mean, sorry.

@rik0904 3 года назад

I wonder what dynamo open when you don't have excel

@AussieBIMGuru 3 года назад

I believe it opens nothing, I've always had Excel so haven't been able to test! Most Excel nodes actually access the memory space for Excel as well, so I'm not sure this node would work unless the node purely works by reading the Excel format itself.