• How to get immediate child folders in a folder

    How to get only immediate child folders in a folder in powershell.
  • Customize document version created on the first state

    Hello, is it possible to customize by PowerShell Script, the document version, once it is added to the ProjectWise Datasource? Basically, it is possible to customize the Document versions, by using WRE. But when we are adding a new Document to ProjectWise…
  • Add one User List to each Folder option

    Hello, Basically, there is one Account and Datasource, with hundreds of Folders in it and there is a need to include one additional User List permission setting with Read access, without need of doing it manually for each Folder. But every Folder and…
  • Export / search in Local Doument Organizer dashboard

    Hi, I am dealing with a long list of exported and locked documents, in which I need to make selections based on keywords in Export folder / Export comment file properties. Is there a way to search in Local Document Organizer dashboard, or alternatively…
  • How to avoid empty folders while querying Get-PWFolders

    I was trying to get the list of folders in a folder. But I can see a large number of empty folders in the result. Is there any way to exclude empty folders while querying folder list using Get-PWFolders? $UndergroundStorageFolders= Get-PWFolders …
  • New-PWRichProject how to mention Environment

    New-PWRichProject how to mention the Environment
  • Comparing CustomAttributes sub-proprerties from Get-PWDocumentsBySearchExtended

    I'm having issues trying to compare the FileUpdateDate to an DateTime environment attribute returned by Get-PWDocumentsBySearchExtended in Where-Object. It doesn't appear to be able to expand the CustomAttributes sub-property for comparison? $PWDocs…
  • Mention attributes when creating a document

    Is there any option to send attributes values while creating file using " New-PWDocument "? New-PWDocument -FolderPath '\testing\' -FilePath $f.FullName -Verbose
  • Get a list of connected users

    Hey all. I have created a new blog post to offer a quick way of getting a list of all connected users within a ProjectWise datasource. Check it out. Let me know if you find it helpful. https://powerwisescripting.blog/2022/08/19/howto-get-list-of-connected…
  • Export-PWProjectAccessControl not outputting permissions correctly.

    Security Protocol now set to TLS 1.2 PWPS_DAB Version is 2.1.10.0 This is a 64-bit process. All, I ran into an issue with the Export-PWProjectAccessControl cmdlet where it is reporting different permissions then ProjectWise Explorer is: VERBOSE…
  • ProjectWise backup to a local file store keeping folder structure

    We need to make a backup of our project from ProjectWise to a local filestorage, keeping the folder structure. Using Export commands we don't get the folders. All files become stored in the same directory. Any suggestions?
  • Issue regarding creating new PWSession using C#

    I tried using to generate a login session. I declared the new PWSession as below but I get the following error I looked up communities and I get the following information [https://communities.bentley.com/products/programming/projectwise_programming/f…
  • switching refrences to there active versios

    Hello, is there a way to switch the references of an ProjectWise document to there active versions in the PWPS_DAB? I tryed to build an work arround but there is only an Add-PWDocumentReference which allows me to add aditionally references but i cant…
  • Anyone know what the problem is with calling recursive common table expressions from the PowerShell Select-PWSQL Cmdlet?

    simple common table expressions seem to work: e.g. ;with cte as ( Select proj.o_projectno ,proj.o_parentno ,proj.o_projectname From dms_proj proj where proj.o_parentno > 0 and o_instanceID <> 0 ) select * from cte However, adding the…
  • 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…
  • How to Find Where an Environment has been used

    How can I easily find where an Environment has been selected / used? I am trying to clean up our Datasource and possibly remove some older Environments. I believe there are some projects which can be archived and Environments changed to our updated…
  • Get-PWWebconnection

    Hey guys, When I run the below code to get the PW Web connection name it is replicate 2 nameslike below, UNIQUEID - PROJECT NAME UNIQUEID - PROJECT NAME Anybody noticed this ? Why it is showing 2 times ? $EncodedToken = ConvertTo-EncodedToken…
  • 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…
  • Get-PWPerformanceReportData leaving folders in datasources

    I have a script running on multiple caching servers to maintain a PowerBI page to assess PW performance, but the script now seems to be leaving hundreds of these sorts of folders in my datasources: Is there a way to ensure it doesn't do this? Kirk…
  • 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…
  • Check for Orphaned Files

    Is it possible to check for orphan files that exist on the in backend storage location, but not in the ProjectWise database/Front end?
  • Set-PWConnectedProjectAssociation

    I created a rich/connected project manually. And i want to associate it both. Using the below code is saying error and even I could not get the connected project guid. The connected projectid is showing like "00000000-0000-0000-0000-000000000000" Could…
  • Unable to download file while using Projectwise Web

    Unable to download file/s while using Projectwise Web no matter which browser I try. Preview option is also not working. Getting the below error- and this when trying to preview a file- At the top its says that 'This server is not publicly accessible…
  • How To: Generate a Managed Workspace Report

    I have added a new post to my blog. Hopefully, you find this useful. powerwisescripting.blog/.../