#ProjectServer #PS2010 / #PS2013 Add a background image to homepage #SP2010 / #SP2013 #ProjectOnline

July 30, 2013 at 9:25 am | Posted in Administration, Configuration, Customisation, Functionality, Information | 1 Comment
Tags: , , , , ,

Quite a nice personal touch for a PWA instance is to add the company logo as the background image. This is very simple to do for both 2010 and 2013, 2013 is even easier than 2010.

Firstly we will look at 2010, the quickest way to add an image to the PWA homepage is to use CSS, an example is below:


Update the image URL to the correct image, save the CSS in notepad or preferred editor, for this example I called the file backimage.inc. Then upload the file to PWA, in this example it was uploaded to the Shared Documents library. Edit the PWA homepage and add a content editor web part, then link to the backimage.inc file:


Apply the change and click OK, then save the page and you will see your image set as the background:


For 2013 you just click Change the Look from the settings cog, click current:


Click Change and browse to the image and add. Click Try it out, if you are happy with the image, click Yes keep it:


This will add the image to all pages in 2013. Smile

#ProjectServer #PS2010 and #SP2010 Service Pack 2 Released #PPM

July 24, 2013 at 8:34 am | Posted in Administration, Configuration, Functionality, Information, Service Pack | 5 Comments
Tags: , , , , ,

Service Pack 2 has been released for Office 2010, this includes Project Server 2010 and SharePoint 2010. For links to all Office 2010 SP2 updates see the office update site below:


Project 2010 SP2: http://support.microsoft.com/kb/2687457

Project Server 2010 SP2: http://support.microsoft.com/kb/2687452

SharePoint 2010 SP2: http://support.microsoft.com/kb/2687453

For a full list of fixes, download the following Excel file:


For more information see the following blog post:


#ProjectServer #PS2013 / #PS2010 Last Modified and Last Published fields in PWA #SP2013 #PPM #ProjectOnline

July 22, 2013 at 11:52 am | Posted in Administration, Configuration, Functionality, Information | 1 Comment
Tags: , , , , , , ,

A query that has been asked by several of our clients in the past is: “The last modified date field in PWA is not updating”. In most scenarios the Last Published and Last Modified fields will match in the Project Center as shown below:


This is because the Project Center views look at the published data and both these fields will get updated with a publish. If you modify (save but not publish) a project from Project Professional or PWA the Last Modified date will not update which may cause confusion. If you click the project to go to the project details you will see the status bar does show the correct Last Modified date:


Incorrect in the Project Center view:


There are scenarios where the Last Modified date will update and show a later date than the Last Published date, for example if you modify the project information then save the project:


To avoid any confusion to PWA users I would recommend not displaying the Last Modified date in Project Center views.

#ProjectServer #Excel report with SQL Temporary Tables #PS2010 #PS2013 #SQL

July 19, 2013 at 11:45 pm | Posted in Administration, Configuration, Customisation, Functionality, Information, Reporting, T-SQL | 1 Comment
Tags: , , , , , , , , ,

I came across an issue a while back and meant to blog about it but forgot until a colleague of mine today mentioned the same issue. This jogged my memory of the fix so I thought it was a good time to write the post. The issue isn’t Project Server related but the reports and queries we were creating were for Project Server.

If your SQL query in an Excel file uses temporary tables Excel will throw an error like the one seen below:


For the search engines the error is below:

The query did not run, or the database table could not be opened.

Check the database server or contact your database administrator. Make sure the external database is available and hasn’t been moved or reorganized, then try the operation again.

The error will occur if you have the select statement in the connection file definition command text or even calling a SQL stored procedure from the command text. The same fix applied to both, at the start of the select statement add “SET NOCOUNT ON” as shown below:


Now Excel will execute the query and return the data as expected. Smile

#ProjectServer #PS2013 Manage Alerts #SP2013

July 17, 2013 at 10:34 am | Posted in Administration, Configuration, Functionality, Information | 1 Comment
Tags: , , , ,

A question I see and hear quite frequently is “Where has Manage My Alerts options gone in 2013?”. These have now moved the the PWA Settings page:


The two links for Manage My Alerts and Reminders and Manage My Resources’ Alerts and Reminders only appear once the SMPT server details have been enabled for the PWA instance. When the PWA notifications are removed from the PWA instance the two links are removed:


To enable notifications and enter the SMTP details, navigate to the Project Server Service Application in Central Admin, click Manage from the drop down menu next to the PWA site:


Enable the notifications and enter the SMTP server details on the Alerts and Reminders page. Once set, the two Manage Alerts links will appear on the PWA Sever Settings page under the Personal Settings heading. These links are permission controlled though. Worth noting, Project Server notifications are not currently available for Project Online.

#ProjectServer #PS2013 #Excel Pivot Table limitation

July 4, 2013 at 11:38 am | Posted in Administration, Customisation, Functionality, Information, Issue, Reporting, Workarounds | 1 Comment
Tags: , , , , ,

Just a quick post to highlight a limitation / issue with Excel Pivot Tables that I hadn’t seen before, details below.

This particular Pivot Table uses a Data Model that contains two OData feeds from Project Server 2013, one for Project details and one for Task details. The connections can been seen below:


The relationship has been set up as follows:


I have added Programme, Project Name, Task Name and Task Start to the Pivot Table. Programme and Project Name are from the Projects table and Task Name and Task Start are from the Tasks table. The Project Name is filtered to just one project:


Looking at the Pivot Table, it looks the CPS Test project has many tasks but in fact this project only has 4 tasks:


To resolve the issue you have to add a numerical field from the Tasks table to correct the aggregation:


Hope that helps Smile

Blog at WordPress.com.
Entries and comments feeds.