Tuesday, June 21, 2011

Project Server 2010- Demand Management Useful links

Read technical articles about Demand Management in Project Server 2010:
View the following webcasts to learn more:

Project Server 2010 - Demand Management- Showcase - Nice video

Project Server has a new infrastructure for building out a demand management process. This session covers the capabilities built in and how the workflow can be customized and extended to meet your business needs. This session will go over the following concepts: Developer experience in creating a Workflow; Deployment story for Project workflows; Administrator experience in creating Workflow Controlled Enterprise Project Types:

Get Microsoft Silverlight

Monday, June 20, 2011

Project Server 2010: Task level formula based Text Custom field

Hello EPM Users/Techies,

Today I was browsing the
Project Server forum & found a very easy but interesting question about displaying the task calender information in report which pulls the data from Project Server Reporting database. Since this information is not available in reporting database so thought a workaround & get the information.

1. Tried creating a TAsk level text custom field using formula:

2. In the formula section, picked up the field Text> Task Calendar

3. Added Task Calendar & when I tried to save that, got the error:

The custom field could not be saved due to the following reason(s):
  • This formula contains references to one or more fields that do not exist in the system. Correct the formula and try again.

4. Now, I thought to create the same field from project professional :
- Open project professioanl & Connect to Server
- Click on Project Tab
- Click on Custom fields button on the ribbon
- Select Task (radio button) & selected Text from the drop downlist of "Type"

- Clicked on formula

- Also, Clicked on Add field to Enterprise
- Created a plan & kept the TAsk level calender & added the TASK_CAL_CF column & I was able to see
 the calender applied to the task copied to Custom field.Published the Plan
- Ran the below query, I was able to get the information in PS Reporting database

[TaskUID],[TaskParentUID],[ProjectUID],[FixedCostAssignmentUID],[TaskName],[TASK_CAL_CF (Text1)]FROM [ProjectServer_Reporting].[dbo].[MSP_EpmTask_UserView]

Sunday, June 19, 2011

Friday, June 17, 2011

Update Project level Multiline Text Custom Fields

What a beautilful weather & I was kinda enjoying but suddenly One of My coworker pinged me & asked me a question about the Project level custom fields (multiline Text) so while I explained him about the usage of this kind of field, thought to write down somthing which might help Project Server community :)

Text custom fields can be multiline up to 4000 bytes, for use in project detail pages (PDPs) and with workflows for demand management in Project Web App. Multiline text custom fields are not usable in Project Professional. so I added a Project level Multiline text field in my PDP & now I wanted to update this field in a given project from my PSI program.

Here is the code for the Console application :

1. You will need to add project web service (ProjectWebSvc) web ref in the solution: http://servername/pwa/_vti_bin/PSI/Project.asmx?wsdl
2. Its very basic code, which has TEXT_VALUE update for a Multiline field
using System;
using System.Diagnostics;
using System.Net;
using System.Data;
using System.Text;
using Microsoft.Office.Project.Server.Library;
using PSLibrary = Microsoft.Office.Project.Server.Library;

ReadProjectResourcePSIclass Program{

static void Main(string[] args)try{



proj.UseDefaultCredentials =
Project proj = new ProjectWebSvc.Project();true;ProjectDataSet pds = null;
projectGuid = new Guid("195D9230-4A41-438A-917F-FDB6B292F586"); //Project for which I want to update the Multiline text field

pds = proj.ReadProjectEntities(projectGuid, 1 | 4 | 32, ProjectWebSvc.
    row.TEXT_VALUE =

foreach (ProjectWebSvc.ProjectDataSet.ProjectCustomFieldsRow row in pds.ProjectCustomFields)"TYPE your multiline text,TYPE your multiline text,TYPE your multiline text,TYPE your multiline textTYPE your multiline textTYPE your multiline text,TYPE your multiline text,TYPE your multiline text,TYPE your multiline textTYPE your multiline text,TYPE your multiline text,TYPE your multiline text";Guid sessionUId = Guid.NewGuid();proj.CheckOutProject(projectGuid, sessionUId, " ");Guid jobUId = Guid.NewGuid();proj.QueueUpdateProject(jobUId, sessionUId, pds,
proj.QueuePublish(jobUId, projectGuid,
jobUId =
proj.QueueCheckInProject(jobUId, projectGuid,
false);true, " ");Guid.NewGuid();false, sessionUId, "none");   }


Thanks to my coworker - Sumit Manchanda for initiating this :)
Happy coding :)

Project Server 2010: Enterprise Project Types

Enterprise Project Types (EPTs) are project templates that represent various types of projects and non-project work within the portfolio. For example, you can create an Enterprise Project Type to represent a HR related software Maintenance/development project or a marketing campaign.
An EPT is a combination of phases, stages, a single workflow, and Project Detail Pages. Each EPT represents a single project type. Normally, project types are aligned with individual departments, for example, marketing projects, IT projects, HR projects, and so forth. Using project types in Project 2010 now helps to categorize projects within the same organization that have a similar project life cycle

To create a new enterprise project type

On the PWA home page, click Server Settings.

  1. Click New Enterprise Project Type. In the Name box, enter a name for the type (e.g HR_Project_EPT), and then provide a brief description in the Description box.
  2. Select a workflow from the Site Workflow Association list. Once you associate a site workflow with a project type and save the type, you cannot go back and update the type to use a different workflow.
  3. Select a project detail page from the New Project Page list.
  4. If you selected No Workflow from the Site Workflow Association list, select the project detail pages that you want to include in this project type from the Available Project Detail Pages box, and then click Add to move them to the box on the right.
  5. If the enterprise project type that you are creating is the one that all new projects should use by default, select theUse this as the default Enterprise Project Type during Project Creation check box.
  6. Click the button next to the Departments field to select the departments that you want to associate with this project type, if it is appropriate.
  7. If you want to associate an image with this project type, provide the URL for the image in the Type the URL box.
  8. In the Order section, choose whether you want this project type to appear at the end of the list of project types, or if you want to control its placement in the list.
  9. To include this type at the end of the list, select the Position this type at the end check box.
  10. To control the placement of this type in the list, clear the Position this type at the end check box, and then choose the type that you want to appear just before the type that you are creating from the Choose the type before which the current type should be positioned list.
  11. Select a template from the Project Plan Template list, if it is appropriate.
  12. Select a template from the Project Site Template list, if it is appropriate.
  13. Click Save to save this enterprise project type to the server, thus making it available for new project or proposal creation.

    Watch the video:

SharePoint Designer- Unable to open a workflow - WWF .NET 3.0, must be installed to use the feature

Every day is a learning day and If we don’t learn a new thing today, the day is wasted. I don’t think much of a man who is not wise...