import Excel data to Revit family parameters

import Excel data to Revit family parameters

ammad.mahmood
Contributor Contributor
4,063 Views
2 Replies
Message 1 of 3

import Excel data to Revit family parameters

ammad.mahmood
Contributor
Contributor

hallo everyone.

 

I am working on a project in which i am modeling pipes and fittings etc through P & id Modeler by Revit. So each element in P&id drawing is associated with some data eg 10 parameters and the settings in the P & id modeler provide only to map the tag between the Plant 3d and Revit. Which means i can only bring the tag into my Revit.

 
 
 
 

 

so, now each element eg pump has its own tag but besides tag there are also 9 parameters that i want to associate with each each pump. And all the pumps are different from each other, in other words all of them are separate families. 

 

i have all the data in excel. Can you please guide me how can i bring other 9 parameters from excel and associate it with each element. I know it can be only be done with dynamo but i don't know how to use it. i am a beginner and i will definitely learn it but now for a project i need this . Can someone please help me with the script? if you have already made one? or if there is any other way of doing it or may be some plugin availabe?

 

 

0 Likes
4,064 Views
2 Replies
Replies (2)
Message 2 of 3

franciscopossetto
Advocate
Advocate

Hey,

 

To get started with Dynamo I recommend you to read this guide:

https://primer.dynamobim.org/

 

What you want to do is a typical workflow on Dynamo, you will find similar solutions on Internet. You can have a look at the Dynamo forum:

https://forum.dynamobim.com/

 

You can see this thread:

https://forum.dynamobim.com/t/using-data-from-excel-to-set-parameter-values-for-all-elements-of-a-ca...

 

And have a look on this nodes:

 

1. To importa data from excel:

https://dictionary.dynamobim.com/#/Office/Excel/Action/ReadFromFile

 

2. To Get Parameter values:

https://dictionary.dynamobim.com/#/Revit/Elements/Element/Action/GetParameterValueByName

 

3. To Set Parameter:

https://dictionary.dynamobim.com/#/Revit/Elements/Element/Action/SetParameterByName

 

4. To filter Elements based on certain conditions:

https://dictionary.dynamobim.com/#/Core/List/Action/FilterByBoolMask

 

I hope it helps,

Kind regards.

 

 

 

 

Github:
https://github.com/franpossetto
0 Likes
Message 3 of 3

ammad.mahmood
Contributor
Contributor

Thankyou so much for the links. I will have a look into it. 

0 Likes