Hey All. Just wanted to let everyone know that I’m still alive and blogging — my day job has been keeping me away the past couple weeks. I’m on four simultaneous client engagements, so as you can imagine I’ve been more than occupied.

I have a couple of posts in the works, so don’t worry — I’ll be back soon. I expect to have a new post up shortly. In the meantime, feel free to poke around the forums.

Thanks!
Steve

Popularity: 13%

Back in April, I posted an article where I recommended that you install the latest CU for SQL 2005 (CU7).

Since then, I’ve recieved feedback regarding some issues introduced by this CU. It would appear that they are more of an issue than I originally thought. Based on this feedback, I’m going to recommend that you all stick with CU6 for the time being.

Popularity: 26%

Quick post today… just for reference, the version numbers for the various major hotfixes and service pack.

RTM: 12.0.4518.1016
SP1 (KB 936984): 12.0.6218.1000
Post-SP1 Hotfix Rollup (KB 941426): 12.0.6300.5000
April 3rd, 2008 Hotfix (KB 950816): 12.0.6309.5000

Update: Chris Fiessinger posted an article back in December detailing the four ways to retrieve the version information from Project Server. The version numbers above should align to those returned by the PSI and within the Published DB.

Popularity: 25%

Within the Project Object Model, the Application object has a method, FieldNameToFieldConstant(), that returns a PjField constant for use by the various SetField() and GetField() methods throughout the object model. More information on the SetField Method (and other associated methods) can be found here.

Unfortunately, when using the PSI, there’s no quick way to lookup the Guid for a field. This can be a problem, since the various CustomFieldsRow objects (Task, Resource, Assignment, and Project) do not include the name of the custom field, only the UID (for an example, look at the ProjectCustomFieldsRow entity in the Project 2007 SDK).

Retrieving custom field information in the PSI is accomplished by using the CustomFields web service. The code below is a class that implements a method to retrieve the Guid of a custom field using the field’s name and entity type. I had to chop the code up a lot because of space constraints, so I apologize for the excessive line breaks. This code assumes that you’ve set up a Web Reference to the CustomFields web service named WebSvcCustomFields.