Update parameters base on ID use excel data

[pol_ndy]

I have extracted element IDs from Critical Path and created a excel list. And later I am add some information in this excel.

Now I try to add this new information in my Revit models as base in element ID. I tried, but I lost way when I am trying to link this information in Revit through Element ID. And one more think, is this any way we add multiple category in one NODE.

Thanks,

[Manel_Fernandez]

Hi there,

At first glance, you could use SelectByElementId.

And then set the parameter by name.

Cheers

Manel

[pol_ndy]

Hi Manel,
Thanks.

Can you please send me the link where I can download this NODE type. I have Archi-lab node, but i am not able to find this NODE.

PN

[Manel_Fernandez]

I’m not sure, but I think it is in the latest Archi-lab_Grimshaw package.

Do you have the latest?

Cheers

Manel

[Marcel_Rijsmus]

Matching excel values to revit by unique ID

Hi all, First excuse my english. I’m starting dynamo, and i will try to explain as simple as possible. I export schedule from revit to excel, this schedule contain : -Rooms number -Rooms name -Airflow per diffuser -GUID (unique ID) Then in excel schedule are modified, add row to separate rooms, put airflow, reorder row etc… Then i would like to import airflow from excel to revit. But schedule “format” is different and airflow are not put at the good row. Thats why i’m using GUID. I w…

[pol_ndy]

Hi all,

Still problem not able to generate xls information inside revit elements.

Thanks,

[Manel_Fernandez]

Could you explain a little bit more what’s the problem?

Cheers

Manel

[pol_ndy]

Thanks Manel,

I am not able to link the xls data with revit ID. Moreover if we can able to create a script, which filter those wall ID and give us shorted out Wall ID then will use this data to “Element.SetParameterByName”.
Note:- In excel I have Wall And Door Both ID.
please check the attached reference.

PN.

[Marcel_Rijsmus]

use ElementSelector.ById instead of ElementSelector.ByUniqueId as given in this example

Practical Dynamo - Excel Linking 2: Keeping Track of Your Families

[erfajo]

Can this old topic help you?

Excel to Revit using Conduit Run ID as a Key

This post and many other posts I recently have replied made me realize that there is a need for a node that can filter two lists by keys… I have made this node as generic as possible so it may be used as widely as possible. In this case is it Revit and Excel data that is filtered by key. The node “List.FilterListByKey” is now a node in the “DanEDU Dynamo” package. The essential is that I have turned what I mentioned previously into a node Excel to Revit Compare Elements by Parameter Conduit2…

[Manel_Fernandez]

Here you have all the options.

If you get a number from your excel file, then use the second one.

If you get a string from your excel file, then use the third one.

cheers

Manel

[pol_ndy]

Dear all,

Hope you all understand my problem. please check the attached files.

Thanks,

Dynamo

[Manel_Fernandez]

If I have time before, I could look for simplify a little bit it, but at least, now it is working.

Cheers

Manel

[pol_ndy]

Hi,

I got error again.

PN

[Manel_Fernandez]

Could you add a watch node before String from object and Split.String node?

Just guessing, Maybe you have to change “,” for “.”

Manel

[Marcel_Rijsmus]

hi

replace this

with this

so math.round is the only node needed here,
from there go to Select.ByEelementId

[pol_ndy]

Thank you all for responses, this forum is awesome.
PN