Add many Property Sets to many objects in Civil 3D

Hi all,
do you think it is possible without python node to add more property sets to more 3D solids based on layer definition and Psets definition in excel? I attached dataset. Video with wrong result is here https://autode.sk/2HITC00

AutoCAD_AddPropertySetByDefinition_01.dyn (72.0 KB) D4C3D_20201028_Pset_01.dwg (1.0 MB)
Psets.xlsx (8.1 KB)

2 Likes

Hi all, now it works only for first list of PSET names and first list of solids. Do you think there is any elegant and simple solution how to iterate through lists in list of solids and PSET names? I added new dataset and pictures.

Psets.xlsx (8.1 KB)
AutoCAD_AddPropertySetByDefinition_03_b.dyn (44.4 KB)
D4C3D_20201028_Pset_02.dwg (1.1 MB)

I know this is not Dynamo for Revit but have a read here http://puntorevit.blogspot.com/2017/05/set-many-parameters-at-once-with-dynamo.html

1 Like

Perfect. I’ve done it. Thank you @Paolo_Emilio_Serra1. I had to use List.OfRepeatedItem twice, for list of solids and than for list of PSET names.

1 Like

I was very interested in this topic, could you share a screenshot or a script of how you did this? Thanks!

Hi Kirk,

here is screenshot. If you find better solution could you please let me know?

(post deleted by author)

Thanks @Drbohlav for this post.
I found it very informative and were able to use it as the basis for my own script that I have attached for anyone that might be interested to pursue it further:

Add property set by layer from excel V1.3.dyn (65.5 KB)

Personally I prefer it if the path for the excel files are set automatically so I have added a portion that sets the path to be the same as the current dwg.

1 Like

Thanks for this @AutoPiet

1 Like