Using the Reporting Database and Excel – Part 1

I am not sure if this is a programmability post, but there have been many requests to do a post on writing a report in Excel that collects data from the reporting database. Since this will involve SQL and many developers who write code against Project Server will also need to write reports; this may…

1

The Microsoft Office Project 2007 SDK

The Microsoft Office Project 2007 SDK has been published to MSDN: http://msdn2.microsoft.com/en-us/library/ms512767.aspx The down load version should be available in the next few days. I will post a link once is becomes available. Though this is the RTM release of the SDK, we will be continually updating the SDK though out the life of the…

1

Getting a Project GUID on the Cheap

Many people have requested for a complementary method to GetProjectNameFromProjectUid where they can pass in a project name and it returns the project’s GUID. Unfortunately it did not make it into the Project API. Since it has been requested many times, I figured that it would be useful to post a method, GetProjectUidFromProjectName, which did…

1

Adding a Project to a Category

Brian Smith from PSS has passed along this sample that we thought might be helpful: The scenario here is that you have a lookup table that shows the categories you want users to select from when creating a project, and then the GUID for the “real” security category is held in the description for the…

3