Vault Customization

Vault Customization

Reply
Valued Contributor
pdauphin
Posts: 87
Registered: ‎03-27-2006
Message 1 of 4 (393 Views)

Export data from the Vault WG DB Table to a custom table.

393 Views, 3 Replies
02-13-2012 08:28 AM

Hello,

 

I'm a long time Vault user but I just got recently in the customization and programming world. I have a few questions I'd like to ask to you all before I move forward with my plan.

 

Here is what I want to do:

 

We are using Vault WG 2012 and we have carfully configured all the aspects of our vault to match how we want our files to be managed. No problem there. The categories, Life Cycles and properties, all works well. But, here is where I need help. I want to export specific data from the SQL Vault Tables and place it in another custom table where I could play around and format the data in a very specific way.

 

The goal is to format the data in a way that another software, ProfitKey, can read and use.

 

So I guees my first question is: Is it possible to export data from a Vault WG Table and place that data in another table? If so, is using the Vault's API and SQL coding the right way to go?

 

Before I start studiying and learning, I want to make sure I'm on the right track. If you have some good starting point on learning all this, please share.

 

Thanks!

Employee
Redmond.D
Posts: 814
Registered: ‎12-12-2006
Message 2 of 4 (382 Views)

Re: Export data from the Vault WG DB Table to a custom table.

02-13-2012 01:26 PM in reply to: pdauphin

Using the Vault API is the correct way to do things.  Trying to read the data directly from the Vault SQL tables is not supported and very difficult to do. 

I'm not sure what data you want to get at, but it should be all accessable through the Vault API.

 

It's up to you how to write that data to a custom table.  However, that table should not be in any of the Vault databases.



Doug Redmond
Software Engineer
Autodesk, Inc.
http://justonesandzeros.typepad.com/

Valued Contributor
pdauphin
Posts: 87
Registered: ‎03-27-2006
Message 3 of 4 (361 Views)

Re: Export data from the Vault WG DB Table to a custom table.

02-21-2012 12:25 PM in reply to: pdauphin

Thank you for the answer.

 

I'm trying to get to the iproperties entered in Inventor and indexed by the Vault. The idea is to pull the values out of the Vault database, place it in a custom table, outside of the vault, and then, have another software read the data that has been properly formated.

 

I would also like to get the BOM infos... for example: part A is used 4 times in assembly ABC, etc... I don't know if this is possible using Vault WG.

 

Thanks again.

 

 

Employee
Redmond.D
Posts: 814
Registered: ‎12-12-2006
Message 4 of 4 (352 Views)

Re: Export data from the Vault WG DB Table to a custom table.

02-24-2012 04:36 AM in reply to: pdauphin

Vault Professional is the only Vault product with BOM support. 

 

In the other products, there is an unsupported way to get BOM information:  you can call GetBOMByFileId.  This way is hard to work with an you only get the immediate children.



Doug Redmond
Software Engineer
Autodesk, Inc.
http://justonesandzeros.typepad.com/

Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Announcements
Do you have 60 seconds to spare? The Autodesk Community Team is revamping our site ranking system and we want your feedback! Please click here to launch the 5 question survey. As always your input is greatly appreciated.