Hello all ,
I am creating a floor based Revit family with several types. The client has provided us the information of each type in an Excel Sheet. One of the ways of representing the information is by the use of Shared parameters i.e create shared parameter & assign the required value to that parameter. This is a manual way of including information in a Revit family. Is there any way that I can import an Excel sheet with product information into Revit family and link it with shared parameters?
In other words , is there any method that allows importing Product data into Revit family & link them with shared parameters ?
Please share your thoughts about this.
Thanks in advance,
Pavan
You either need a 3rd party app like Ideate BIMLink or take a look at Dynamo. For help with the latter you would be better asking over on the Dynamo website - there is a lot of stuff there already so worth doing a search. www.dynamobim.org
Getting to at least understand the basics of what Dynamo can do will be a very worthwhile exercise.
Dynamo is definitely a good way to go.
An alternative solution might be to make use of type catalogs (for loadable families). Type catalogs are txt files that are structured like csv (comma separated) files. So with some advanced planning it can be relative simple/quick to export your excel data to such a txt file.
Not as automated as Dynamo but might be easier to start with (until you get familiar with Dynamo).
Louis
Please mention Revit version, especially when uploading Revit files.
@Anonymous wrote:
Hello all ,
I am creating a floor based Revit family with several types. The client has provided us the information of each type in an Excel Sheet. ...
..., is there any method that allows importing Product data into Revit family & link them with shared parameters ?
...
Save the Excel sheet as .txt file. Create headers for each column following the proper syntax (the information is in the Help files). Then, save your txt file with the same name of the family, and put it in the same folder of the family file. Load the family into a project and see if your catalog opens correctly. If not, Revit will tell you where you have errors, in what column or row. It can take a while to get it right, but this is the way to go. I would not recommend Dynamo to do this, because I assume that what you are doing is a family for a client, and what you need to deliver is a family file with types, which is, simply, two files, one .rfa and one .txt.
Is it possible to make use of Macro manager in the Revit family editor to import Excel sheet into Revit family ?
I think Dynamo should be able to modify a family in the family editor. However Dynamo attaches to a single document. So in this case I probably would create a simple family import it in the project and then use dynamo to fill the different parameters.
I have not used Dynamo in the last couple of months because I now tend to create my own add-ins.
Dynamo is still in active development so check the dynamo website/forums to check on the latest changes.
If you are familiar with programming you can use Revit macros to create something for importing.
Louis
Please mention Revit version, especially when uploading Revit files.
Yes, I would create the family with the required shared parameters in it then load it into a project and create the types there then export them. If you've not used Dynamo before though this might be a big first step. In this case you'd be better following @Alfredo_Medina advice as this will probably get you your results quicker.
As a starting point something like this should work... You'll need the Clockwork Package installed within Dynamo to get access to the node that creates your duplicate family types.
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.