#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo: Get ProjectWise Folders By GUID Using dsqlGetSubFolders

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

#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo: Get-PWParentWorkArea FUNCTION

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

#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo: Monitor Folder to Import Documents Into ProjectWise

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

#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo:Use an Assertion to Validate/Create a Folder

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

#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo:Create and Use Encrypted Password File

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