topic Re: Exporting list of options from Property Edit in Vault Forum

Exporting list of options from Property Edit

dazzmoore — Wed, 30 May 2018 09:14:34 GMT

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.

Re: Exporting list of options from Property Edit

tschaeferZNBXX — Wed, 30 May 2018 13:36:23 GMT

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.

Re: Exporting list of options from Property Edit

dazzmoore — Wed, 30 May 2018 15:41:47 GMT

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

Re: Exporting list of options from Property Edit

Madhan_T — Fri, 01 Jun 2018 05:41:19 GMT

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

Re: Exporting list of options from Property Edit

dazzmoore — Fri, 01 Jun 2018 07:47:07 GMT

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

Re: Exporting list of options from Property Edit

Madhan_T — Fri, 01 Jun 2018 08:58:17 GMT

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/access-vault-professional-using-powershell-part-1.html

Regards,

Madhan