Managing Revit Type Catalogues with Excel – 2 of 2

Managing Revit Type Catalogues with Excel – 2 of 2

Start by creating shared parameter for the components as well as parameters for their price.

Manage > Settings > Shared Parameters

1-4 Managing Revit Type Catalogues with Excel – 2 of 2

Group them appropriately.

2-4-300x248 Managing Revit Type Catalogues with Excel – 2 of 2

3-4-300x287 Managing Revit Type Catalogues with Excel – 2 of 2

Include the shared parameters in the families they are meant to occur in (they will apply across all of the types within the family).

Create > Properties > Family Types

4-4 Managing Revit Type Catalogues with Excel – 2 of 2

New Parameter

5-3-300x263 Managing Revit Type Catalogues with Excel – 2 of 2

Select the shared parameters to include as type parameters.

6-3-300x146 Managing Revit Type Catalogues with Excel – 2 of 2

7-3-263x300 Managing Revit Type Catalogues with Excel – 2 of 2

List them under the appropriate Property Headings

8-2-230x300 Managing Revit Type Catalogues with Excel – 2 of 2

Since the family is to be managed though a type catalog, it is not necessary to indicate values for the type parameters in the family itself.

9-2-300x212 Managing Revit Type Catalogues with Excel – 2 of 2

Now export the Family types.

Application Menu > Export > Family Types

10-2-300x298 Managing Revit Type Catalogues with Excel – 2 of 2

This saves as a text file in a comma delimited text file (CSV) which in turn is opened in Microsoft Excel (make sure to choose “All Files” so that the .txt file is visible).

11-2-300x115 Managing Revit Type Catalogues with Excel – 2 of 2

In the Text Import Wizard, choose “Delimited” for the original file type, and click next.

12-2-300x212 Managing Revit Type Catalogues with Excel – 2 of 2

Make sure to add “Comma” as a delimiter and click next.

13-1-300x212 Managing Revit Type Catalogues with Excel – 2 of 2

Choose Text as the Column Data Format (stops Excel from modifying data) and click Finish

14-300x212 Managing Revit Type Catalogues with Excel – 2 of 2

Save it as an excel file. This excel file is what will be used to manage the Type catalogue. Do the same for the Second family.

These Excel files may have their Rows and Columns sorted as the Row Order and column order is not of consequence to Revit when it populates data for families from type catalogues.

15-298x300 Managing Revit Type Catalogues with Excel – 2 of 2

Now write the file out as a MS DOS CSV File and afterwards change the extension from .csv to .txt. Move the text file into the directory containing the family. The next time the family is loaded into a project it will read the values for the parameters from the .txt type catalogue.

Insert > Load from Library > Load Family

16-300x107 Managing Revit Type Catalogues with Excel – 2 of 2

By |2017-10-18T11:00:22+00:00December 19th, 2016|

About the Author:

After concurrently manufacturing for the Radar EW industry and reading incompletely toward Mechanical Engineering at Stellenbosch University, I realigned toward the Architectural. Today I support the AEC professions in Cape Town as an Application Engineer for a Gold Autodesk Reseller in South Africa called Micrographics. I support and facilitate training on the following software platforms: Revit (Architectural, Structural and MEP); Civil3D; AutoCAD; SANSCalc and Lumion.