Using the updated ChangeXML utility for Statusing

The Statusing methods in the Project Server Interface (PSI) in Microsoft Project Server 2010 enable one user to read, submit, and update assignment and task status for another user, without resorting to impersonation. In the Project Server 2007 SDK, the How to: Generate ChangeXML for Statusing Updates article shows how to generate the changeXml parameter…

2

Reading Enterprise RBS values: the Easy Way and the Not-So-Easy Way

There are a couple of ways to programmatically get the Resource Breakdown Structure (RBS) value for a Project Server user. The simplest way is to query the Reporting database, for example: SELECT [ResourceUID] ,[ResourceName] ,[ResourceBookingType] ,[ResourceIsActive] ,[RBS] FROM [ProjectServer_Reporting].[dbo].[MSP_EpmResource_UserView] AS res WHERE res.ResourceName = N’Linda Jones’ The result on my machine is: ResourceUID ResourceName ResourceBookingType…

2

Creating a Project for a Department, and Using the WCF FaultException

When you add a Project Departments custom field to a ProjectDataSet.ProjectCustomFields table, do not set the value of the MD_PROP_ID property. Project Server automatically adds a value when it creates the project. The CreateProject4Department code example shows the data in the ProjectDataSet before and after the call to QueueCreateProject. The WCF-based CreateProject4Department example in the attached…

0

Custom Field and Lookup Table Webcast

Hello, Attached is my source code and power point presentation of today’s webcast on custom fields and lookup tables: CustomFieldCRUD – This a very simple application that shows how to create, read, update and delete custom field definitions on Project Server 2007 using the PSI. PublishProjects – This is an application that was written for…

6