Read our content in other languages.

I’ve added a link to the new Windows Live Translator service that was rolled out this week.  The link is in the News section in the left column.  Clicking that link will bring up our site in the Live Translator site.  You can then pick which language you would like to see the posts.  I…


Visual Project Planning and Reporting

In case you weren’t aware of this, you can use the WBS Modeler tool to visually model and plan your projects or to validate the current structure of your project.  The tool uses Visio 2007 and Project 2007 to do this.  Ok, I haven’t used this yet.  I’m in the process of installing it now. …


New Add-In for Project 2007 – Import tasks from Excel

From Jim Corbin.  The technical article Importing Project 2007 Tasks from Excel Using a Managed Code Add-In is now published on MSDN. There is an associated download that includes the complete C# and VB.NET code, using Visual Studio 2008 (Beta 2) with Visual Studio Tools for Office.   Technorati Tags: Project 2007, Excel, Add-In, SDK


Report Pack – Update to the Timesheet Audit Report query

It appears part of the where clause is missing on the published Timesheet Audit report.  The result is that the weekly totals are all the same for each resource. To correct this, replace the SQL with the code below.  The addition is in bold below. SELECT MSP_EpmResource.ResourceName, MSP_TimesheetPeriod.PeriodName, MSP_TimesheetPeriodStatus.Description AS PeriodStatus, MSP_TimesheetStatus.Description AS TimesheetStatus, SUM(MSP_TimesheetActual.ActualWorkBillable)…


You’ve Got Questions, We’ve Got Answers

We’ve had a number of good questions come in.  I thought it would be helpful to share these and the answers.  Enjoy! –Treb Timesheet Question: Which is true?  Case 1:  Does the assigned timesheet manager approve all tasks in the timesheet (for example, project tasks as well as administrative time tasks) OR Case 2:  Does…


Using a Consolidated Project for What-If Analysis

This post is based on a technique presented in an Ed Hanna e-mail and is augmented with items that we are using internally to manage our own efforts.  This technique can work, to a certain extent, in Project Server 2003 and will definitely work in Project Server 2007. There are times where you need to…


New Connector Released

Today, Microsoft officially released a new connector between Visual Studio Team Systems and Project Server 2007.  This connector was a collaborative development effort between Project Server, VSTS and Microsoft Consulting to solve a customer need.  While this connector could have been bundled into the normal release cycle, it was felt that this need had to…


HOW TO: Setting Up RBS Security for Vendor Resources

This post comes to us from Phil Smail, our Project Server Security Program Manager.  He understands Project Server security better than anyone since he oversees the design of the implementation.  So, Phil wanted to share the solution to a fairly common problem that we experienced internally.  With that, here’s Phil. ****** I was asked a question…


SDK Updates

Jim Corbin informs us that the Project Server 2007: Getting Started with a New Platform for Developers article on MSDN has been updated and includes new information about Project documentation, using datasets in event handlers, and error checking. The Project Developer Portal is also updated, to match the recent SDK refresh.  Enjoy!   Technorati Tags: Project…