@@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.
@@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: ruclips.net/video/kxZOOwgYyy0/видео.html
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.
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.
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.
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
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.
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?
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).
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!
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.
@@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
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'.
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?
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.
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.
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.
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.
Good day Gavin,, I dont know if you have sometime to update your Package to Dynamo 3.0 but it would be great,, and you know what would be greater? teach us how migrate it from .NET 4.8 to .NET8 using c# :) anyways thank you and great video!
Unfortunately I am still very basic with C# so no idea what that involves at this point, my package is 100% written in python for now. My package should generally work in dynamo 3 except for excel and interface nodes that pythonne6 supports, which dynamo team should hopefully fix by revit 2026.
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.
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.
@@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!
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?
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).
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 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?
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.
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.
very useful I had used the script for several times in many projects and saved much time
Glad to hear!
Perfect example for beginners. I would definitely love to see more of these beginner tuts. Nicely explained. Tnx
You're welcome! I'll line a few more up.
Great Dynamo exercise for beginners! Thanks Gavin. Looking forward to some more videos like this suited for beginners.
Glad it was helpful!
@@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.
@@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:
ruclips.net/video/kxZOOwgYyy0/видео.html
@@AussieBIMGuru Thank you. That was really helpful.
Thanks Gavin, the way you are explaining excellent.
Thanks Ravinder, I'm glad to hear that :)
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.
You're welcome, glad it was useful!
Thanks for this tutorial really appreciate your work, please make a tutorial on placement of view on sheets
You're welcome Mohamed!
Really a great tutotrial gavin thanks a lot..
You're welcome!
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.
You're welcome, glad it was useful!
Thank you! Great vid, excelent content
Glad you enjoyed it!
Starting to understand this dynamo stuff! Thanks Gavin!
Glad to hear! Keep up the learning, itll fall into place over time :)
Great video. Wondering how we might add more information to our sheets from the excel document. Such as sheet classification and sub discipline?
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.
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.
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.
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
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.
Hi, I have a new version, so I dont have the "titleblock type", what can I do?
The Rhythm package should have this. Alternatively you can use select model element on a titleblock, then get its type.
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?
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).
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!
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.
@@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
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'.
I get 'Warning: Data.ImportExcel operation failed.'
What can i do about this?
Try repairing Excel/MSOffice using the online repair option via add/remove programs.
@@AussieBIMGuru will try that 🙏🏼 Thanks
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?
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.
Ah! Thanks @@AussieBIMGuru - I inadvertently switched them to outputs.
@@986523100 no worries, I've done that before myself many times!
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.
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.
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.
Potentially an old version of the node maybe. You can also get titleblocks as an element category if needed without custom nodes.
Good day Gavin,, I dont know if you have sometime to update your Package to Dynamo 3.0 but it would be great,, and you know what would be greater? teach us how migrate it from .NET 4.8 to .NET8 using c# :) anyways thank you and great video!
Unfortunately I am still very basic with C# so no idea what that involves at this point, my package is 100% written in python for now. My package should generally work in dynamo 3 except for excel and interface nodes that pythonne6 supports, which dynamo team should hopefully fix by revit 2026.
Is there a way to create placeholder sheets instead of the actual sheet?
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.
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?
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.
@@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!
I should add that it reads "Parameter name: sheetName" underneath
I ran through your video again and noticed I had put a space in the Sheet name string node. Seems to be working now!
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?
How can this be done with a naming strategy that involves Project Code - Originator - Level - Zone - ect.
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).
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?
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.
@@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?
Hi sir..how r u..i want to know
.how much of Dynamo knowledge need to become revit modeller .and for documentation purpose...thanku
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.
Hey I am using Revit 2020. I’ve downloaded the software packages but I get a notification that the data excel import has failed
There is a bug with Windows lately that might be the cause, the workaround is to run a repair on your windows build.
@@AussieBIMGuru thank you, have managed to fix my program now
The Rhythm package doesn't exist now?
It most certainly does exist...
@@AussieBIMGuru it could because of version of Dynamo? I can't find the package in search bar
@@varvaragavrilova8966 hrm maybe. I can see it in 2020, 2021 and 2022 currently.
Great job, could you please share the script please :)
github.com/aussieBIMguru/Dynamo_Scripts
Can I Control name the file?
Not sure what you mean, sorry.
I wonder what dynamo open when you don't have excel
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.