I have checked the earlier discussions on this subject but I guess my requirement is slightly different.
FYI, I am using Dynamo 1.2 and Revit 2016.
- Read Excel file for a number of values including Parameter Type, Parameter Group and Category
- Split Excel column-wise as lists (I will manage the Excel to match the length of lists to be the same). In the future, I intend to even create a drop-down for lesser possibility of error.
- Use this data to create Shared Parameters and add them to the Project.
The reason I wish to manage it this way is because I see a lot of Shared Parameters that would be required to be added at a later date (the list is not finite now but I intend the script to be able to scale up).
What doesn’t work?
All of this works except the idea of scaling up! Meaning the Parameter Type, and Categories have be selected from the node dropdown and used (as shown in the Pink Groups) for the parameters to be created and added (even though it shows a Null in the output, the script does its job). The problem with this is that the script has to be touched every time to define these two inputs for adding new shared parameters, which defeats my purpose of this script.
Also tried the Add Sharer Parameter node from Grimshaw package - also couldn’t make it to get what I wish!!
Attached are the files for your review and suggestions.
RCS-Add & Set Values for SP_Excel.dyn (28.3 KB)
SP_Data.xlsx (9.5 KB)
Can anyone help me out wherever I have misunderstood &/or done something wrong?
Also, any ideas to make this more efficient (even by reducing one node) are most welcome.
Did not know if I was not passing String values as a list-Hence used String from Object. If something else is the issue, these nodes are not required…
Reattached the image - Thanks to Ritesh Once again
Apologies for the long post but wanted it to be clear