Revit Architecture

Reply
Distinguished Contributor
Posts: 197
Registered: ‎04-20-2005
Message 1 of 6 (645 Views)

DB Link and ODBC Export differences

645 Views, 5 Replies
05-06-2011 01:56 PM

Can someone explain why is there a difference between DB link and ODBC Export. Both exporters are omitting several different tables, and the available fields. For example ODBC will export Mass Element Surfaces but it will not include Categories table and Shared parameters in project information table, while DB Link cannot see Mass Surface types.

In order to see the entire database one needs to export twice, through ODBC and via DB link.

I would say that this is a bit inconvenient.

*Expert Elite*
Posts: 866
Registered: ‎09-28-2009
Message 2 of 6 (642 Views)

Re: DB Link and ODBC Export differences

05-06-2011 02:06 PM in reply to: tomislav.zigo

I'm not sure why there are such differences.

 

But I had a thought........

 

What if you exported to 3D dwfx and imported into Adesk QTO--would you see the Mass surfaces and the parameters?

 

 

Cliff B. Collins
Registered Architect/BIM Manager
Thalden Boyd Emery Architects
St. Louis, MO
Distinguished Contributor
Posts: 197
Registered: ‎04-20-2005
Message 3 of 6 (616 Views)

Re: DB Link and ODBC Export differences

05-08-2011 11:19 AM in reply to: ccollins

That might work, but it does not offer the flexibility of cross-referencing data from multiple sources within the familiar environment like SQL server.

 

Distinguished Contributor
Posts: 197
Registered: ‎04-20-2005
Message 4 of 6 (605 Views)

Re: DB Link and ODBC Export differences

05-09-2011 06:15 AM in reply to: ccollins

DWF doesn't carry mass element associated surface information that is necessary for the rapid take off.

Active Contributor
Posts: 31
Registered: ‎01-08-2009
Message 5 of 6 (587 Views)

Re: DB Link and ODBC Export differences

05-11-2011 06:45 PM in reply to: tomislav.zigo

I'm also not sure how to explain the differences between those two tools.  I can only say, that as a software developer, we too have struggled to make sure all the various parameters are exposed for our tool, and in many cases it's been unearthed only after a specific request has been made.  In other words, it's not all neatly organized in some list, waiting for us to published (though I wish it was).

 

Here's a screenshot of how we expose the parameters related to Masses.  I'd be curious to know if even this would meet your needs?  Fields in grey would be editable (in Excel).

 

Regards,

Glynnis Patterson, Architect

www.ideatebimlink.com | www.ideateexplorer.com

 

 

Distinguished Contributor
Posts: 197
Registered: ‎04-20-2005
Message 6 of 6 (575 Views)

Re: DB Link and ODBC Export differences

05-12-2011 09:34 AM in reply to: GlynnisP

Glynnis,

 

Linking properties is not an issue, whether done through custom API or using SQL and Forms to work with a database. What, concerns me is the inconsistency between two tools that are created for bridging the gap between an object database and relational one.

For my purpose I am getting what I need, but it would be much nicer to do this in a consistent way.

 

Regards,

 

Tomislav

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

Announcements
Are you interested in helping shape the Autodesk Community?
We’re looking at a few different ways to improve the “All Forums” landing page and need your feedback! If interested, please take a few minutes to fill out the following Usability Study. Thank you for your time!

Need installation help?

Start with some of our most frequented solutions to get help installing your software.

Ask the Community


Revit Exchange Apps

Created by the community for the community, Autodesk Exchange Apps for Revit helps you achieve greater speed, accuracy, and automation from concept to manufacturing.

Connect with Revit

Twitter

Facebook

Blogs

Youtube