• Civil File Manager using Powershell

    Can you run Civil File Manager thru Powershell for ProjectWise folders? It works great for paths which are on the local computer, but not ProjectWise. ( $FolderName) (I can manually use CivilFileManager, but want to automate and simplify the process…
  • Update-PWWordDocumentFields

    Just wanted to ask the team, the cmdlet for Update-PWWordDocumentFields, as far as I understand, was set up as a workaround for a specific issue with Title block updates. How easy would it be to adapt this for Excel. And also, is there a way within PowerShell…
  • Help creating "24hr Changes" export script for a Work Area folder

    I'm trying to create a script that will search for any changes to files/folders made to a " Work Area " folder within a 24 hour period and export out a copy to a local folder for those changed items. This script will be executed once a day via Task Scheduler…
  • Select-PWSQL (and DataTable variations) - Limitations on DataTables

    I have used these commands on several scripts but have started running into issues on custom environment tables we have. The select statement is simply "SELECT * FROM env_1192", but this is returning "No columns in table" in PowerShell. I have double…
  • How To: Generate a Managed Workspace Report

    I have added a new post to my blog. Hopefully, you find this useful. powerwisescripting.blog/.../
  • Is there a PowerShell for PSET to rendition convertor?

    This seems like a general want for the Bentley users as they use Psets and Renditions are more limited. or a pset to PW file 'Set' convertor would help too.
  • Get-PWAllOwnedConnectedProjectIds returns only manually created project with deliverable management

    Hello ( Projectwise North Europe Datacenter, On premise Projectwise Datasources Pjw connect Server 3.299) I created some connected projects with PowerShell script, all is ok and works well, i can see them on the web console, i have Projectwise…
  • How To: Get Documents Not Checked In

    Hello All, I have new post demonstrating an alternative method for obtaining an array of documents which are not checked in. Hope you find this useful. http://powerwisescripting.blog/2021/10/19/howto-get-documents-not-checked-in/
  • List of Disabled users with disabled date

    Is there any way to export the list of disabled users with the date that user got disabled in ProjectWise using PowerShell?
  • Generate Environment Usage Report

    I have added a new post showing how to generate an Environment Usage report. Hopefully you find it useful. https://powerwisescripting.blog/2021/07/30/howto-generate-environment-usage-report/
  • HowTo: Create a SQL Tester w/ GUI

    I have added a new post showing how to create and use a GUI to develop and test SQL Select statements. https://powerwisescripting.blog/2021/07/28/howto-create-a-sql-tester-w-gui/
  • Generate a UserList and Group Usage Report

    I have added a new post outlining the steps to generating a UserList and Group Usage report. Hopefully you find this useful. http://powerwisescripting.blog/2021/07/27/howto-generate-userlist-and-group-usage-report/
  • Generate an Application Usage Report

    I have added a new post outlining the steps to generating an Application Usage report. Hopefully you find this useful. https://powerwisescripting.blog/2021/07/24/howto-generate-application-usage-report/
  • Re-Importing Project Access Control Excel "Error: Column 'ProjectName' does not belong to underlying table 'Directory' "

    I exported a Work Area access control details to Excel using Export-PWAccessControlToExcel command for all levels. Now, when I try to re-import the same after making some changes to access controls, I get the below error. Error: Column 'ProjectName…
  • Issues with Import-PWDocuments

    I'm running into issues with Import-PWDocuments. We've been using it for some time now to mirror a server location into ProjectWise to provide select external access to a large set of information. The dataset is roughly 200K files, 50K folders, and the…
  • HowTo: Update User's Domain

    Here's a new post demonstrating how to update the domain associated with a Windows type ProjectWise user account. Hope, you find it useful. http://powerwisescripting.blog/2021/04/22/howto-update-users-domain/ Cheers, Brian
  • Powershell Set-PWDocumentState does not perform RulesEngine

    I am trying to make a new version with powershell and I want to do that with the rules engine. The problem is when I change the state with Set-PWDocumentState it doesn't use the Rules Engine. What I use to change the state is: Get-PWDocumentsBySearch…
  • HowTo: Get Document Count for Disabled User(s)

    Hello All, Please check out my latest blog post. Hope you find this helpful. https://powerwisescripting.blog/2021/04/09/howto-get-document-count-for-disabled-users/ Cheers, Brian
  • Get-PWManagedWorkspaceVariables Causes ISE to Crash

    Just tried the example (slightly modified) from get-help on the Get-PWManagedWorkspaceVariables cmdlet: $ManagedWS = Get-PWRichProjects -FolderPath 'Folder\Folder' -JustOne | Get-PWManagedWorkspaces | Get-PWManagedWorkspaceVariables and it crashes…
  • How To - Use the New ProjectWise Folder Object Methods

    I have added a new post to my blog. Please check it out. https://powerwisescripting.blog/2020/12/11/howto-use-new-projectwise-folder-object-methods/ Cheers, Brian
  • Get ProjectWise Folder Object using the dsqlGetSubFolders SQL function.

    I have added a new post. Please take a look. https://powerwisescripting.blog/2020/12/02/howto-get-projectwise-folders-by-guid-using-dsqlgetsubfolders/ Cheers, Brian
  • HowTo - Get Parent Work Area / Rich Project

    I have added a new blog post. Please take a look. https://powerwisescripting.blog/2020/12/01/howto-get-pwparentworkarea-function/ Cheers, Brian
  • Is it possible to get the file content of a document on PW?

    i would like to pass it into a variable so that i can then create an instance of that file on AWS. i want to do this with out downloading the file for a local folder.. i have managed to do this on most systems but im new to powershell for projectwise…
  • Update federated identity

    Hello, I need some advice/help on how to update the federated identity of our PW users. Today our users are configured in a hybrid way. Meaning that their type is logical, but they also have the Federated Identity configured. This allows them to login…
  • How To: Import Documents From Monitored Folder

    Here is a post which shows how to setup a monitored folder. When files are added to the folder, they are imported into ProjectWise. https://powerwisescripting.blog/2020/11/09/howtomonitor-folder-to-import-documents-into-projectwise/ Cheers, Bri…