Vault General

Reply
Active Contributor
nickhowe
Posts: 36
Registered: ‎02-28-2012
Message 1 of 5 (236 Views)
Accepted Solution

Purging lonely files out of the database

236 Views, 4 Replies
02-27-2013 06:54 AM

I would like to streamline our database by deleting out all of the independant files left after product development. Files that were created on a previous rev, checked in and are no longer needed but still exist floating around on the server never to be used again.

Is there a way for Vault to identify & collect items which have no dependants or relations?

 

Cheers

 

Nick

Valued Mentor
BLHDrafting
Posts: 350
Registered: ‎10-12-2012
Message 2 of 5 (217 Views)

Re: Purging lonely files out of the database

02-27-2013 03:01 PM in reply to: nickhowe

I have 2 answeres depending on what Vault flavour you have.

 

If you have anything above Vault Basic then Doug Redmonds blog topic here will do the trick. It's run on a folder and finds the orphans. I use it per job folder but I don't see whay it couldn't be run on the Vault root folder. Might take a while though if your database is big :-)

 

If you have Vault Basic then it's a bit more involved. Let me know if you have Basic and I'll add another post.

Brendan Henderson

Web www.blh.com.au
Twitter @BLHDrafting

Windows 7 x64 -64 GB Ram, Intel Xeon E5-1620 @ 3.6 GHz
ATI FirePro V7800 2 GB, 180 GB SSD & 1 TB HDD, Inv R2013 PDS Premium SP2 Update 3 (Build 200), Vault 2013 Workgroup Update 2 (Build 17.2.9.0)
Active Contributor
nickhowe
Posts: 36
Registered: ‎02-28-2012
Message 3 of 5 (208 Views)

Re: Purging lonely files out of the database

02-27-2013 11:59 PM in reply to: BLHDrafting

Hi Brendan, Thanks for the speedy reply!

 

The cheapskates only have basic Vault, though sometime in the future I'm told we'll have collaboration. Please let me know of the other way.

 

Regards

 

Nick

 

 

Valued Mentor
BLHDrafting
Posts: 350
Registered: ‎10-12-2012
Message 4 of 5 (198 Views)

Re: Purging lonely files out of the database

02-28-2013 12:52 PM in reply to: nickhowe

Nick, upgrading to anything other than Basic is $$$. But very worthwhile.

 

I actually have 2 ideas. 1 being the way I did it (long winded) and the other a bit more visual. Both are per folder only I think.

 

Suggestion 1 (this is what I originally did) :-

Make a Vault only property (so it doesn't have to populate the models/drawings), something like USED?. Then find the top loevel assy and look at the Uses tab. Select all items in the Uses and do a CTRL+E (edit properties). Add a value like Y in the Used? column for each of the items. Finisht he edit. Then do a folder search for items that the property USED? does not contain Y (or whatever value you used). Delete the results, but not the IDW's (and any other file/type that you know is to be kept). These don't get used anywhere so they don't gey the Y value in property USED?.

 

Suggestion 2 (came at 2:30 this morning!) :-

Clear out your local WS. Then do a GET from Vault and include Dependents and related Documentation. Then using the Vault Status icons you can see in Vault which files are local and which are not. Delete the ones that are not local.

 

Both methods are a bit time consuming. Suggestion 1 is a bit more automated. If you upgrade to Workgroup there is a nice add-in that does this also.

 

Last suggestion - FULLY TEST ON SMALL DATASET BEFORE ROLLING OUT SITE WIDE!

Brendan Henderson

Web www.blh.com.au
Twitter @BLHDrafting

Windows 7 x64 -64 GB Ram, Intel Xeon E5-1620 @ 3.6 GHz
ATI FirePro V7800 2 GB, 180 GB SSD & 1 TB HDD, Inv R2013 PDS Premium SP2 Update 3 (Build 200), Vault 2013 Workgroup Update 2 (Build 17.2.9.0)
Active Contributor
nickhowe
Posts: 36
Registered: ‎02-28-2012
Message 5 of 5 (148 Views)

Re: Purging lonely files out of the database

03-07-2013 12:53 AM in reply to: BLHDrafting

Brendan

 

Success! The early morning lightbulb was the solution!

 

Regards

 

Nick

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
New button for Platinum & Gold Subscription customers
Gold & Platinum Subscription customers can alert Autodesk if they require assistance with their forum post

Manufacturing Community
The Manufacturing Community provides additional access to tips, tutorials, blogs and networking with peers.

Need installation help?

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

Ask the Community