SPD Workflow – Approval Task Email Notification with link to Edit Task Form

Posted By Posted by: Irfan Rizvi on August 10, 2017

We recently received a request from a customer relating to their governance workflow, in this case, the SPD Project Server 2013 workflow. When an approval task is assigned to a user, the customer wants a generated user email notification with a link to the task’s edit form instead of the display form (the default behaviour). This

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Server
Blog Posted In 

Adding comma ‘,’ in text lookup entry on Project Server lookup tables

Posted By Posted by: Irfan Rizvi on August 4, 2017

In Project Server / Project Online lookup tables, if you add a text lookup entry which contains a comma ‘,’ as such: A validation message will appear on Project Server to say:   The lookup table values cannot contain the server list separator ‘,’ because, in multiple value fields, the entries are separated by a

Read More


Blog Posted In 

How-To Delete the Web Part from Page Using PowerShell Scripts for the Existing Projects Sites

Posted By Posted by: Ahmed Taee on June 22, 2017

Sometimes we are required to delete the web part from an existing project’s site. In this blog, I will guide you step-by-step on how to delete the web part using a PowerShell script: Run an SQL query to get the list of the projects and their URL SELECT [ProjectName] ,[ProjectWorkspaceInternalHRef] FROM [MSP_EpmProject_UserView] Copy the results with

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Server
Blog Posted In 

How to Set up Long Field Names in Project Server

Posted By Posted by: Irfan Rizvi on March 21, 2017

I came across this requirement quite frequently in which you have very long field names that are more than the character limit defined by Project Server. What we usually end up doing is rephrase the field name to fit the character limit and add the full text in the description. It looks something like this:

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Server
Blog Posted In 

Project Server 2013 permissions synchronization explained

Posted By Posted by: Peter Williams on August 23, 2016

This blog attempts to explain the synchronization of SharePoint group membership/permissions for Project Server 2013. This ONLY applies when Project Server Permissions mode is enabled. Project Server to Project Web App Site Permission Synchronization Note: The statements made in this section are only applicable if the “Enable Project Web App Sync” option is turned on

Read More


Blog Posted In 

Project Server Timesheet: Recording time at Project Level

Posted By Posted by: EPM Partners on July 12, 2016

Occasionally in Project Server, we encounter a situation where timesheet capture is only required at project level and not task level. The requirement in this scenario is users are only presented with one timesheet task for each project they work on. Project Server can be configured to allow top level time reporting. In my experience, this

Read More


Blog Posted In Blog Posted In: Blog, How to, Project Server
Blog Posted In 

Which Enterprise Projects are using local resources?

Posted By Posted by: Peter Williams on May 4, 2016

When implementing Resource management in a Project Server environment, it can be useful to a PMO administrator to know which projects contain local resource assignments as opposed to the use of only Enterprise resources. For an On-Premise installation of Project Server 2010 or 2013, where access to the underlying databases is possible (as opposed to

Read More


Blog Posted In Blog Posted In: Blog, PMO, Project Server
Blog Posted In 

Project Workspace List Viewer Replacement

Posted By Posted by: EPM Partners on July 23, 2015

The workspace list viewer webpart is a component of the Project Server 2010 SDK.  It was very popular.  It helped blur the barrier between the project site and the project web application (PWA).  Today, this barrier is something many end users still have a hard time understanding.  I often have requests to make a particular

Read More


Blog Posted In Blog Posted In: Project Server
Blog Posted In 

Error and Solution: The INSERT statement conflicted with the FOREIGN KEY constraint

Posted By Posted by: Peter Williams on April 13, 2015

We recently received an issue where our client was unable to see a project in their Project Status Report. They had tried publishing the project and received a “Failed But Not Blocking Correlation”. The error below was found in the project server queue: ReportingProjectChangeMessageFailed (24006) – The INSERT statement conflicted with the FOREIGN KEY constraint “FK_MSP_EpmAssignmentByDay_ProjectUID_AssignmentUID”.

Read More


Blog Posted In 

Microsoft Ignite 2015 is Coming! Here’s our Pick for the Top 8 Project Sessions

Posted By Posted by: Khurram Jamshed on March 30, 2015

This year’s most talked about event is Microsoft Ignite 2015. Unlike previous times, when Microsoft used to host separate conferences to showcase different technologies during different times of the year, this time Microsoft will be hosting an inaugural, unified Microsoft commercial technology conference the week of May 4, 2015 in Chicago, Illinois. This conference will give

Read More


Blog Posted In Blog Posted In: Project Server, SharePoint
Blog Posted In