topic Re: Vault Data Standard 2015 R2 - set file category automatically in Vault Customization Forum

Vault Data Standard 2015 R2 - set file category automatically

Rproehl — Tue, 14 Jul 2015 07:45:24 GMT

Hi,

I'd like to set the category of an Excel file automatically related to the folder where it will be created (or it is stored).

e.g.

I have

-folder1

-folder2

-folder3

for each folder I have a catogory (e.g. categoryf1, categoryf2, categoryf3)

creating a new file in folder1 should set the category to categoryf1.

using

if ($_fl1 -eq "folder1")

{

$Prop[_Category].Value = "categoryf1"

}

within the function InitializeWindow

will stop the functionality (no UI window pops up).

in the xaml-file I've added

I've removed the default ComboBox (which is part of the file.xaml) for selecting the category.

I hope it is just a little thing to modify - many thanks for your help

Rainer

wangdu — Tue, 14 Jul 2015 08:27:09 GMT

Hi Rainer,

In the script you have posted, double quotes in the indexer is missing.

$Prop["_Category"].Value = "categoryf1"

Does that help you?

HTH

Wangdu

Rproehl — Tue, 14 Jul 2015 08:39:49 GMT

Thank u very much - after sitting days in front of these editor I'm getting blind.

It works now