topic Re: Datatools CADWorx Xdata Values with SQL Query in Navisworks Forum

Datatools CADWorx Xdata Values with SQL Query

Anonymous — Sat, 09 Feb 2019 16:37:09 GMT

Hello,

I am trying to find a way to have Navisworks lookup a CADWorx Xdata value from an object and find the same value in the sql db in order to pull additional data. I have managed to currently link a CADWorx Property to sql, but that is only because CADWorx has a Tab that is automatically visible in Navisworks with the basic properties, but the property I need is not shown in the tab. It is limited to only a few properties. See image. So I am trying to find a connection string that will allow XDATA values? I have also attached an image with one of the xdata values I would like to retrieve from Navisworks. Any ideas or is this even possible?

Thanks,

Jgarza

Re: Datatools CADWorx Xdata Values with SQL Query

dgorsman — Mon, 11 Feb 2019 19:05:56 GMT

There's no way to read arbitrary XDATA in Navisworks. Normally for this you would be using the DBCode property. Otherwise, consider using a custom property, possibly filled from the SQL database inside CADWorx. You might even fill it using a live database.

Re: Datatools CADWorx Xdata Values with SQL Query

Anonymous — Mon, 11 Feb 2019 20:05:21 GMT

@dgorsman,

What do you mean consider using custom property , possibly filled from a sql database inside CADWorx?

I thought CADWorx used Xdata from within the drawings and also external db's. So how would it be possible to fill in a custom property automatically with data?

Thanks, but I might also be on to a workaround. I am now trying to determine to what extents does the sql connection string uses sql functions. Here is a sample of the code I am trying to make work in order to get what I need accomplished but it looks like I am missing a small piece now. Maybe someone can shed some light.

What I am trying to do is use the handle id,(which starts over for every dwg) and use the drawing source name which for me makes it unique at the moment, but I also have to introduce the fact that xref's are used and now I have to stripe out the file path to just include the file name, just like the source file property. But I am having issues determining how the data tools connection strings uses the sql functions or select statements. I know this sql statement works up to using the Xref category, so this is where I am stuck now, because I know this sql works on my sql server.

SELECT * FROM [CADWorxTest] WHERE "000_Handle" = %prop("Entity Handle", "Value") and("Drawing" = %prop("Item", "Source File") or "Drawing" = %prop("Xref", ltrim(rtrim(REVERSE(substring(reverse("Name"),0,charindex('\',reverse("Name"),0))))));

Re: Datatools CADWorx Xdata Values with SQL Query

dgorsman — Tue, 12 Feb 2019 16:52:35 GMT

You're on the right track for inside Navisworks, using a dual-key handle/filename system.

What I was referring to was using some custom programming inside Autocad, to populate a CADWorx custom property with a unique lookup key that's easier to work with. If you wanted a more database-centric solution you could backfill custom properties in the live database (SQL or Access) using SQL statements that call from your SQL database.

Re: Datatools CADWorx Xdata Values with SQL Query

Anonymous — Sat, 16 Feb 2019 16:10:19 GMT

Thanks,

But I am still trying to find out if we are able to use sql functions on Navisworks properties. It doesn't seem like it wants to accept them. I even tried some very simple ones. If not then I am going to have to do all the processing in the db and queries.

Jgarza

Re: Datatools CADWorx Xdata Values with SQL Query

Anonymous — Sat, 16 Feb 2019 17:06:42 GMT

I am also noticing that you are not allowed to use Categories and Properties that are not visible on tabs. I tried to perform a simple sql string that includes the following and it will not connect. Like I said at the beginning, either we are not allowed to use none display properties or it doesn't like paths. I am trying to get the last piece of the pie, so I can accomplish what I need. I need to connect to the "Xref" and "Name" due to the fact that drawings are normally xref into other drawings. So this piece will make a unique id. is it possible to use the listed Category and Property?

Any help or solution is greatly appreciated. Below is the simple sql.

SELECT * FROM [CADWorx] WHERE "Dwg_Path" = %prop("Xref", "Name");

They both contain the exact same path...

C:\Test\123.dwg

So what are the limitations. What can we use for a sql statements as far as categories and properties and are sql functions allowed against properties values?

Re: Datatools CADWorx Xdata Values with SQL Query

gennadyKhkh — Fri, 15 Sep 2023 23:55:13 GMT

Hello,

i'm wonder if you got any resutls from your investigations to use outside SQL DB. Do you have working sample?

Another idea could be to use OE directly with API.

So far xdata reader is not available in Navisworks 2023. I'm hopping that Navisworks COM portion can expose some interface with OE. Having source code available for OE i can post xdata via such interface easily.

With not much detailed docs this forum is good place to discuss different scenarios.

Thank you,

Gennady