Adding new properties to an object with an SQL String through Data Tools
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report
Hi, I made a model in sketchup including a large number of pipes. Each pipe was drawn in a different layer in sketchup, so when the model was imported in Navisworks, all the layers where imported as well.
In the properties of any element I can visualize only the following:
In the Element tab:
*Name
*Type
*Icon
*Hidden
*Required
*Material
*Origin file
In the TimeLiner tab:
Nothing
In the Layer tab:
*Name
*Layer ID (which, as my Navisworks is in spanish, appear as "ID de capa")
As you can see, I have no unique element ID for each element. My goal is to be able to add a property to the elements, according to the layer of the element. Precisely, I want to add an Index indicating the state of conservation of each pipe. So I have an Excel spreadsheet with some of the properties listed above for each element, and I added a column to that excel sheet with the Index that I want to visualize in the properties in Navisworks.
The excel sheet is attached.
The SQL string used is the following:
SELECT * from [Exportado desde navis$] where "ID de capa"=%prop("Capa", "ID de capa");
As I understand from the following video used as tutorial (min 7:34) : https://www.youtube.com/watch?v=f-Xny64TTzI
* [Exportado desde navis$] indicates the spreadsheet tab name
* where "ID de capa" specify which column in the spreadsheet is the key that unikely identifies the entry. Here I might have a problem, given that the ID de capa or Layer ID (in english) is a value that is shared between several elements, given that each pipe is asigned a unique layer, but each pipe is conformed by several elements (of course all of these elements contained in the same layer). I would like that any element containing a specific layer ID would be associated with a specific index.
* =%prop("Capa", "ID de capa"); specify, which property (named: "ID de capa" on the "Capa" property tab) in Navisworks to match with the entry in the spreadsheet.
I followed every step in the video used as tutorial, but the new propery named Index does not appear.
Even after restarting the program as suggested in the following thread did not worked: https://forums.autodesk.com/t5/navisworks-general-discussion/navisworks-manage-2012-and-data-link-to...
Any idea?
Thanks in advance.
Gonzalo
