Auditing Families

[designer56644]

I am cleaning up some of my "templates", and going to an office wide standardization (part of the plan for the upgrade)....I am wondering if it is possible to call an audit of families in a template, including enity variables and perameters to screen or esp., print?

E.g., I would like to view all of the window families I have created or placed in a template, including type/size, type marks, duplicated tags, in one convinient place without having to examine individual entities and their properties one by one.

TIA
Bill

[hand471037]

If you export your template via ODBC Export to an Excel spreadsheet or Access Database, you'll be able to view all of this info. This only takes a minute to do.

To do it, simply open your template in Revit and also make a new, but blank, Excel (or whatever spreadsheet you're using) workbook on your desktop. Go to File->Export-> ODBC in Revit. Pick the 'Machine sources' tab on the export window, and then double-click on 'Excel Spreadsheet'. Browse to your blank spreadsheet location, and then click OK. Revit will be busy for a second, and then it will finish. Open your formerly blank Excel workbook, and now you'll see a bazillion tabs at the bottom of the workbook for each major group becomes a 'page' within your Excel Workbook. scroll to the 'Window Types' tab, and you'll see a schedule of all your window types, complete with all the info you want. View the other tabs to see other family info from your project.

This is a great way to view 'meta-data', or schedules about the types of things within your project. It's also handy for manipulating data outside of Revit, for you can do all kinds of things with this data, as well as write tools that reference it externally and/or parse it for other tasks. I've seen some very interesting things come out of this, and now with 6.0 I expect we'll see even more...

Best thing is that you can make changes to your Revit template, re-export to the same workbook, and have those changes reflected.

[designer56644]

Wow,

This is good stuff Jeffrey :)

You are a mega poster...

Thanks,

Bill

(Don't work to late)