Is it true that the "RevitDBLink" Add-in does not work with Revit 2017?
I have office 64-bit now installed. Is it not working both the office export and export to mySQL?
Gelöst! Gehe zur Lösung
So, I've left the DB Link running overnight (since some previous posts indicated that the export took some time) but nothing happened. I have had to manually close the program.
I guess another question that would be helpful for a new Revit user like me to know is, If an Add-in is broken, what is the procedure to have it de-listed from the Add-in "store"?
I never use it but tried an export of a small project to an access database and that seems to work fine. A database is created and the export runs.
So it appears that Revit DB Link (2017) is working. So it might be something in your setup that creates the problems. You might do some troubleshooting to find if you can resolve it. Some things you can try:
-Look for and install updates (Revit and Windows)
-Try an export of a(nother) small project and see if that works.
-If export fails, break it of and look at the latest journal file (%LOCALAPPDATA%\Autodesk\Revit\<Product name and release>\Journals) and see if mentions issues/errors.
-Remove/deinstall other add-ins which might conflict with Revit DB Link.
-Reinstall Revit
-Create a a support ticket in your subscription account and see if Autodesk personnel can help you.
Louis
Please mention Revit version, especially when uploading Revit files.
Nope, still not working. Given how things usually go on tech support calls. I will get bounced between the Revit Tech Support and Add-In Tech support to resolve the problem. Each will say talk to the other. It would be great if someone who actually worked on the Add-In would contact me to resolve this. A general comment of "well you can always reinstall Revit" is not all that helpful, I'm afraid. I think that this will require a minimum of one phone call, more likely several to resolve.
I have the same problem. I've tried exporting with RevitDBLink 2017 on MS Access, MySQL ans PostgreSQL. It turns out, none of them work. So yes, I think it's safe to safe this plugin does not work. Although, you can still export via the Revit menu when you do Export > ODBC.
So, at least there is the beginning of an answer. the DBLink Add in does NOT work. Thank you Sir for the confirmation! Now to test the new suggested approach
1) I opened the publically available Revit test model found here:
2) Then Revit > Export ODBC, selected a blank 64-bit MSAccess database i previously created.
3) 20 minutes later status of Revit = "Not Responding"
So the result = Fail. Is there another test model I can try, in case the one provided for the purpose of testing is somehow broken.
Yes, it has happened to me as well.
I believe MS ACCESS is not a proper tool for Revit as it lacks power compared to some other relationnal database systems such as PostgreSQL.
I've exported with PostgreSQL without a problem.
I've attached a little tutorial I made two weeks back for the company I work for. I hope you'll find it usefull. It's in french, but with images all the way through.
addi1994elliott,
Thanks for the suggestion about PostgresQL. This worked, but not without 3 hours of download, install, investigation, trial, and error. Like most things in database/server land. For some reason the password on the default super user account called 'posgres' kept not matching when i tried to connect through the ODBC connector and even when trying to run a query in the postgressAdmin panel itself!
The answer was to change the C:\Program File\PostgreSQL\9.6\data\pg-hba.conf file using Notepad++. The default lines below (#80 and #82) had to be changed from MD5 to "trust". Just a note (i would put in all caps but that would be rude) --- make a backup of this file before you start!
host all all 127.0.0.1/32 MD5 >> becomes >> host all all 127.0.0.1/32 trust
host all all ::1/128 MD5 >> becomes >> host all all ::1/128 trust
The detailed answer on this can be found here http://stackoverflow.com/questions/2942485/psql-fatal-ident-authentication-failed-for-user-postgres
OMG, was this fun or what!
Now that I have you do you have some examples showing how once i edit in Postgres i can selectively import that data back into the native revit model?
Hi bill.east,
I find it rather odd it took you 3h hours to set it up. With a i3 2.1 GHz processor and 8BG of ram it didn't take me more than one hour to set up. Did you follow the links I've provided in the word document (direct links to download postgreSQL and the latest ODBC driver)?
Even if you didn't it doesn't matter if you managed to get it set up.
My first guess for your password error would be that you forgot to type it in during the PSQL installation or you used the same password as the username (user: postgres/ pwd: postgres). It's really important to have a password on the superuser for security issues, and I suggest creating a new user for your use. You can create one easily with the pgAdmin III software.
What interests you is importing data back into Revit. Unfortunatly I've still not found anything regarding this. My temporary solution is using a Revit plugin called BIM Link from Ideate (trial version).
You can import data from an Excel sheet to Revit which will update the model. It's quite a lot of work. I've linked and Excel file to the database (even that is troublesome) to update the data in Excel automatically, then I modify the data and import it to Revit with BIM Link.
If ever I find a way to ease the process, I'll keep you posted!
Your instructions were great, but i didn't translate the French to English, just tried to follow the figures, so had to go back and reinstall the driver from the StackBuilder. The problem with the password wasn't the password it was the default security setting on how passwords are passed to the server. the default was MD5 not trust.
Also just today I am getting a new error on the Revit Connection that reads "Connection Successful, MSDTC Error: XARMcreate error code=8004d026:please enable XA transactions in MSDTC security configuration"
Will the joy ever end?!
Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.