The incompatibility between 32 bit Microsoft Office database systems and 64 bit Revit program architecture have been causing headaches for a while, but this technical solution may provide the answer you have been looking for: how to get 64 bit database drivers running alongside 32 bit Office installation.
I previously posted about WhiteFeet tools here. Basically, the Revit Parameter Tools allow you to drive Shared Parameters with object information that is normally concealed from tags, such as Volume. There is a lot more to the WhiteFeet package than this, but certainly this is easier than having to go out to RDBLink / Access and back again every time…
Check out screencast embedded below. Thanks Julien!
Revit doesn’t let you tag Wall Volume by default, so Avisotskiy puts RDBLink to good use – he uses Microsoft Access to update a Shared Parameter with the wall Volume data, and then simply uses a tag to grab the manually updated and manually created Volume data.
This is not a ‘live’ link, but it shouldn’t take too long to round trip the project to update the Volume information prior to document transmission or printing.
From his blog: Revit does not allow to directly make a mark in the volume of the object. …
4. Unload in Access, using the Query Designer update the “_Obem”, taking data from the parameter “Volume”.
Here are some summaries of the individual tools (taken from the documentation): Sheet Manager Links to an Excel file or (less commonly) an Access database. Based on this data, it creates or updates sheets in Revit as a bulk editing process. The tool can also be used to export data, renumber sheets, and place views on sheets.
Revit-Database Link A relatively complex and highly developed program that can be the basis of a wide range of workflows. It can connect to either an Access or a SQL Server database and synchronize data in both directions.
Element Tools This collection of smaller tools has been grouped together for convenience, but they serve different kinds of purposes. These include: Placing unplaced areas and rooms. Creating views, adding tags, and exporting images. Managing links.
Family Tools These tools support working with families and working with Excel: Exporting detailed information about families to Excel. Importing parameter values from Excel to control families in support of a computational design process.
Export your Revit file to the appropriate database.
View and edit the database.
Update the project with the edited database.
For example, lets export a Revit project to an Access database:
Setup the DSN. Go into Control Panel – Administrative Tools – Data Sources
Click the System DSN tab.
Select ‘Microsoft Access Driver (*.mdb) and Finish
Put a name in the Data Source Name (revit1 for instance). Put a description.
Under the Database: section, click ‘Create:’
Put the mdb in an appropriate location (C:REVIT-DBrevit1.mdb for instance)
Click OK until you are out of the ODBC Data Source Adminstrator.
Back in Revit, on the Add-Ins tab:
Click External Tools – RDB Link
Click ‘Export into ODBC database…’
Click the appropriate Data Source tab, and locate the Data Source Name you created, which is set up to connect to an existing Access or SQL Server database. If you selected an Access database DSN, a Login screen asks for a name and password. Leave it blank if you have not specified a user name and password for your database. A progress meter appears while outputting the Revit project data to your database. (this point 13 from Labs)
Open the database in Microsoft Access and have a play. Modify a wall height or something and save your changes.
Back in the project, use the RDB Link tool to import the data from the same database you exported to.
Have a look at the change in your model!
Note – if you are running Windows Vista x64, ensure that you run the right version of the Data Sources tool. See this site for the difference. I had success using SQL on Vista x64, but I couldn’t get the RDB Link tool to find my Access source.I used SQL Manager Lite for SQL Server to modify the SQL source on our server. It seemed to be quite good.Feel free to comment on this post and let me know how you go with the RDB Link tool.Below from the Labs site on how to setup the DSN:
To create an ODBC connection (DSN, Data Source Name): 1. Launch the Windows Data Sources (ODBC) screen from the Start menu>Programs>Administrative Tools section. 2. In the ODBC Data Source Administrator, select either User DSN or System DSN to create a new data source name for your database to use with RDB Link. 3. Click the Add button to display the Create New Data Source screen, and select one of the following:
Microsoft Access Driver (*.mdb) if you want to work with a Microsoft® Access database
Specify the Data Source Name of your choosing.
Click the Select button to select an existing Access database or the Create button to create a new one.
SQL Server or SQL Native Client if you want to work with Microsoft® SQL Server™ 2008 (either a full installation or the Express version)
Fill out the information appropriate to your version of SQL Server.
Ooh La La! Does Revit really want you to see what goes on under the hood? Well, if it can help you understand Revit better, then I would suggest that it does (because it will help you know how to ‘treat Revit right’). So, how do you do it?
There are two main ways:
Using the RvtMgdDbg API add-on This is the most comprehensive method, in that it allows you to ‘Snoop’ virtually all parts of the Revit database.
Using the RDBLink Tool from Autodesk Labs This method actually allows you to modify and then update Revit model element properties.
Both of these methods expose the Revit database, which allows you see how things really go together. The Revit database is really what makes everything else possible: from environmental analysis to the basic parametric nature of elements. It’s exciting stuff!I will do individual posts on how to setup and use both these methods in the near future.