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)

I am very pleased to announce that I was awarded the MVP award for Project in April 2013. I am grateful for such recognition for doing something I really enjoy, helping out fellow Project Server community members. I have been holding off announcing the award as my surname is wrong on the award, it states Paul Mathers instead of Paul Mather. This is something that is being corrected but will take time.

I look forward to continuing helping out in the Project,Project Server and SharePoint communities.

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 just to highlight how different browsers will render the ribbon differently based on the zoom level of the session. Some examples below to show the differences between IE 9 and Chrome version 26. At the default 100% all browsers render the ribbon identically. All pages / ribbons are affected.

IE 9 – Tasks Page – 125% zoom:

Chrome – Tasks Page – 125% zoom:

Notice the buttons are all grouped together.

What is interesting is if you increase the zoom to 150% in Chrome the buttons are no longer grouped:

Just something to be aware of if you have a user who raises this. Ask them to press Ctrl and 0 to set the zoom to the default 100% and the buttons should appear as normal on the ribbons.

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 April 2013 Cumulative Updates are now available, please see the links below:

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

Project Server 2013 Server Roll up package April 2013 CU (Recommended):
(Delayed)
Project Server 2013 April 2013 CU (Included in the Server Roll up package): 
http://support.microsoft.com/kb/2760261
Project 2013 April 2013 CU:
http://support.microsoft.com/kb/2768336

Also worth noting, install the March 2013 Public update: http://support.microsoft.com/kb/2768001 if installing the April 2013 CU.

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

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

Project Server 2010 Server Roll up package April 2013 CU (Recommended):
http://support.microsoft.com/kb/2775426
Project Server 2010 April 2013 CU (Included in the Server Roll up package):
http://support.microsoft.com/kb/2791064 & http://support.microsoft.com/kb/2760780
Project 2010 April 2013 CU:
http://support.microsoft.com/kb/2794664
Remember SP1 is a pre-requisite for the Office 2010 April 2013 CUs.
For more details please see:

http://blogs.technet.com/b/projectsupport/archive/2013/04/11/microsoft-project-server-2007-2010-and-2013-april-2013-cu-announcement.aspx
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)

A quick blog post to highlight the use of one of the Project Server Reporting database functions to resolve an issue when using an SSRS multi value parameter.

There are several methods to get multi value parameters working in SQL Server Reporting Services (SSRS) including dataset filters, joining parameters and custom SQL functions – other blogs / forum posts detail these. This post demonstrates using a function that is available in the Project Server Reporting database. The function is called MSP_FN_Utility_ConvertStringListToTable. An example SQL Stored Procedure that will allow multi values can be seen below:

CREATE PROCEDURE [dbo].[SP_ProjectData] (
        @ProjUID NVARCHAR (max)
)AS
BEGIN
select            P.ProjectName
           ,    T.TaskName
from            MSP_EPMProject_UserView P
INNER JOIN        MSP_EPMTask_UserView T
ON                P.ProjectUID = T.ProjectUID
INNER JOIN        MSP_FN_Utility_ConvertStringListToTable (@ProjUID) AS PU
On              P.ProjectUID IS NULL or P.ProjectUID like PU.TokenVal
END

Create the SQL query as normal but instead of using a where clause to filter the Project UIDs join on to the function as shown above.

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 post will take a brief look at creating a map view of Project Server data – this does assume you tag your projects with a location!

For the purpose of this post I will use the example Excel file shown below – this pulls data from one of my test Project Server PWA instances, hence the project names!

In Excel 2013, click Insert > Power View Reports:

You will now see a Power View report:

To create a map with the projects plotted in the correct location by cost, see the steps below.

On the design tab, click Map and you will see the following:

Now click the map and modify the Power View fields shown below:

For this example, add ProjectCost to the size property, add Project Locations to the Locations property and set the colour property to ProjectName:

Increase the size of the map and add a title:

You can hover over the data circles and a tooltip will appear with the project details:

The data can be refreshed and the map updates.

A quick and simple report to show projects by location.

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)

Now that the first CU’s for 2013 are available, I will include both 2010 and 2013 updates in the future posts.

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

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

Project Server 2013 Server Roll up package February 2013 CU (Recommended):
(Delayed)
 
Project Server 2013 February 2013 CU (Included in the Server Roll up package):
(Delayed)
 
Project 2013 February 2013 CU:
http://support.microsoft.com/kb/2738031

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

http://support.microsoft.com/kb/2800779
 
Project Server 2010 Server Roll up package February 2013 CU (Recommended):
http://support.microsoft.com/kb/2767794
 
Project Server 2010 February 2013 CU (Included in the Server Roll up package):
http://support.microsoft.com/kb/2760772
 
Project 2010 February 2013 CU:
http://support.microsoft.com/kb/2760778
 
Remember SP1 is a pre-requisite for the Office 2010 February 2013 CUs.
 
For more details please see:

http://blogs.technet.com/b/projectsupport/archive/2013/02/14/microsoft-project-server-2007-2010-and-2013-february-2013-cu-announcement.aspx
 
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)

One question we have from many clients is, can we have the project timeline image on the project site. The answer is yes, but this will not update automatically in Project Server 2010. On a side note, it is possible to have the timeline view in Project Server 2013 PWA!

This blog post covers a workaround to this limitation in Project Server 2010 using VBA. At this point I will state that I am no VBA expert, my VBA knowledge is very limited to say the least. This is a simple macro but I’m sure it could be improved  

For this to work a custom DLL is required on the workstations as there is no option to save a clipboard image to a file in VBA (as far as I know!). The DLL can be downloaded here: http://www.vbforums.com/showthread.php?585616-clipboard-activex-for-vba-vbs-etc Use this at your own risk as I do not know the code behind this DLL!

For this example, I created a file share to store my images \\vm353\ProjectSiteTimeLineImages. All users will need read / write access to this share.

The VBA code can be seen below, add this to the Enterprise Global:

Private Sub App_ProjectBeforePublish(ByVal pj As Project, Cancel As Boolean)
Dim clip As Object
Dim proj As Project
Set proj = ActiveProject
Dim path As String
path = "\\vm353\ProjectSiteTimeLineImages\"
Dim file As String
file = ".bmp"
Dim fileName As String
fileName = path & proj & file

Application.ViewApply Name:="Timeline"
Application.TimelineExport SelectionOnly:=0, ExportWidth:=1000
Application.ViewApply Name:="Gantt Chart"
Set clip = CreateObject("clipbrd.clipboard")
SavePicture clip.GetData, fileName
Set clip = Nothing
End Sub

Before a project is published the timeline image will be saved as a file to the share. See the example / walkthrough below:

File share before publish:

Create a new project, save and publish:

File share after publish:

Image:

Now we have the timeline as an image, this needs to be added to the project site – I won’t go into the details as this is basic SharePoint end user config task. See the Project site below with the image:

Notice only 3 tasks are added to the timeline, lets add some additional tasks.

I have added task T5 and added this to the timeline:

After publishing this project, refresh the project site:

A nice simple solution to a dynamic timeline image on the Project Server 2010 Project Sites. After publishing more projects, more timeline images will appear in the shared folder:

As mentioned, the VBA could be improved with error handling etc. Use this and the custom DLL at your own risk and fully test on a test workstation and PWA instance first.

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)

Quite often system administrators want a way to automate tasks, creating the Project Server Project Professional  accounts is usually one of these tasks. This blog post shows an example of creating a Project Professional 2010 account.

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

http://gallery.technet.microsoft.com/scriptcenter/Create-Server-2010-dfb0fbba

When creating an account, a registry key is created here:

HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\MS Project\Profiles\<Profile Name>

After running the script, a new registry key will appear:

Script:

Before running the script you will need to update two variables, $accountName and $pwaURL with the correct values.

New Key after executing the script:

As you can see, the script on creates three string values, the rest get created when you launch Project Professional 2010 and connect to the new account:

New account:

Additional string values:

A simple solution for creating Project Professional 2010 accounts.

I recommend that this script is tested thoroughly on a test workstation before using within a production environment.

This script is just an example, use this script at your own risk. Remember to always backup the Registry before making any changes.

This script is probably a better approach to the Registry key export detailed in a post I wrote a while back:

http://pwmather.wordpress.com/2011/07/29/customise-project-professional-2010-installation-projectserver-ps2010-msproject-office2010/

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 to highlight a product from CPS, Project Server Plus. This is a quick start preconfigured Project Server solution includes best practice fields and lookup tables, Views, RAG calculations and indicators, many great dashboards / reports and an enhanced Project Site template – all out of the box.

For details see:

http://www.cps.co.uk/What-We-Do/Pages/Project-Server-Plus.aspx

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 2010 December 2012 Cumulative Updates are now available, please see the links below:

http://support.microsoft.com/kb/2789671
 
Project Server 2010 Server Roll up package December 2012 CU (Recommended) – delayed:
http://support.microsoft.com/kb/2596956
 
Project Server 2010 December 2012 CU (Included in the Server Roll up package):
http://support.microsoft.com/kb/2553504
 
Project 2010 December 2012 CU:
http://support.microsoft.com/kb/2553188
 
Remember SP1 is a pre-requisite for the December 2012 CUs.
 
For more details please see:

http://blogs.technet.com/b/projectsupport/archive/2012/12/19/microsoft-project-server-and-sharepoint-server-2007-and-2010-december-2012-cu-announcement.aspx
 
As always, test these updates on a replica test environment before deploying to production