Publish specified Projects in #ProjectServer using #PowerShell #MSProject #PS2010 #SP2010 #PS2013

October 22, 2012 at 12:54 pm | Posted in Administration, Configuration, Customisation, Functionality, PowerShell, PSI | 5 Comments
Tags: , , , , ,

There have been several requests for publishing projects listed in a text file, this follows on from my post / publish all projects script found below:

https://pwmather.wordpress.com/2012/05/31/updated-publish-all-projects-in-projectserver-using-powershell-msproject-ps2010-sp2010/

http://gallery.technet.microsoft.com/scriptcenter/Server-2010-Publish-all-45ba385b

****Update – this also works for Project Server 2013****

This script allows you to specify a list of projects in a text, then only those projects will be sent for publishing. For the purpose of this post I have a text file called projectstobepub.txt that contains a list of my test projects to be published:

image

The PowerShell script will need to be updated to reference the text file containing the list of projects that you wish to publish and also update the Project Server PWA URL. Comments have been added in the screen shot below to show what lines need to to be updated:

image

The script has my test PWA instance URL as highlighted below:

New-WebServiceProxy -uri “http://vm353/pwatest/_vti_bin/PSI/Project.asmx?wsdl” –useDefaultCredential

The strikethrough text will need to be updated with the correct URL for your environment.

The script can be downloaded from the Script Center following the link below:

http://gallery.technet.microsoft.com/scriptcenter/Server-2010-Publish-537857d8

Once the script has been executed, the projects listed in the text file will be sent for publishing.

The script can either be executed on demand or set on a schedule using Windows Tasks Scheduler. Execute the script with an account that has access to the projects listed in the text file.

Advertisements

5 Comments »

RSS feed for comments on this post. TrackBack URI

  1. […] This article has been cross posted from pwmather.wordpress.com (original article) […]

  2. Hi,
    can you give an estimation on how many projects can be published per hour using this script?

    • Hi, not really as it depends on how quickly the Project Server queue processes the jobs. Paul

      • Thanks a lot for the quick reply.
        Currently we are able to publish 30-40 projects per hour. Is there a way to increase the speed to 500-1000. Heard about it but I can’t imagine how it might be possible…

      • Make sure you have the correct DB maintenance plans in place and ensure the servers have sufficient memory / processors and ensure the database storage is optimised


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Create a free website or blog at WordPress.com.
Entries and comments feeds.

%d bloggers like this: