Revit Batch Export to ODBC or Excel

[Anonymous]

In the Revit API is it possible to automate the export of Revit model data to external formats using the ODBC export feature.

I have hundreds of models that I would like to export to database formats and I was wondering if I could use the Revit API to automate this process.

Can this be done for just an export to Excel (or other spreadsheet format) without the ODBC driver?

[jeremytammik]

Dear Victor,

Thank you for posting your query here.

You told me you are an ADN member. 

That is normally reflected here as well, so that you case can be automatically escalated if it is not answered in a timely manner.

I do not see that, however. Presumably you are registered with ADN using a different email address or something.

Yes, the Revit API certainly enables you to export data to an external database.

You can use Excel, ODBC, or any other technology you choose, as long as it can be addressed from the .NET framework, since all Revit add-ins are implemented using .NET.

Here is another previous answer to a similar question:

http://forums.autodesk.com/t5/revit-api/need-support-in-exporting-database/td-p/5602871

Several of the Revit SDK samples also demonstrate exporting data to Excel spreadsheets.

Most interesting of all, I recently performed some quite deep research into converting the FireRating SDK sample to drive a cloud database. Here is the Revit add-in and the cloud database implementtion on GitHub:

https://github.com/jeremytammik/FireRatingCloud

https://github.com/jeremytammik/firerating

I hope this helps.

Best regards

Jeremy