Vault General Discussion

Vault General Discussion

Reply
Contributor
TomAllen
Posts: 22
Registered: ‎04-21-2008
Message 1 of 5 (95 Views)

Removing specific characters from the description?

95 Views, 4 Replies
01-24-2013 11:39 AM

Vault Basic 2013 SP1

 

New ERP integration requires removing specific characters from the description field.

 

Can anyone suggest a good method of doing this at the database level or similar?

 

Thanks in advance!

 

Tom

Product Support
r.smith1
Posts: 216
Registered: ‎01-19-2011
Message 2 of 5 (68 Views)

Re: Removing specific characters from the description?

01-25-2013 02:56 PM in reply to: TomAllen

Hi Tom,

Please do not directly modify your database. 

http://crackingthevault.typepad.com/crackingthevault/2009/05/can-you-manually-modify-a-vault-or-libr...



Ron Smith
Front Line Technical Support Specialist - Data Management
Autodesk, Inc.

http://help.autodesk.com/view/VAULT/2014/ENU/
http://crackingthevault.typepad.com/
http://underthehood-autodesk.typepad.com/
Contributor
TomAllen
Posts: 22
Registered: ‎04-21-2008
Message 3 of 5 (62 Views)

Re: Removing specific characters from the description?

01-26-2013 02:15 PM in reply to: r.smith1

Thanks for the response Ron.

 

I had inhibitions about it, the resaon for reaching out.

 

Can you offer any other alternatives to modify a (description) property in this way across a Vault?

 

The idea of opening, modifying and checking back in tens of thousands of files is undesirable.

 

 

 

 

 

Product Support
r.smith1
Posts: 216
Registered: ‎01-19-2011
Message 4 of 5 (47 Views)

Re: Removing specific characters from the description?

01-28-2013 08:44 AM in reply to: TomAllen

Hi Tom,

I know it's not an easily digestible thing to hear, but I would search for the characters in the descriptions, create a saved search of files with this character in the description, and save the search, modify the properties in bulk via edit properties. 

It may be possible to automate this via the API, but you would want to get direction on this in the Customizations page of this Discussion Group forum. 



Ron Smith
Front Line Technical Support Specialist - Data Management
Autodesk, Inc.

http://help.autodesk.com/view/VAULT/2014/ENU/
http://crackingthevault.typepad.com/
http://underthehood-autodesk.typepad.com/
Contributor
TomAllen
Posts: 22
Registered: ‎04-21-2008
Message 5 of 5 (45 Views)

Re: Removing specific characters from the description?

01-28-2013 08:49 AM in reply to: TomAllen

Thanks for offering up an altaernative Ron.

 

I'll look into my options in "customization".

 

Tom

 

 

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 or visit the Installation and Licensing Forum to get help installing your software.