Hello, I am hoping someone can help me with something. I am attempting to create a couple of Dynamo scripts. One to export sheet set attributes to Excel and another to import the spreadsheet to update the properties in the SSM.
I have installed the “AMR Sheet Set” package as I don’t believe that out of the box Dynamo has added these nodes yet. I am stuck very early on in the first script, as seen here:
I can’t tell why my Sheets list is empty, see the last node. Here is a screenshot of my SSM:
Thanks in advance.
I figured out my problem. I am using the new Web-based Sheet Set Manager. I had to set the SSMDETECTMODE variable to 0 to revert back to classic SSM. It appears that Adam’s nodes may not play well with the Web SSM.
1 Like
The SSM for Web works on the dst file directly from the cloud, so you’ll need to make sure that the dst is synced locally in order to access it from Dynamo. This is easily done, as you discovered, by turning off the SSMDETECTMODE. Once the legacy sheet set manager opens the file, it will have synced the copy to your local for you to access with your script or any other tool.
Thanks for sharing! The AMR sheet set nodes were my first foray into Dynamo coding because sheet set manager has always been a thorn in my side when trying to update properties. Kudos to @AdammReilly for developing the tools to address those issues.
@Michael.McKeon , in your script was it able to pull the sheet properties for sheets within the subsets? When I was working on my My Dynamo code. I couldn’t get any import or export to work when sheets were contained within subsets.
I’m curious if you figured that out? I can share my Dynamo code in a couple of days when I’m back from the field.
@TCD-Flywater I was able to extract properties from a subset but I am very inexperienced with Dynamo. I had to explicitly define the subset name. I am hoping I can create a script that will dynamically extract the sheets within each subset.
