Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

Import an Excel Sheet into a Revit family

7 ANTWORTEN 7
Antworten
Nachricht 1 von 8
Anonymous
2972 Aufrufe, 7 Antworten

Import an Excel Sheet into a Revit family

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   

7 ANTWORTEN 7
Nachricht 2 von 8
Keith_Wilkinson
als Antwort auf: Anonymous

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.



"Give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime."
Maimonides
Nachricht 3 von 8
L.Maas
als Antwort auf: Anonymous

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

EESignature

Please mention Revit version, especially when uploading Revit files.

Nachricht 4 von 8
Alfredo_Medina
als Antwort auf: Anonymous


@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.


Alfredo Medina _________________________________________________________________ ______
Licensed Architect (Florida) | Freelance Instructor | Profile on Linkedin
Nachricht 5 von 8
Anonymous
als Antwort auf: L.Maas

Does Dynamo work in Family editor mode ?

Nachricht 6 von 8
Anonymous
als Antwort auf: Alfredo_Medina

Is it possible to make use of Macro manager in the Revit family editor to import Excel sheet into Revit family ?

Nachricht 7 von 8
L.Maas
als Antwort auf: Anonymous

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

EESignature

Please mention Revit version, especially when uploading Revit files.

Nachricht 8 von 8
Keith_Wilkinson
als Antwort auf: L.Maas

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.

 

Capture.png



"Give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime."
Maimonides

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report