Change material of wall with excel simultaneously

python
excel
revit
dynamo
#3

thanks. exactly i dont know how can i index layer of material that exported in excel. also there is an error when i pload gragh file that it does not let me to upload that.

0 Likes

#4

Pink nodes mean you’re missing a package. I believe you need clockwork installed.

0 Likes

#5

i have installed clockwork package but i don’t know what node must create to connect layerIndex in Familytype.setcompoundlayermaterial node.

0 Likes

#6

Please send a link to your dyn.

0 Likes

#7

Many many thanks. Link

0 Likes

#8

@mojtaba_rezvani72,
As you can see form the image, this is how the nodes work you are asking for. I had to redo a simple part of you graph since I lost the overview what the graph was all about.

Change Material.dyn (21.8 KB)

I had to add a “Waitfor” function so you could see the wall materials before changing and after changing… the two watch nodes. Glass replaces Batt Insulation at layer index 1 in that wall compound.

1 Like

#9

thanks for your response but i want when I change material in excel it changes in revit automatically. for example when i change Glass instead of Batt Insulation in excel it apply in revit and Changed.
I run your graph but it doesn’t work

0 Likes

#10

Then collect the indices from the material output and combine that with the types, so you know which layers you want to change.
Finally use the dynamo player to autoupdate revit projects.

0 Likes

#11

could you draw this graph or which node that i use? because i couldn’t understand it clearly.

0 Likes

#12

Can you show what you have attempted? The purpose of the forums is to help you learn and it’s hard to do that without knowing where you’re getting stuck.

1 Like

#13

Dear JacobSmall
in the following image i have shown what i’m looking for


if you help me i would thank you.

0 Likes

#14

Hi @mojtaba_rezvani72 I think you should really read this post. And read it thoroughly:

https://forum.dynamobim.com/t/how-to-get-help-on-the-dynamo-forums/4677

Especially Point 7 is key.

1 Like

#15

I know, but I really got stuck in this case.

0 Likes

#16

But it seems you have not even tried yet if the sketch is all you have

1 Like

#17

@mojtaba_rezvani72 - the graph which @erfajo built up above should do this. Rebuild it and let us know where you get stuck.

0 Likes

#18

as you see in the following image i try it but this gragh doesn’t work and some list is empty or null.

0 Likes

#19

Can you enable previews of the codeblock?

0 Likes

#20

Try running this in 1.3.2 instead. May be that the clockwork node in question needs an update.

1 Like

#21

I think it is a question about materials, are the material “Glass” present in your document?

Next, you might experience some strange behavior with the Clockwork node. If number of elements don’t fit with the number of materials you want to change. Therefore, I recoded that node for internal usage years ago, meaning I have a comparative node for setting compound layers which I have kept internal. However, given this issue have I revealed the node in my latest update of the Orchid package.

changeMaterial.dyn (16.7 KB)

All my tests a done in both dynamo 1.3.3 and 2.0.1 with this graph… there is no version problem with the Clockwork nodes.

0 Likes

Set wall compound layers from a list
Set Floor Material (No Parameter found by that Name)
#23

as you see in the following images, I have exported materials of Wall Category in Excel and then change material in excel then imported by Data.ImportExcel node.
the question are: 1. According to this graph, only the material of a wall changes, how can we change the material of other walls?
2. According to this graph, we need to determine the LayerIndex (in FamilyType.SetCompoundLayerMaterial node) of wall’s matterial by Code Block node, there is a way that the LayerIndex can be automatically read according to the cell that changes in Excel.



0 Likes