Change material of wall with excel simultaneously

hello
I want to Export wall’s material to excel and then change them in Excel and simultneously import to revit and changed . in the following image the materials export to excel but when the material want to change it does not work. please say some soltion.

@mojtaba_rezvani72
First, please always upload your graph file som those who might be able to help you, don’t need to reinvent the wheel.
Next, if you don’t feed the SetCompoundLayerMaterial node with the layerIndex I supposes it will fail. What the error is in the other node is hard to say without knowing the error. However, it must be the input that doesn’t match what the node expect.

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.

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

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

Please send a link to your dyn.

Many many thanks. Link

@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

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
Change%20material1

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.

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

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

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


if you help me i would thank you.

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

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

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

1 Like

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

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

Can you enable previews of the codeblock?

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

1 Like