I'm working with MS Office integration between Projectwise and MS Word and need to get the Document Name from Projectwise into my MS Word template. The Exchange between the Attributes from the Environment works flawlessly, but I can't get access to the document name.
In the dialog where I find the System variables, I have $VAULT.FULLNAME$ and $DOCUMENT.FULLNAME$. Both Variables contains the same value - The document name with the full path included. What I need is the short document name.
How can get that ?
Thanks in advance
I have had to do the same thing and unfortunately there is no system variable in ProjectWise for the Document Name.For Office documents I use some of the built in MS Office attributes/bookmarks to grab the file name.
When the name is needed to push into other fields or if you need to have the variable to reference in other attributes, I create a dummy Attribute and set it with an SQL UPDATE statement:SELECT O_ITEMNAME FROM DMS_DOC WHERE O_PROJECTNO=$VAULT$ AND O_ITEMNO=$DOCUMENT$
Hope this helps.
I will try that.