Auto-publish projects in MS Project Server/Project Online using PowerShell
In MS Project Server/ Project Online, whenever team members submit their timesheet or assignment status, it routes to the project manager for approval process. Even when he approves, it automatically does not update project plan and the reporting database. He need to publish the project after approval in order to update the reporting database.
There might be scenarios where timesheets are approved but the project is not published, like when project managers are leading many projects simultaneously or they just forget to publish the project. To keep the plan updated and reporting database always ready, we at Advaiya have developed a PowerShell script to auto-publish all projects together.
Here’s how it works:
The script can also be scheduled as required. An important thing to note about this script is that it is customized to publish only checked-in projects. So, if a project is checked-out, it won’t be passed to the next step in the workflow, and instead the script will look for another project in the queue.
You can download the script for your use. Click here to download.
Have any questions? Share it in the comment, and we can discuss.
Posted by Nikhil
Nikhil is currently working as a Software Developer with Advaiya, and responsible for developing Enterprise Project Management solutions. He has been working on technologies like PSI, Power BI, SSRS, CSOM, and has interest in learning and configuring project server reporting.