Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

DB Link for Revit 2017

9 ANTWORTEN 9
GELÖST
Antworten
Nachricht 1 von 10
Anonymous
4408 Aufrufe, 9 Antworten

DB Link for Revit 2017

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?

9 ANTWORTEN 9
Nachricht 2 von 10
Anonymous
als Antwort auf: Anonymous

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"?

Nachricht 3 von 10
L.Maas
als Antwort auf: Anonymous

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

EESignature

Please mention Revit version, especially when uploading Revit files.

Nachricht 4 von 10
Anonymous
als Antwort auf: L.Maas

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. 

Nachricht 5 von 10
Anonymous
als Antwort auf: L.Maas

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.

Nachricht 6 von 10
Anonymous
als Antwort auf: Anonymous

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:

https://knowledge.autodesk.com/support/revit-products/learn-explore/caas/simplecontent/content/cobie...

 

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.

Nachricht 7 von 10
Anonymous
als Antwort auf: Anonymous

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.

Nachricht 8 von 10
Anonymous
als Antwort auf: Anonymous

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?

 

 

Nachricht 9 von 10
Anonymous
als Antwort auf: Anonymous

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!

 

 

 

Nachricht 10 von 10
Anonymous
als Antwort auf: Anonymous

addi1994elliott,

 

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.

In Foren veröffentlichen  

Autodesk Design & Make Report