Did you know that there is a SQL function provided with ProjectWise which will return all folders within a provided ProjectWise folder specified by the corresponding folder id. The name of the function is dsqlGetSubFolders. In this post, I will show an easy way to retrieve all ProjectWise Folder objects for a provided Work Area… Continue reading HowTo: Get ProjectWise Folders By GUID Using dsqlGetSubFolders
I want to thank Robert McMillan for the inspiration for this post. He had created a process to get the Parent Rich Project of a specified folder or document. In this post, we will look at a function I've created which accepts a ProjectWise Document or ProjectWise Folder object and works its way back up… Continue reading HowTo: Get-PWParentWorkArea FUNCTION
In this post, I will demonstrate how to setup a FileSystemWatcher to monitor a specified local folder for new files. When a new file(s) is created in the folder on the local system, it will then be imported into a corresponding ProjectWise folder. We will only be monitoring created events, however, you can also configure… Continue reading HowTo: Monitor Folder to Import Documents Into ProjectWise
In this post I will demonstrate how to use an Assertion to verify if a ProjectWise folder exists in the current datasource. If the folder does not exist, it will be created. This assumes the user running the script has permissions to create the folder. This is just a quick demonstration to yet another powerful… Continue reading HowTo:Use an Assertion to Validate/Create a Folder
I have a simple one for this post. I will go through the process of creating a text file to contain an encrypted password. We will then retrieve the encrypted password and use it to log into a ProjectWise datasource. We will be using the following cmdlets to accomplish this task. All of the ProjectWise… Continue reading HowTo:Create and Use Encrypted Password File
