Determining Project 2007 version using VBA

For those of you on the on SP2 webcast this morning, a question that we hear often around updates come up – how can I check which version of the project client everyone has? Christophe has posted a solution on his blog – http://blogs.msdn.com/chrisfie/archive/2009/04/30/how-to-check-project-2007-version-using-vba.aspx

2

VIDEO: Review of Project 2007 Task Settings and Display Administrative Options

This is the beginning of a video series targeted to Project Server Administrators.  These are being done by the Program Managers who own the features and are designed to give you some insight into the what and why of the administrative options.  Consequently, these are NOT professionally produced. Note: This video will require the Silverlight…


Understanding the Queue – Getting Queued State

If the projects you are trying to check in or publish appear to be stuck, something may be blocking the queue. The first step to resolving this issue is to look for projects in the Getting queued state. To view the jobs currently in the queue, click Server Settings on the Quick Launch in Project…

1

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)…


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…


HOWTO: Deploy Project Web Access 2007 ActiveX controls via SMS

One of our support engineers, Anil Kumar, created the following instructions for using SMS to remotely install these controls. If you are implementing Project Server 2007, your users will have to download the ActiveX controls before they can view Project Center and Resource Center.  In order to do this, you have to have the rights…


Downloadable Books Now Available

The downloadable books that correspond to content in the technical libraries on the Web have been updated for March! Office Resource Kit – http://technet2.microsoft.com/Office/en-us/library/214a899c-acdf-46a2-a089-7452e674f9dd1033.mspx Office SharePoint Server – http://technet2.microsoft.com/Office/en-us/library/6a3ad2f2-e60f-4e7b-a409-f361328fd6441033.mspx Office Project Server – http://technet2.microsoft.com/Office/en-us/library/13c4bf50-ae21-42d4-a48c-6e2de4284c561033.mspx Windows SharePoint Services – http://technet2.microsoft.com/windowsserver/WSS/en/library/decec839-73d9-4e23-b167-11e05dfc2feb1033.mspx Enjoy! Updated third link.  Thanks Mike!


Project Server Live.com Collection

This Project Server centric Live.com collection is being released as a way to keep you connected with the Project Server community, even if you don’t have Outlook 2007 or have any other RSS reader.  Since it is web-based, you can access this collection from any web connected device.  In addition to the blog feeds, this collection also contains links to commonly…


What happened to the URL at the bottom of my alerts?

They’re gone?  Yes, it’s true.  They’ve been removed in the 2007 release from all alerts and reminders.  Why?  We had several reports where providing this link to the end user to navigate to PWA was creating problems.  The base issue was which url is correct for a given user? For example, you have a system…