Exporting list of options from Property Edit

Exporting list of options from Property Edit

dazzmoore
Explorer Explorer
1,313 Views
5 Replies
Message 1 of 6

Exporting list of options from Property Edit

dazzmoore
Explorer
Explorer

Hello All,

I am wondering if there is any easy way of exporting the contents of the predefined options from the 'Property Edit' dialogue box of the files (not items)? These predefined options were inputted globally before my time in this company. There are many choices available & would take a long time to manually collect them. This is how we obviously filter each category and locate required files.

The reason I need this is because I must give the various disciplines the options/choices which I must assign each of their files.

0 Likes
1,314 Views
5 Replies
Replies (5)
Message 2 of 6

tschaeferZNBXX
Advisor
Advisor

The easiest way I have found is to do an advanced search which can then be exported to excel.

Once you have set up your parameters for the advanced search you can then click File>Export.

 

This does not give you a list though but will allow you to manage some of the options.  You can modify the UPD for each of these to have a list of values and enforce the use of this list only.  This will cause a re-index of the Vault which can slow down all users if the Vault is large.

Capture.PNG

Thomas "Matt" Schaefer
Engineering Tooling and Vault Manager for Material Handling Systems MHS


*AU Speaker 2018*
* AU Speaker 2017 *
==========================================================
Please use the "Accept as Solution" and "Give Kudos" functions as appropriate to further enhance the value of these forums.
0 Likes
Message 3 of 6

dazzmoore
Explorer
Explorer

Hello Matt.

Thanks for quick response. I am not looking to export the contents from the 'Project Explorer'.

I am looking to extract the list of preinstalled options available from my companies Vault system within the 'Edit Properties' dialogue box. This 'Edit Property' Dialogue box is the filter system we use during the 'ECO' process which gives each file its unique filter identity.

A number of the columns have manual inputs from the user (using the keyboard) & some have preinstalled options that require selection from a drop-down menu. (See attached screen shot).

Sorry for the confusion.

Darren

 

0 Likes
Message 4 of 6

Madhan_T
Community Manager
Community Manager

Hi,

 

Here is a sample powershell script that helps to extract the values of "List Values" from the property definitions.

 

#******************* 

Add-Type -Path "C:\Program Files\Autodesk\Vault Professional 2018\Explorer\Autodesk.Connectivity.WebServices.dll"
Add-Type -Path "C:\Program Files\Autodesk\Vault Professional 2018\Explorer\Autodesk.DataManagement.Client.Framework.Vault.Forms.dll"
$global:g_login=[Autodesk.DataManagement.Client.Framework.Vault.Forms.Library]::Login($null)

$webSvc = $g_login.WebServiceManager

$propDefs = $webSvc.PropertyService.GetPropertyDefinitionInfosByEntityClassId('FILE', $null);
$names= @()
$namesa= @()
$propDefs | ForEach-Object {
if ($_.ListValArray.Length -gt 0 -And $_.PropDef.IsSys -eq 0){
$names += $_.ListValArray
$namesa += $_.PropDef.DispName


}

}
$namesa| Out-GridView 
$names | Out-GridView

#*******************

 

Hope that helps.

 

Regards,

Madhan

 




Madhanagopal Thiruvenkatachalam
Principal Engineer
Engineering Escalation Team
Autodesk, Inc.

0 Likes
Message 5 of 6

dazzmoore
Explorer
Explorer

Hello Madhan,

Thank you so much for your reply but I have never ran a 'PowerShell script' for Vault before. Can you please walk me through it?

Also I am using Vault Professional 2017 and I see your script references '2018'? Is it as simple as replacing '2018' with '2017'?

Thanks in advance

0 Likes
Message 6 of 6

Madhan_T
Community Manager
Community Manager

Hi,

 

You can review the videos in the following link to get to know more about PowerShell.

 

https://knowledge.autodesk.com/support/vault-products/learn-explore/caas/simplecontent/content/acces...

 

Regards,

Madhan

 




Madhanagopal Thiruvenkatachalam
Principal Engineer
Engineering Escalation Team
Autodesk, Inc.

0 Likes