AMR Sheet Set Custom Properties

Civil 3D
1

I’ve got an Excel file of sheet set data that I’ve exported using a Dynamo graph (yay!). Now I’m working on a graph to import said Excel file back into the sheet set, but when I get to the custom properties I’m running into an issue.

I’ve got a dictionary (and a list) of the sheet set properties and their values. Using the SheetSet.CustomProperties node I get a list of all of the custom sheet set and sheet properties (not just sheet set). I can filter those to get just the custom sheet set properties (the in filter below). Now I need to set the values of the custom properties based on what the dictionary (or list) has. My issue is that the number of custom properties and their names won’t always be the same for different projects. So how do I go about updating the properties if the names change?

image
image1920×922 452 KB

The node CustomProperty.EditValue requires a customProperty object, the sheet set, then the value. Since that node doesn’t use a string for the property, I’m not sure how to tie the string names from the Excel import to the customProperty object and set the values as well.

I could use some direction on how to tackle this one. It’s probably something simple I’m missing.

2

image
image1920×719 300 KB

I think I got it worked out, although there’s an issue with the Total Sheets value being a number and the node CustomProperty.EditValue requires a string. I did a String from Object, but it converts the digits to have a large decimal value. I can edit that specific index to truncate it, but I don’t know if in future projects that this index will always be the total sheet count. Is there a way to convert any numbers to a string without all the decimals? Am I going to have to do a another filter based on Object.Type, convert any object with a type of System.Double to string, then do a truncate and add back to the list?

Seems like a like of overhead, but I don’t know of another way.