August | 2013 | Paul's Project Server and Project Online Blog

Create a #ProjectServer #PS2010 #PS2013 project from a template and update the EPT #SP2013 #SP2010 #PowerShell

August 30, 2013 at 11:24 am | Posted in Add-on, Administration, Configuration, Customisation, Functionality, PowerShell, PSI | 1 Comment
Tags: PowerShell, PPM, Project 2010, Project 2013, Project Server 2010, Project Server 2013, PS2010, PS2013, SharePoint 2010, SharePoint 2013

I have been meaning to publish this PowerShell script for a few months but finally got around to it today. The PowerShell script creates a project from a template then updates the Enterprise Project Type (EPT). I did write a post over a year ago on how to create a project using PowerShell but this didn’t update the EPT:

https://pwmather.wordpress.com/2012/01/17/create-and-publish-a-project-in-projectserver-via-powershell-ps2010-msproject-sp2010/

The issue is that even if your Project Plan Template is associated to an EPT in Project Server, the project created from the CreateProjectFromTemplate method is associated to the default EPT regardless. This script will prompt for the project name, the project plan template name and the EPT name. It will create the project then update the project to associate it to the desired EPT. The script can be downloaded from the script gallery below:

http://gallery.technet.microsoft.com/scriptcenter/Create-Server-2010-2013-19bd3cc7

Once downloaded, the script will need to be updated with the correct PWA URL, the lines that need updating are 9 and 23. These can bee seen below:

Update the http://vm753/pwa part of the URL for your PWA URL.

A walkthrough using the script is below.

Open Windows PowerShell and navigate to the PowerShell file, in this example it is on the desktop:

Press Enter and complete the details:

The new Project will be called “CPS Test Project by Paul Mather”, it will use the “PMTemp1” template and then associate the new project to the “PM TEST” EPT.

The project is created as you can see in the Project Center:

It is also associated to the specified EPT:

The default EPT on this PWA instance is “Enterprise Project”:

When using the CreateProjectFromTemplate method only, this new project would have been associated to the Enterprise Project EPT as this is the default EPT.

This is just an example of what can be done, many improvements could be made, certainly around error handling but it provides a working example for you to build on. Smile

#PowerShell scripts for #ProjectServer #PS2013 #SP2013 #PPM

August 29, 2013 at 9:03 am | Posted in Administration, Configuration, Customisation, Functionality, Information, PowerShell, PSI | 1 Comment
Tags: PowerShell, PPM, Project 2013, Project Server 2013, PS2013, SharePoint 2013, SP2013

I haven’t posted for a while due to work commitments and just generally being too busy – I am hoping this will change after the summer!

Anyway, just a quick post today to let you know that I have tested some of the key PowerShell scripts I wrote for Project Server 2010 on Project Server 2013. These also work for Project Server 2013. I have since updated the script gallery and associated blogs posts for these scripts listed below:

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

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

High-level Audit example:
http://gallery.technet.microsoft.com/scriptcenter/Server-2010-High-level-e9c6ad09

Updating Project Server Lookup Tables:
http://gallery.technet.microsoft.com/scriptcenter/Update-Server-Lookup-table-bb1ae14f

My other scripts are available for download here:
http://gallery.technet.microsoft.com/scriptcenter/site/search?f%5B0%5D.Type=User&f%5B0%5D.Value=PWMather

Look out for more scripts coming soon.

Enjoy Smile

#ProjectServer and #SharePoint 2010 / 2013 August 2013 Cumulative Update #PS2010 #SP2010 #PS2013 #SP2013 #MSProject

August 14, 2013 at 8:54 am | Posted in Administration, Configuration, CU, Fixes, Information | 2 Comments
Tags: Office 2010, Office 2013, Project 2010, Project 2013, Project Server 2010, Project Server 2013, PS2010, PS2013

The Office 2013 August 2013 Cumulative Updates are now available, please see the links below:

http://support.microsoft.com/kb/2873346

Project Server 2013 Server Roll up package August 2013 CU (Recommended):
http://support.microsoft.com/kb/2817615
Project Server 2013 August 2013 CU (Included in the Server Roll up package):
http://support.microsoft.com/kb/2817508
Project 2013 August 2013 CU:
http://support.microsoft.com/kb/2817502

Also worth noting, if you haven’t done so already, install the March 2013 Public update: http://support.microsoft.com/kb/2768001 if installing the August 2013 CU.

The Office 2010 August 2013 Cumulative Updates are now available, please see the links below:

http://support.microsoft.com/kb/2869757

Project Server 2010 Server Roll up package August 2013 CU (Recommended):
http://support.microsoft.com/kb/2817573
Project Server 2010 August 2013 CU (Included in the Server Roll up package):
http://support.microsoft.com/kb/2817580 & http://support.microsoft.com/kb/2817587
Project 2010 August 2013 CU:
http://support.microsoft.com/kb/2817584
Remember SP1 or SP2 is a pre-requisite for the Office 2010 August 2013 CUs.

For more details please see:

http://blogs.technet.com/b/projectsupport/archive/2013/08/13/microsoft-project-server-2010-and-2013-august-2013-cu-announcement.aspx

As always, test these updates on a replica test environment before deploying to production

#ProjectServer #ProjectOnline highlight report example #PS2013 #SP2013 #Excel #BI #Office

August 1, 2013 at 12:02 am | Posted in Administration, Configuration, Customisation, Functionality, Information, Reporting | 8 Comments
Tags: Excel Services, Office 2013, Office365, Project 2013, Project Online, Project Server 2013, PS2013

A common requirement for clients is to have a report that highlights key information about each project. This usually includes any key project level fields, up and coming tasks / milestones and any active issues or risks. For previous versions of Project Server, in my opinion, the best reporting technology for this was SQL Server Reporting Services (SSRS). For Project Server 2013 on-premise installations SSRS is probably still the best option for most reports due to the flexibility around formatting, layout etc. For Project Online, unfortunately SSRS is not an option, a nice option for a project highlight type report is Power View. This blog post will walkthrough creating a project highlight report using OData and Power View for Project Online. This example report contains key project level data, key milestones due to complete this month, future key milestones, active issues and active risks. The OData feeds used are:

https://<serverurl>/pwa/_api/ProjectData/Projects()?$filter=ProjectType ne 7&$select=ProjectId,ProjectName,ProjectOwnerName,ProjectStartDate,ProjectFinishDate,ProjectWork,ProjectCost,TotalCost,ProjectQuality,ProjectSchedule,ProjectCost,ProjectResource
https://<serverurl>/pwa/_api/ProjectData/Tasks()?$filter=TaskFinishDate gt datetime’2013-08-01T00:00:00′ and TaskFinishDate lt datetime’2013-09-01T00:00:00′ and KeyMS eq ‘Yes’&$select=ProjectId,TaskIndex,TaskName,TaskStartDate,TaskFinishDate
https://<serverurl>/pwa/_api/ProjectData/Tasks()?$filter=TaskFinishDate gt datetime’2013-09-01T00:00:00′ and KeyMS eq ‘Yes’&$select=ProjectId,TaskIndex,TaskName,TaskStartDate,TaskFinishDate
https://<serverurl>/pwa/_api/ProjectData/Issues()?$filter=Status eq ‘(1) Active’&$select=ProjectId,IssueId,Title,Discussion,Resolution,Owner,DueDate
https://<serverurl>/pwa/_api/ProjectData/Risks()?$filter=Status eq ‘(1) Active’&$select=ProjectId,RiskId,Title,MitigationPlan,ContingencyPlan,Owner,DueDate

These feeds need to be added to Excel 2013 using the “From OData Data Feed” option found on the DATA tab:

Paste the feed URL into the Link or File field:

Click Next

Select the Projects table:

Click Next

Click Finish

Select Only Create Connection and Click OK

Repeat these steps to add the other OData feeds using the same steps.

Once all of the feeds have been added, the table relationships need to be created. On the DATA tab in Excel click Relationships. This can be found in the Data Tools group.