Hallo Aussie, I downloaded all the packages you mentioned in the video and in the comments below. However, I still can't find the "Schedule.by.type" Node. Is it in the latest Crumple package?
Another really useful video. I just wondered whether you ever use Power query in Excel to aid your workflow from Revit to Excel for a one way information flow? It seems as though no one really recognises what it can do and how it can speed things up. Contractor’s much prefer to receive data in Excel format as they can use it out straight away, rather than transcribing it from a print out. With Power query once you’ve set up your Query (which is a piece of cake compared to Dynamo) its just a matter of outputting another CVS file from Revit, overwriting the previous one and then opening your Excel schedule, click update and voila.
Yes Power Query is definitely a viable alternative, and more well suited to non-programmers as well. Personally I mostly find I do all the data wrangling, or other programmers I delegate to - no matter how smart of a tool we put forward to non-users, getting them into the model is always the real barrier. I've even built one press tools that open the model and mine for them, but the culture of 'being busy' is a serious one to overcome also at the higher level. As a result, typically I find myself or my colleagues use Dynamo, Speckle, Ideate and DiRoots SheetLink for most extraction/reimporting process'. Having said that, Power Query is perfect for reformatting/cleaning up data like this. In the past I've dabbled with Bumblebee for Dynamo also which has enabled me to format the appearance of tables, or write to files with pre-formatting applied (it doesn't wipe the file like the default export excel nodes).
Hi sir ...how we can see the survey and project base point of a linked file...i see these two only of existing file...i want to see the survey point of linked file..thanku sir
I really like your video, your video explanation is very clear. I have a question, can you explain what is a vector, the concept is very similar with point, honestly I am too stupid, I don't understand the saying of the official website of the dynamo. thank you so much
Thanks! Try not to see your abilities as lesser/stupid - we all begin somewhere. Once upon a time I knew nothing about Dynamo, and I also didn't know what a vector was too. A vector is a fairly old mathematical concept, see it as a 'movement object. It has a direction, but can also have a magnitude - how far do we move in that direction. For example, a vector of [X=0, Y=0, Z=1] would move us up by 1 unit.
Update in 2024! I tried your script. There 2 things: I dont succeed to make it work even the first part at the node of MultipleInputForm. Nothing happens AND I have not error message after trying it. Then, the second part with the message "Run completed" works witout knowing why. An idea ?
You will likely need to install the ironpython 2.7 custom package (v2.5) as i use packages that since 2023 now depend on it. This will be common to most scripts using custom nodes these days.
Thanx for the video! Nice packages. I think it would be more convinient in using if we can save last path. Gavin, it'd be great if you show how to work with Revit DB Link and is there any sense in using it.
You're welcome! One way I've saved the last path in the past is storing it a the project information field as part of running the script. If the user doesn't provide a path, then the script is built to draw on that stored path instead. I haven't actually used Revit DB link myself as there are so many other options available these days. I would look into Speckle and SheetLink by DiRoots as great free tools for externalizing and returning data to Revit. I have a quick demo of speckle on my channel here, which can send/receive data from repos and also from Excel now too: th-cam.com/video/qVp5YBpF2eg/w-d-xo.html
Hi Aussie Bim Guru I must begin by thanking you for all the tutorials, GREAT JOB!!! Need your help, I would like to import a excel data and create a schedule, thats done, Now I would like to use that created schedule and use as a "LookUpTable". For example, Walls: I got values in Type Mark, I want to use that as a searchKey for my created schedule to pick information from columns that match the searchKey and set parameters from that. Hope you understand what I try to accomplish . Thank You in Advance
Glad the tutorials help! The technique you would use might look a bit like this workflow (but use type mark instead of Id as your matching technique, and use List.IndexOf and List.GetItemAtIndex to retrieve the matches): th-cam.com/video/pFT5vejNzqU/w-d-xo.html
Excellent tutorial, and mine are fully working. Many thanks.On to the schedules in multiple tabs next. Question? 1} Is it possible to take a pre-defined list of schedules with constant names with this script instead of picking them from a list? 2) Also, instead of pointing to an xls, can it takes this from a template holding area, then copies and places this on a network location with the name from a text box asked on the form at the beginning? Once again good work
To answer the questions easily, yes and yes. There is a node in Orchid that can copy a file from a file path. If that file is at a set location then you could copy that file first to a fixed path and point to that instead. You would need to use bumblebee instead of standard export to maintain formatting though. Check out my next video where I do multi schedule export. A preset list could be used, although it would make the script far less versatile.
@@AussieBIMGuru That would be great to see, i understand the flexibility scenario which is great.The reason for me on predefined list it would then stop potential human error on exporting the wrong schedule.
@@dclunie1 unfortunately little tweaks to scripts dont make for very interesting viewing for my general audience - I usually encourage my viewers to have a try at tweaking my methods to suit their needs. If you're newer to dynamo it can serve as a good goal to drive your learning. Ultimately my channel aims to give people ideas and foundations that give them a base to build and learn upon.
Not really familiar with revit rebar unfortunately. I'd suggest that DWG is probably the best format to import/link generally - not sure Dynamo is needed. If you want to make actual 3D rebar then you could get the paths of the rebar from the DWG and use that to create actual rebar I guess.
Excelent video. Only two questions: 1. How do you put numbering inside the codeblocks? and 2. It is possible to create the dynamo player file and give it to other people that doesn't have the packages installed on their computers? Thanks for your time.
Thanks! Assuming I understsnd your question, numbers can be declared in codeblocks as is, without ". Integers with no decimal, numbers with. Unfortunately you need to distribute packages to computers, dynamo player still runs the script in the background ths same way as normal.
@@AussieBIMGuru thanks for your fast answer! About the numbering I'm talking about when you create a new code block you start numbering each imput. I can't do it like that. I think it's something simple. Thanks on advance.
Great script and well explained. One question please. Is there a way to avoid getting Schedule Templates in the user interface for selection? I have schedule templates in my project.
Yes I believe you can filter them using Python and the IsTemplate property. I seem to recall I packaged a node into Crumple that can return if a view is a template also, and if not Clockwork definitely does.
I'm try to running this script but I can not find the uimessenger node in the Crumple package. Can you please tell me which node can I use instead of this?
Hi , I have assigned DB with 12 MCBe as panel..I want a column for MCB rating, Switches and lighting fixtures connected to the switches..it is possible using dynamo?
I would recommend using an app like Ideate BIMLink, BIM42 Excel or DiRoots SheetLink to undertake the 2 way task. You can match elements back in Revit but their ID is needed in most cases, so I suggest not using a schedule if you do this. I have an example of this method here: th-cam.com/video/pFT5vejNzqU/w-d-xo.html
@@AussieBIMGuru Thanks for the fast reply. What i have is a column schedule. Since Revit doesnt have a text style schedule for columns like our standard layout, i was able to build one with parts to make it look as our normal sechedule. I have one master spread sheet schedule where i can fill in the info for the columns (loads, reinf, sizes, ect) i want to export the schedule out into excel, have the design team make the changes, then import it back in. Only trouble i am having with the export, it doesnt put the information in the correct spots when i import it back in. :(.
@@jamessmith8179 it sounds like they may be rearranging the schedule format in excel. Unfortunately most tools cant work that way, as revit is just showing data in schedules that cant be graphically rearranged. If you need a schedule to look like an excel document maybe try out DiRoots tablegen. It isn't live from the model, but can make an excel schedule in the header of a revit one.
Thanks for all your videos! I was wondering is there a way to export the same schedule from multiple revit files? Any way to alter this script to do that?
Unfortunately whilst it is possible, the custom nodes I use here aren't set up for this. There are nodes in Orchid which enable documents to be opened in background (so if your file takes a while to open, it'll still take a while via dynamo). Most functions in Revit API accept any open document versus just the active one, but most packages dont author their nodes to accomodate this.
HI Sir my self Naresh Patel and i ma mep modeler and have knowledge about Revit Arch, interior and mep expert but i dont have knowledge about Dynamo and I want to learn it so can you please suggest me the right way
I build for revit 2020 version, but it should still be available if you search on the package manager for it. You may need to find it in 2020 then copy the package folder manually if you need it for older builds, or you can download it from my github.
Great video and great script! I have one question though. Do you think there is a way to export an image parameter from a schedule to an excel sheet? I have a list of families used in a project that have images attached and would love to be able to get them to excel also including the graphics. Closest I came was with a BumbleBee node, but unfortunately could not get it to work.
As far as I'm aware there isn't a custom package built that can do this (at leastfrom what I've seen when similar queries hit the dynamo forums in the past), but I suspect it would probably be possible given the write Python scripting. Excel API is quite foreign to me, so until someone takes it on I'm not sure it's possible in a simple manner.
Great Video, I tried this but i am getting some issue on Code blocks as i am not getting the 1 and 2 numbers on the code block string can you please explain this point ?
At this step I am just getting items at indices in the output. It is the same as using GetItemAtIndex, but a shorter way. Cross check your outputs are coming out as a list of 3 objects.
thanks for your videos . i want ask you question . Dynamo and Revit Api (C#) and python use for same things. so is better if I learn only one thing from this three . so you think maybe have to do that ? and if will do that i think Revit Api can do anything more than dynamo .so is better learn C# more than dynamo ? or I understand wrong
Ultimately it comes down to what you want to learn and what you want to use it for. C# is required if you want to develop addins for Revit, whilst Python is more suitable for PyRevit or custom package development in Dynamo itself. Both approaches rely on Revit API commands, but are different in Python sometimes to that in C# where the languages differ. Personally I only needed to learn Python for now. I have a video here which might help decide: th-cam.com/video/hf5HTgjFsUU/w-d-xo.html
Hi Gavin, is it possible to cancel the script without setting inputs for Data Shapes UI? when I hit cancel, script makes empty excel file, which I would like to avoid
The main way I can think to do this would be to feel the cancelled output into an If node that either takes an empty input or the file path for Excel. That way the node is unable to write the file successfully when the script is cancelled.
Hi just one curious question came from one of my clients. Is it possible to export 2d and 3D symbols( for example socket, lumanaire) from revit to excel sheet. Waiting for reply thanks
I believe the only way this could even be associated to a family is by setting its image parameter to a photo of that type's symbol - can't recall if they export though anyway. It isn't possible to get the symbol dynamically.
In this script the output of that node is also strings technically - it should be a list of lists with the data in the output typically being string format. If the output of the node is different in description then try installing the latest version of the package - it might have changed.
Hi, Thanks for amazing work bro. Script works fine for my projects in revit 2021 but in old versions like 2020 and 2019 it doesnot work at. Any reason why is that so. Anxiously Waiting for your answer. Again thanks
Strange. Usually it would have something to do with the custom packages. I build Crumple in Revit 2020 so cant guarantee it works in 2019. BiMorph nodes is updated quite often so I expect is stable also. Can you be more specific to as to how it isnt working? I cant really troubleshoot without more information.
@@bilalameer2819 Crumple I always use latest (I am the developer), and same with BiMorph. For this video I believe I used the second to latest build to what is currently on the package manager. I used revit 2020 for this tutorial.
@@AussieBIMGuru Hi played a bit with version BiMorph its working fine now. Thanks for the help. You are doing amazing job Bro. Keep on doing the great work. You just got a life time subscriber.
Hello, i was trying to create the same Dynamo script as you, but problems appear at the first step. I have in my test project schedules, but when i use "Schedules.by.type"(Collect.SchedulesByType) it says that i have no schedules. Why is that so?
Hrm strange, which version of Revit are you using? I have tested this in Revit 2020 and the Collect.SchedulesByType node is returning schedule types for me.
Yes pretty much all packages are free, so not that important! You can install them via the package manager in Dynamo. I usually list the names of required packages during my intro segment.
@@AussieBIMGuru yes good to know. 😅. Btw I can't get anything when I search Bimorph nodes in "search fr a package". My Dynamo Core is 2.0.4.12685 and Dynamo Revit is 2.0.4.12685. How can I get the nodes?
@@Matsyaf I can find it when searching. Try scrolling down to it maybe - it needs to be spelt specifically (search tools in dynamo are generally pretty awful).
@@AussieBIMGuru I got it. I download the package manually. Im at the edge of the steps and got problem with the Code Block, Schedule.GetData and Data.ExportExcel. Code Block : Index was out of range. If non-negative must be less than the size of the list Schedule.GetData : Schedule.GetData operation failed Data.ExportExcel : Data.ExportExcel failed. how to solve this?
Hey Gavin, great video, thanks! Unfortunatelly tried to make it twice, but still does not generate data in my Excel file. Do you know what could be the problem if I followed your script 100%, proved namings and everything else? It actually shows, that script was run succesfully into the excel file, but excel is still empty... Thanks :-)
You're welcome! I'd say it might relate to an issue a lot of people have where Excel for windows is out of sync with the 32/64 bit version that Dynamo targets. Most people ended up having to do a manual repair of Windows to fix this. See a thread here discussing it: forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197
I really love these videos leveraging excel. I need to up my excel game for sure
Glad the video helped!
Hallo Aussie, I downloaded all the packages you mentioned in the video and in the comments below. However, I still can't find the "Schedule.by.type" Node. Is it in the latest Crumple package?
It has been renamed to Collect.SchedulesByType.
This is a very good video, which is helpful to my course design. Thank you
Glad it helped!
Really great script! Works perfectly! thank you a lot!
You're welcome!
Another really useful video. I just wondered whether you ever use Power query in Excel to aid your workflow from Revit to Excel for a one way information flow? It seems as though no one really recognises what it can do and how it can speed things up. Contractor’s much prefer to receive data in Excel format as they can use it out straight away, rather than transcribing it from a print out.
With Power query once you’ve set up your Query (which is a piece of cake compared to Dynamo) its just a matter of outputting another CVS file from Revit, overwriting the previous one and then opening your Excel schedule, click update and voila.
Yes Power Query is definitely a viable alternative, and more well suited to non-programmers as well. Personally I mostly find I do all the data wrangling, or other programmers I delegate to - no matter how smart of a tool we put forward to non-users, getting them into the model is always the real barrier. I've even built one press tools that open the model and mine for them, but the culture of 'being busy' is a serious one to overcome also at the higher level. As a result, typically I find myself or my colleagues use Dynamo, Speckle, Ideate and DiRoots SheetLink for most extraction/reimporting process'.
Having said that, Power Query is perfect for reformatting/cleaning up data like this. In the past I've dabbled with Bumblebee for Dynamo also which has enabled me to format the appearance of tables, or write to files with pre-formatting applied (it doesn't wipe the file like the default export excel nodes).
Hi sir ...how we can see the survey and project base point of a linked file...i see these two only of existing file...i want to see the survey point of linked file..thanku sir
This feature is added in revit 2021 with shared based points, and 2022 graphically. Earlier versions i dont think it's possible.
@@AussieBIMGuru oh ok sir ...
I really like your video, your video explanation is very clear. I have a question, can you explain what is a vector, the concept is very similar with point, honestly I am too stupid, I don't understand the saying of the official website of the dynamo. thank you so much
Thanks! Try not to see your abilities as lesser/stupid - we all begin somewhere. Once upon a time I knew nothing about Dynamo, and I also didn't know what a vector was too.
A vector is a fairly old mathematical concept, see it as a 'movement object. It has a direction, but can also have a magnitude - how far do we move in that direction. For example, a vector of [X=0, Y=0, Z=1] would move us up by 1 unit.
Update in 2024! I tried your script. There 2 things: I dont succeed to make it work even the first part at the node of MultipleInputForm. Nothing happens AND I have not error message after trying it. Then, the second part with the message "Run completed" works witout knowing why. An idea ?
You will likely need to install the ironpython 2.7 custom package (v2.5) as i use packages that since 2023 now depend on it. This will be common to most scripts using custom nodes these days.
Thanx for the video! Nice packages. I think it would be more convinient in using if we can save last path.
Gavin, it'd be great if you show how to work with Revit DB Link and is there any sense in using it.
You're welcome! One way I've saved the last path in the past is storing it a the project information field as part of running the script. If the user doesn't provide a path, then the script is built to draw on that stored path instead.
I haven't actually used Revit DB link myself as there are so many other options available these days. I would look into Speckle and SheetLink by DiRoots as great free tools for externalizing and returning data to Revit.
I have a quick demo of speckle on my channel here, which can send/receive data from repos and also from Excel now too:
th-cam.com/video/qVp5YBpF2eg/w-d-xo.html
@@AussieBIMGuru as I see noone uses Revit DB Link :) Thanx!
@@muratovbim it doesnt seem like it that often. A lot of addins and dynamo enabled more versatile/agile options.
Hi Aussie Bim Guru
I must begin by thanking you for all the tutorials, GREAT JOB!!!
Need your help, I would like to import a excel data and create a schedule, thats done,
Now I would like to use that created schedule and use as a "LookUpTable".
For example, Walls:
I got values in Type Mark, I want to use that as a searchKey for my created schedule to pick information from columns that match the searchKey and set parameters from that.
Hope you understand what I try to accomplish .
Thank You in Advance
Glad the tutorials help!
The technique you would use might look a bit like this workflow (but use type mark instead of Id as your matching technique, and use List.IndexOf and List.GetItemAtIndex to retrieve the matches):
th-cam.com/video/pFT5vejNzqU/w-d-xo.html
Excellent tutorial, and mine are fully working. Many thanks.On to the schedules in multiple tabs next.
Question?
1} Is it possible to take a pre-defined list of schedules with constant names with this script instead of picking them from a list?
2) Also, instead of pointing to an xls, can it takes this from a template holding area, then copies and places this on a network location with the name from a text box asked on the form at the beginning?
Once again good work
To answer the questions easily, yes and yes.
There is a node in Orchid that can copy a file from a file path. If that file is at a set location then you could copy that file first to a fixed path and point to that instead. You would need to use bumblebee instead of standard export to maintain formatting though. Check out my next video where I do multi schedule export.
A preset list could be used, although it would make the script far less versatile.
@@AussieBIMGuru That would be great to see, i understand the flexibility scenario which is great.The reason for me on predefined list it would then stop potential human error on exporting the wrong schedule.
@@dclunie1 unfortunately little tweaks to scripts dont make for very interesting viewing for my general audience - I usually encourage my viewers to have a try at tweaking my methods to suit their needs. If you're newer to dynamo it can serve as a good goal to drive your learning. Ultimately my channel aims to give people ideas and foundations that give them a base to build and learn upon.
@@AussieBIMGuru Thanks, it was worthwhile trying. Yes, I am only a novice, but I will figure it out. Thanks for your help.
D
how can i import rebars details from design softwares into revit using dynamo
Not really familiar with revit rebar unfortunately. I'd suggest that DWG is probably the best format to import/link generally - not sure Dynamo is needed. If you want to make actual 3D rebar then you could get the paths of the rebar from the DWG and use that to create actual rebar I guess.
Ive followed your tutorial step by step in revit 2023, but unfortunally it doesnt work, Is it possible you to share your script? thanks in advance
I keep my scripts here on github with timestamps roughly aligned to the video release date:
github.com/aussieBIMguru/Dynamo_Scripts
Excelent video. Only two questions: 1. How do you put numbering inside the codeblocks? and 2. It is possible to create the dynamo player file and give it to other people that doesn't have the packages installed on their computers? Thanks for your time.
Thanks!
Assuming I understsnd your question, numbers can be declared in codeblocks as is, without ". Integers with no decimal, numbers with.
Unfortunately you need to distribute packages to computers, dynamo player still runs the script in the background ths same way as normal.
@@AussieBIMGuru thanks for your fast answer! About the numbering I'm talking about when you create a new code block you start numbering each imput. I can't do it like that. I think it's something simple. Thanks on advance.
@@gjdelapa ah this feature is added in 2021 and beyond I think. Not available in prior versions.
Great script and well explained. One question please. Is there a way to avoid getting Schedule Templates in the user interface for selection? I have schedule templates in my project.
Yes I believe you can filter them using Python and the IsTemplate property. I seem to recall I packaged a node into Crumple that can return if a view is a template also, and if not Clockwork definitely does.
I'm try to running this script but I can not find the uimessenger node in the Crumple package. Can you please tell me which node can I use instead of this?
Its still there, should be under script > ui.
thank you is running well@@AussieBIMGuru
Hi , I have assigned DB with 12 MCBe as panel..I want a column for MCB rating, Switches and lighting fixtures connected to the switches..it is possible using dynamo?
Haven't got much experience with dynamo and MEP unfortunately, but I'm sure it would be doable. Maybe ask Dynamo forums?
@@AussieBIMGuru that's a good idea..will do it and thanks for the reply!
Great to export data, do you have away to import changes back into revit?
I would recommend using an app like Ideate BIMLink, BIM42 Excel or DiRoots SheetLink to undertake the 2 way task. You can match elements back in Revit but their ID is needed in most cases, so I suggest not using a schedule if you do this. I have an example of this method here:
th-cam.com/video/pFT5vejNzqU/w-d-xo.html
@@AussieBIMGuru Thanks for the fast reply. What i have is a column schedule. Since Revit doesnt have a text style schedule for columns like our standard layout, i was able to build one with parts to make it look as our normal sechedule. I have one master spread sheet schedule where i can fill in the info for the columns (loads, reinf, sizes, ect) i want to export the schedule out into excel, have the design team make the changes, then import it back in. Only trouble i am having with the export, it doesnt put the information in the correct spots when i import it back in. :(.
@@jamessmith8179 it sounds like they may be rearranging the schedule format in excel. Unfortunately most tools cant work that way, as revit is just showing data in schedules that cant be graphically rearranged. If you need a schedule to look like an excel document maybe try out DiRoots tablegen. It isn't live from the model, but can make an excel schedule in the header of a revit one.
Thanks for all your videos! I was wondering is there a way to export the same schedule from multiple revit files? Any way to alter this script to do that?
Unfortunately whilst it is possible, the custom nodes I use here aren't set up for this. There are nodes in Orchid which enable documents to be opened in background (so if your file takes a while to open, it'll still take a while via dynamo). Most functions in Revit API accept any open document versus just the active one, but most packages dont author their nodes to accomodate this.
HI Sir my self Naresh Patel and i ma mep modeler and have knowledge about Revit Arch, interior and mep expert but i dont have knowledge about Dynamo and I want to learn it so can you please suggest me the right way
Begin with the dynamo primer, and give this article I wrote a read as a guide for new users: www.bimguru.com.au/post/dynamo-mistakes-to-avoid
@@AussieBIMGuru Thanks Sir
How I can get crumple and other library from dynamo (Revit Version 2019) ??
I build for revit 2020 version, but it should still be available if you search on the package manager for it. You may need to find it in 2020 then copy the package folder manually if you need it for older builds, or you can download it from my github.
where can I find your share scripts like this one?
Look my channel name up on github.
Great video and great script! I have one question though.
Do you think there is a way to export an image parameter from a schedule to an excel sheet? I have a list of families used in a project that have images attached and would love to be able to get them to excel also including the graphics. Closest I came was with a BumbleBee node, but unfortunately could not get it to work.
As far as I'm aware there isn't a custom package built that can do this (at leastfrom what I've seen when similar queries hit the dynamo forums in the past), but I suspect it would probably be possible given the write Python scripting. Excel API is quite foreign to me, so until someone takes it on I'm not sure it's possible in a simple manner.
Great Video, I tried this but i am getting some issue on Code blocks as i am not getting the 1 and 2 numbers on the code block string can you please explain this point ?
At this step I am just getting items at indices in the output. It is the same as using GetItemAtIndex, but a shorter way. Cross check your outputs are coming out as a list of 3 objects.
thanks for your videos . i want ask you question . Dynamo and Revit Api (C#) and python use for same things. so is better if I learn only one thing from this three . so you think maybe have to do that ? and if will do that i think Revit Api can do anything more than dynamo .so is better learn C# more than dynamo ? or I understand wrong
Ultimately it comes down to what you want to learn and what you want to use it for. C# is required if you want to develop addins for Revit, whilst Python is more suitable for PyRevit or custom package development in Dynamo itself. Both approaches rely on Revit API commands, but are different in Python sometimes to that in C# where the languages differ. Personally I only needed to learn Python for now.
I have a video here which might help decide:
th-cam.com/video/hf5HTgjFsUU/w-d-xo.html
Hi Gavin, is it possible to cancel the script without setting inputs for Data Shapes UI? when I hit cancel, script makes empty excel file, which I would like to avoid
The main way I can think to do this would be to feel the cancelled output into an If node that either takes an empty input or the file path for Excel. That way the node is unable to write the file successfully when the script is cancelled.
Hi just one curious question came from one of my clients. Is it possible to export 2d and 3D symbols( for example socket, lumanaire) from revit to excel sheet. Waiting for reply thanks
I believe the only way this could even be associated to a family is by setting its image parameter to a photo of that type's symbol - can't recall if they export though anyway. It isn't possible to get the symbol dynamically.
My UI never came up when I went to run the code,I have no idea why.
Ensure the inputs come in as a single list of UI objects and if not work your way back through the script to check why.
My Schedule.GatData node is output as string[][] how to change to ScheduleData[][] as your video (8:14)
In this script the output of that node is also strings technically - it should be a list of lists with the data in the output typically being string format. If the output of the node is different in description then try installing the latest version of the package - it might have changed.
Hi, Thanks for amazing work bro. Script works fine for my projects in revit 2021 but in old versions like 2020 and 2019 it doesnot work at. Any reason why is that so. Anxiously Waiting for your answer. Again thanks
Strange. Usually it would have something to do with the custom packages. I build Crumple in Revit 2020 so cant guarantee it works in 2019. BiMorph nodes is updated quite often so I expect is stable also.
Can you be more specific to as to how it isnt working? I cant really troubleshoot without more information.
@@AussieBIMGuru Which versions of these packages are you using for the projects in revit 2020 for example.?
@@bilalameer2819 Crumple I always use latest (I am the developer), and same with BiMorph. For this video I believe I used the second to latest build to what is currently on the package manager. I used revit 2020 for this tutorial.
@@AussieBIMGuru Hi played a bit with version BiMorph its working fine now. Thanks for the help. You are doing amazing job Bro. Keep on doing the great work. You just got a life time subscriber.
Where can we find the package that you use ?
The bumblebee package can be found in the integrated package manager in Dynamo.
Hello, i was trying to create the same Dynamo script as you, but problems appear at the first step. I have in my test project schedules, but when i use "Schedules.by.type"(Collect.SchedulesByType) it says that i have no schedules. Why is that so?
Hrm strange, which version of Revit are you using? I have tested this in Revit 2020 and the Collect.SchedulesByType node is returning schedule types for me.
@@AussieBIMGuru Same issue here on 2023, just null ...
My guess is you don't have ironpython2.7 package installed. My custom package depends on it in r2023.
@@AussieBIMGuru Lovely thank you that solved the issue for me!
But why does cancelling schedules still output an empty Excel file?
The node still tries to run even without the right data provided I guess?
@@AussieBIMGuruyep , thank u .
Hi. Where can I get the custom package and the more important is, does the packages is free?
Yes pretty much all packages are free, so not that important! You can install them via the package manager in Dynamo. I usually list the names of required packages during my intro segment.
@@AussieBIMGuru yes good to know. 😅. Btw I can't get anything when I search Bimorph nodes in "search fr a package". My Dynamo Core is 2.0.4.12685 and Dynamo Revit is 2.0.4.12685. How can I get the nodes?
@@Matsyaf I can find it when searching. Try scrolling down to it maybe - it needs to be spelt specifically (search tools in dynamo are generally pretty awful).
@@AussieBIMGuru I got it. I download the package manually. Im at the edge of the steps and got problem with the Code Block, Schedule.GetData and Data.ExportExcel.
Code Block : Index was out of range. If non-negative must be less than the size of the list
Schedule.GetData : Schedule.GetData operation failed
Data.ExportExcel : Data.ExportExcel failed.
how to solve this?
@@Matsyaf there musnt be enough outputs coming from the UI. Cross check you have 3 outputs.
Hey Gavin, great video, thanks! Unfortunatelly tried to make it twice, but still does not generate data in my Excel file. Do you know what could be the problem if I followed your script 100%, proved namings and everything else? It actually shows, that script was run succesfully into the excel file, but excel is still empty... Thanks :-)
You're welcome!
I'd say it might relate to an issue a lot of people have where Excel for windows is out of sync with the 32/64 bit version that Dynamo targets. Most people ended up having to do a manual repair of Windows to fix this. See a thread here discussing it: forum.dynamobim.com/t/excel-data-importexcel-operation-failed/62197