topic Re: Create a Selection Set outside of Navisworks Manager 2014 in Navisworks Forum

Create a Selection Set outside of Navisworks Manager 2014

Brian.Powell — Wed, 18 May 2016 14:04:17 GMT

Here's what I'm wanting to accomplish.

I have a list of data that I want to make a selection set for. It's a long list so it would take awhile to build inside Navisworks and the list changes daily. I want to be able to create some type of file or modify a file outside of Navisworks and import it some how into Navisworks.

I've tried exporting a selection set and then import it into excel to modify it and then re-import it back into Naviswork but I get an error importing it to excel.

Thanks in advance for any help with this!

Re: Create a Selection Set outside of Navisworks Manager 2014

dgorsman — Wed, 18 May 2016 14:39:51 GMT

The selection set exports as XML, not Excel. You would need to modify the XML contents following both XML formatting guidelines and the Navisworks schema.

Could you use a search set rather than a selection set? Set the search criteria then let the program do the heavy lifting of finding matching objectts for you.

Re: Create a Selection Set outside of Navisworks Manager 2014

Brian.Powell — Wed, 18 May 2016 14:55:36 GMT

sorry I meant search set.

Re: Create a Selection Set outside of Navisworks Manager 2014

dgorsman — Wed, 18 May 2016 15:44:00 GMT

Exported search sets can be modified provided proper XML formatting and the Navisworks schema is followed. You might do this manually with an XML-capable editor but some software to automate the generation of the XML content would probably be better for consistency (and possibly sanity if you have a large number of sets to construct).

Are you familiar with XML? And the MSXML DOM?

Re: Create a Selection Set outside of Navisworks Manager 2014

Brian.Powell — Tue, 24 May 2016 11:52:05 GMT

No I'm not familiar with XML or the MSXML DOM. This is my first experience with it.

Re: Create a Selection Set outside of Navisworks Manager 2014

dgorsman — Tue, 24 May 2016 15:00:49 GMT

XML shows up in a lot of places, I highly recommend learning at least the basics. You can start here: http://www.w3schools.com/xml/default.asp

Install Visual Studio from Microsoft - while its primarily a programming platform the XML eding tools are also useful.

The MSXML DOM is how you would interact with XML content through VBA in Excel; it automates a lot of what is presented in above tutorial. You can construct and manipulate XML manually (it is just plain text, after all), but for this amount of data I recommend learning to do it the "right way" first.

Re: Create a Selection Set outside of Navisworks Manager 2014

k.jayavijayan — Mon, 06 Jun 2016 10:02:44 GMT

It is already done. Will upload it in 2days. So Wait for it.

Re: Create a Selection Set outside of Navisworks Manager 2014

k.jayavijayan — Mon, 06 Jun 2016 17:53:25 GMT

Hai

I created a program using VBA to create "Search Sets" externally for Autodesk Navisworks. This program is a time saver in creating sets in Navisworks environment.

Note:

The program will run Microsoft Office 201o onward.
Search sets are compatible with 2014, 2015 and 2016 version of Navisworks.
Enable macros when opening the file and also add it to "Trusted Sources" location in your computer.

For Help, Check the below link

https://www.youtube.com/watch?v=XEViT-ZkBrE&feature=youtu.be

Hope it helps you guys very much and let me know if you have any trouble using that program.

Regards

JayavijayanK

https://in.linkedin.com/in/jayavijayan-karthikeyan-2221b7b1

Re: Create a Selection Set outside of Navisworks Manager 2014

Brian.Powell — Mon, 06 Jun 2016 18:44:05 GMT

This looks like exactly what I'm wanting to do. Couple questions

1. The file uploaded is a .rar file. In the video it's a xlsm file. Do I need to rename it?

I also noticed that the files size on the file you open is alot bigger then the one I down loaded.

2. How do I change the settings to allow it to open.

Re: Create a Selection Set outside of Navisworks Manager 2014

k.jayavijayan — Mon, 06 Jun 2016 23:36:34 GMT

It is .xlsm file (Excel Macro). So extratct it and run. The file size will be around 5mb.

Re: Create a Selection Set outside of Navisworks Manager 2014

dgorsman — Tue, 07 Jun 2016 14:37:07 GMT

RAR is a compressed format similar to ZIP, its popular in the software development community. You'll need a RAR extractor to get at the contents unless its set up as self-extracting (which I'd recommend - not everyone can or is willing to do so).

Re: Create a Selection Set outside of Navisworks Manager 2014

Brian.Powell — Tue, 07 Jun 2016 15:24:56 GMT

First off let me say THANK YOU!!!!!!!!!! to K. Jayavijayan. This is going to be a huge time saver!

K. Jayavijayan's file above worked like a charm after I figured out a few things.

1. Downloaded 7Z to extract the rar file. http://www.7-zip.org/

2. Downloaded foxe to create the xml file. http://www.firstobject.com/dn_editor.htm

3. I had to change "nw-exchange-12.0.xsd" to "nw-exchange-11.0.xsd" on the DataOut tab. If not it would say file not found when importing into Navisworks.

4. I had to add the Type and Category I needed under the Lookup tab. Anyone using this file will need to do this. If this is not done you'll get an N/A on the output file on the ones that are missing. On the lookup tab Data Type is the Category field on the DataIn tab. Column B is the Type column on the DataIn tab. You can find the type and category by following the video K. Jayavijayan created. it's the info at the beginning of the video in Navisworks.

Re: Create a Selection Set outside of Navisworks Manager 2014

k.jayavijayan — Tue, 07 Jun 2016 17:22:50 GMT

Hai Brian

Thanks for pointing out the issue.

The xml is fine for Navisworks 2015 and 2016. But for 2014, the header should be changed to navis version.

As you said, If we gonna use that xml in Navisworks 2014, then change this "nw-exchange-12.0.xsd" to "nw-exchange-11.0.xsd".

Jayavijayan K

Re: Create a Selection Set outside of Navisworks Manager 2014

Anonymous — Wed, 05 Oct 2016 07:20:00 GMT

This program looks very Interesting, but time expires, how do we go about unlocking the excel file & enjoying the benefits ?

Thanks

Re: Create a Selection Set outside of Navisworks Manager 2014

Anonymous — Thu, 06 Oct 2016 15:51:34 GMT

This macro looks like exactly what we need!

Thank you!

The You Tube link does not work. Do you take the help video down?

Thanks again!

Best regards,

Donald Newlands

Re: Create a Selection Set outside of Navisworks Manager 2014

k.jayavijayan — Thu, 06 Oct 2016 16:53:27 GMT

Yeah.. I will upload the new excel file and help video soon.
Thanks

Re: Create a Selection Set outside of Navisworks Manager 2014

f.shanahan — Wed, 02 Nov 2016 15:11:09 GMT

Did you ever upload a new excel and help video?

Regards,

Frank

Re: Create a Selection Set outside of Navisworks Manager 2014

ertanyuce — Fri, 14 Jan 2022 12:07:26 GMT

Do you have the updated file?

Re: Create a Selection Set outside of Navisworks Manager 2014

k.jayavijayan — Fri, 14 Jan 2022 12:37:54 GMT

Hai friends

sorry for the late response. The updated file attached.

There will be more no of search sets you will get and it will be another time taking process to import in navis.

So, I have created another script to combine the individual search sets to single file. I will upload with instructions soon.

There is no expiration for the file. Hope it helps. Let me know if any trouble using it.

Thanks!

Re: Create a Selection Set outside of Navisworks Manager 2014

ertanyuce — Fri, 14 Jan 2022 13:43:33 GMT

Thanks for the file. I want to make a selection set for the elements shown in attached file. What do I need to modify in your file. Can you help please?

Regards.