List of translated standard properties

[ClKöster]

My company works with German and English Vault versions - since I am to do some synchronization between an English and a German system, I wonder whether a translation list of the standard properties and also other terms in the software is available - most of them are fairly easy to match but some are tricky, therefore such a list would provide an immense relief.

Thank you,

Claudia Köster

[Richard.Rankin · Accepted solution]

Hi Claudia,

I dont have the list to hand, I dont think anyone in Autodesk actually has. But it should not be difficult to get. 

You would just need an English and German Vault Server environment with SQL Server Management studio on both systems. (Currently I don't have a German language environment handy)

Then you can run the following SELECT statement against the Vault Database

SELECT TOP (1000) [PropertyDefID]
,[FriendlyName]
,[SystemName]
,[DataType]
,[Active]
,[BasicSearch]
,[IsSystem]
,[LastCfgUpdate]
,[InitialValue]
FROM [TEST].[dbo].[PropertyDef]

It will then give you a list of all the properties thusly.....

You can then repeat it with the German environment and combine them in Excel to give you your translation list.

[ClKöster]

Hi Richard,

That worked great! I was able to derive a very neat Excel Sheet, to which I could add even more languages, should need arise.

Thank you very much.

[ClKöster]

Hi Richard,

That worked great, thank you very much!

After using your solution I actually found a second way to do it via the Vault Client Menu > Tools > Administration > Vault Settings > Behaviours > Properties

There you can add the column "System Name" and then copy the list and build the Excel Sheet from there.

Just for people who would have qualms about touching SQL.

Best,

Claudia