• Using a list of attribute values to return all

    Hi All. I am hoping someone can help as I am assuming this is relativity simple but beyond my knowledge at this stage. I am attempting to write a script that will search through the datasource and return all files that match an attribute value. Ie…
  • Update User IdentityProvider in PowerShell

    How can I update user's Identify provider column using PowerShell?
  • Report Saved Search to excel, with custom attributes

    I would like to write a report to excel based on a saved search. I also need to write a custom attribute 'Revision No' to excel. In the if block the custom attribute is written to the terminal but it doesn't write to Excel. $SavedSearch = 'PW…
  • New-PWRichProject from a template project works very slow

    Hello, My template work area has all the folder structure with the required workflows with permissions applied. Also, the template has user-lists with a particular prefix. When I try to create New-PWRichProject from the template project, I go through…
  • Updating folder description

    Trying to updating the folder properties which i am trying to get the value from one source folder and updating the target folder. The below code is working when there is a value in the source folder but giving a below error if there is no value. Could…
  • Export document attributes to an excel file

    I want to export a set of documents and its attributes to an excel file. I tried it using " Get-PWDocumentsBySearch " function and was not able to find the attributes value $documents=Get-PWDocumentsBySearch -FolderPath '\Software' -GetAttributes…
  • How to combine 2 ProjectWise document objects list into one in PowerShell

    How to combine 2 ProjectWise document objects list into one in PowerShell
  • How to get the Environment of a document in PowerShell

    How to get the Environment of a document in PowerShell
  • How to get all the empty folders in a ProjectWise Data source?

    How to get all the empty folders in a ProjectWise Data source?
  • 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…
  • 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…
  • Set-PWDocumentState failing

    I am trying to change the state of a file with using the below code, but i am getting an error message like below. If someone could correct me where i am wrong would be very much appreciated Error Message : VERBOSE: Found 1 documents WARNING: Failed…
  • Using "Select-PWSQL" cmdlet, which table can I find the document "FullPath"?

    As per title I want to return the full path of all documents on the server. I found that the "dms_doc" table has everything I need for a specific task except the full path for each document. Any ideas which table I can look at that will contain the fully…
  • 'Get-PWDocumentsBySearch' bug: Returning all versions of documents when the '-GetVersionsToo' flag is not active?

    I have a saved search which when combined with ' Get-PWDocumentsBySearch ' produces a list of all versions? Looking in ProjectWise explorer the saved search gives me a list of 81 documents / 356 with 'Show versions' on; whilst the cmdlet using the same…
  • Advanced PowerShell Functions: Begin to Process to End

    All - I found a good article explaining when to use Begin, Process and End for functions: Advanced PowerShell Functions: Begin to Process to End Hopefully you find it useful.
  • How To: Add Dynamic Parameters to Your PowerShell Functions

    I have added another post to my blog. Please take a look. https://powerwisescripting.blog/2019/01/23/how-to-add-dynamic-parameters-to-your-powershell-functions/ Cheers, Brian
  • Get-PWAttributeValueListFixedList - is there a setter?

    There is a getter (Get-PWAttributeValueListFixedList) to get the fixed list values of an attribute. Is there a setter (Set-PWAttributeValueListFixedList)? Or is there some other way to update the fixed value list that I seem to be missing? Thanks.
  • Delete the file if file has more than 10 version, and if the file is more than 6 months old

    Find the files which has more than 10 version, and the 11th and above version are more than 6 months old, need to be deleted from ProjectWise.