#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo: Report on Large Files

In this post, we will be creating a PowerShell function script file (.psm1) to generate a report (Excel spreadsheet) containing a list of documents which meet or exceed a specified file size. All of the ProjectWise related cmdlets are available using the PWPS_DAB module. At the time of this post, I am using version 1.22.1.0. Take… Continue reading HowTo: Report on Large Files

#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

A Little Fun with Strings

I had a user ask how they could build a file description using the values from four source strings. The caveat is that any of the strings could be null or empty. So, what to do? The following are examples of the end result we are trying to achieve. $FileDescription = "Desc1" $FileDescription = "Desc1-Desc2-Desc3"… Continue reading A Little Fun with Strings

#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo: Generate Attribute Usage Report

Have you ever wondered which attributes (columns) within each of your ProjectWise Environments are actually being used?  I have seen many users with multiple environments, each containing hundreds of attributes. The problem is that only 20 to 25% of the attributes (columns) may contain any values. It takes a lot of time and energy to… Continue reading HowTo: Generate Attribute Usage Report

#PowerShell, #PowerWiseScripting, #ProjectWise, PWPS_DAB

HowTo: Setup New Datasource

UPDATE: There was in issue in one of the functions I provided. Please download the attachment again to get the latest file. In this post, we will be using two PowerShell functions (New-PWDSSetupReport and Use-PWDSSetupReport.) to add users, groups, userlists, workflows, states, etc. to a new datasource.  The functions are provided in a PSM1 file… Continue reading HowTo: Setup New Datasource