SharePoint (and Project Server) Shenanigans

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

A quick post to highlight a couple of great links from Brian Smith for Project Server 2013 / Project Pro 2013 updates / patches. See the links below:

Project 2013 client update reference: http://bit.ly/1AxUsiP

Project Server 2013 update reference: http://bit.ly/1AXa7pV

Bookmark these links today!

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

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

http://bit.ly/1IEypL4

Project Server 2013 December 2014 Server Roll up package:
http://bit.ly/1IEyrT3

Project Server 2013 December 2014 CU:
http://bit.ly/1IEyrT8

Project 2013 December 2014 CU:
http://bit.ly/1IEypLd

Also worth noting, if you haven’t done so already, install the March 2013 Public update: http://bit.ly/1lR8IgK or Service Pack 1 http://bit.ly/1uorn2C if installing the December 2014 CU.

The Office 2010 December 2014 Cumulative Updates are now available, please see the links below:

http://bit.ly/1IEyrTd

Project Server 2010 December 2014 Server Roll up package:
http://bit.ly/1IEyqi0

Project Server 2010 December 2014 CU:
http://bit.ly/1IEyqi2

Project 2010 December 2014 CU:
http://bit.ly/1uornQ2

SP2 is a pre-requisite for the Office 2010 December 2014 CUs.

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

For more details see: http://bit.ly/1uorniV

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

This script will enable the users to quick find and navigate to the Project Site for a particular project. This is useful if you have many projects in the instance. The script can be downloaded from the script gallery below:

http://bit.ly/1rMPi1b

To get the script to work you will need to download the following jQuery library: jquery-2.1.1.min.js – jQuery download Another version of this library may work but this was the one I used / tested with. Upload this library to your PWA site collection then update the script file with the correct location. I uploaded this file to the site collection document library as you can see in the code below:

This example script does use the ProjectData API, so users will need access to that for this to work.

Once the script is downloaded, upload this to the PWA site collection, in this example it was uploaded to the site collection documents library. Choose where you want to script to be accessed, in this example I have placed it on the PWA homepage using a content editor web part:

The content link in my example is: /sites/pwa/SiteCollectionDocuments/Project Site Finder.js

Once loaded, the page will look like this:

The user can then type in part of the project name and click “Find Project”:

The Project Site ULR column will contain the associated project site URL with a clickable hyperlink that will open the project site in a new window / new tab.

This only uses intrinsic fields so should work for any Project Online environment but do test it thoroughly first. You might want to improve the error handling etc. before deploying to a production environment. Also remember this does require the user to have access to the ProjectData API for this to work.

The script is provided "As is" with no warranties etc.

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

Just a quick post, if you ever receive the following error when trying to delete a Project Detail Page, ensure the PDP has been removed from all Enterprise Project Types (EPT):

The error message is:

“An event receiver has canceled the request.”

Removing the unwanted PDP from all the EPT’s resolved it for me.

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

Join a live webinar hosted by CPS and UMT360 to understand the core concepts of strategic Project Management Office (PMO). PMOs are being asked to master the important, yet tactical aspects of project management as well as take strategic responsibility for managing investment decisions to optimize spend and maximize return across the portfolio.

Now is the time to embrace the full spectrum of responsibility to ultimately maximize ROI.

Understand how integrating UMT360 investment planning and controls across the PPM lifecycle in Project Online gives you and the business, the financial and strategic insights needed to optimize spend and maximize from your project portfolios.

Start Date: 19/11/2014 12:30 GMT

End Date: 19/11/2014 13:30 GMT

Location: Online. Free to attend

To register, see the link below:

http://bit.ly/1sXQRUC

For more details see:

http://bit.ly/1xwK8Ym

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

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

http://bit.ly/1u4LoOu

Project Server 2013 November 2014 Server Roll up package:
http://bit.ly/14h04lj

Project Server 2013 November 2014 CU:
http://bit.ly/14h04lk

Project 2013 November 2014 CU:
http://bit.ly/14h04ln

Also worth noting, if you haven’t done so already, install the March 2013 Public update: http://bit.ly/1lR8IgK if installing the November 2014 CU.

The Office 2010 November 2014 Cumulative Updates are now available, please see the links below:

http://bit.ly/1u4LohA

Project Server 2010 November 2014 Server Roll up package:
http://bit.ly/14h05pF

Project Server 2010 November 2014 CU:
http://bit.ly/1u4LohC & http://bit.ly/14h04ls

Project 2010 November 2014 CU:
http://bit.ly/1u4LoOG

SP2 is a pre-requisite for the Office 2010 November 2014 CUs.

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

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

This script will display project information including project level data, milestones, issues and risks on one page on the associated Project Site in Project Online. The script can be downloaded from the script gallery below:

http://bit.ly/1wzL3Ua 

To get the script to work you will need to download the following jQuery library: jquery-2.1.1.min.js – jQuery download Another version of this library may work but this was the one I used / tested with. Upload this library to your PWA site collection then update the script file with the correct location. I uploaded this file to the site collection document library as you can see in the code below:

Also notice the reference to the two references to the Data tables CSS and JS files. I just referenced the hosted files but you could download these and host them yourself – if hosting the data table files yourself you will need more than just the two files reference here.

Worth noting, the script will also work for Project Server On-prem but the milestone query will need to be updated to use JSOM REST (/api/ProjectServer/) as the ProjectData ODATA feed has a bug with filtering for boolean fields. The query will need to be updated to use the REST fields – these are named different to the ODATA equivalents.

In this example i had the jQuery library and the “Projectonapage on project site.js” file uploaded the site collection documents library but in reality you would probably load both of these somewhere else in the PWA site collection but the choice is yours. I then created a page on my Project Site just in the Shared Documents library but again, create the page where you like within your Project Site. On the page I add a content editor web part and reference my “Projectonapage on project site” JavaScript file. I also added a link on the Project Site quick launch to my new page. The output can be seen below.

When the page loads the dialog box below will display until all the data has been loaded:

Once loaded, the page will contain the project data:

This only uses intrinsic fields so should work for any Project Online environment but do test it thoroughly first. You might want to improve the error handling etc. before deploying to a production environment.

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

Project Online is continuing to go from strength to strength with improvement changes and features being introduced frequently. An example of this is detailed in the link below:

http://bit.ly/1tad8Cb

This is the type of benefit you get when using a service hosted and maintained by Microsoft!

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

Following on from my recently released Project Online Reporting Pack, I have since added a new report to the pack – a milestone variance chart. This report is detailed in this post. For screenshots of the other reports and deployment steps, see:

http://bit.ly/11RQp3F

The v2 Project Online Reporting pack with the 6 reports can be downloaded here:

http://bit.ly/1sDmW66

Milestone Variance Report:

This report will show all of the marked milestones for the projects in the portfolio, you can filter by the Enterprise Project Type:

Look out for more reports / updates in the future.

I am a Project Server and SharePoint consultant but my main focus currently is around Project Server. I have been working with Project Server for nearly five years since 2007 for a Microsoft Gold Certified Partner in the UK, I have also been awared with the Microsoft Community Contributor Award 2011. I am also a certified Prince2 Practitioner. This article has been cross posted from pwmather.wordpress.com (original article)

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

Project Server 2013 October 2014 Server Roll up package:
**** No Project Server 2013 server roll up packages for October 2014, see http://bit.ly/1yGzpuQ ***

Project Server 2013 October 2014 CU:
http://bit.ly/1u8qATw

Project 2013 October 2014 CU:
http://bit.ly/1yGzqyL

Also worth noting, if you haven’t done so already, install the March 2013 Public update: http://bit.ly/1lR8IgK if installing the October 2014 CU.

The Office 2010 October 2014 Cumulative Updates are now available, please see the links below:

http://bit.ly/1u8qATx

Project Server 2010 October 2014 Server Roll up package:
**** No Project Server 2010 packages for October 2014, see http://bit.ly/1yGzqyM ***

Project Server 2010 October 2014 CU:
http://bit.ly/1u8qA65 & http://bit.ly/1yGzsqg

Project 2010 October 2014 CU:
http://bit.ly/1yGzsqh
Remember SP1 or SP2 is a pre-requisite for the Office 2010 October 2014 CUs.

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