Do More Than Manage
Gord Schmidt's Ideas for Doing More with Microsoft Project Server
Summary Task

Do More Than Manage Archives

Nov 5, 2004 | First Post!
First post!
Nov 8, 2004 | Material on the Microsoft Website
Well, the Microsoft web site is an obvious place for Project Server material, but their site is so large, you always feel like you're missing something. Here's a collection of starting points for Project Server.
Nov 16, 2004 | Removing an Existing Custom Enterprise Field
So, how can you remove an unwanted Enterprise Custom Field? Essentially you have to return the definition of the field back to its original state.
Nov 26, 2004 | Hide the Outlook Integration Links within PWA
The answer for people who want to hide the links to Outlook in Project Web Access.
Nov 29, 2004 | The Next Version of Project Server
The rumour is the next version of Project Server will come out in the Summer of 2006.
Dec 5, 2004 | Don't Despair: You can do anything
For years I had a wall calendar from Despair. This month's image seems appropriate for project management.
Dec 6, 2004 | How to Modify a SharePoint Template for Project Server
The most common question I see involving SharePoint is how to modify the SharePoint template for Project Server. For example, adding a new field to the Issues in the template so that all projects have it to start.
Dec 13, 2004 | People with Websites about Microsoft Project
Here are some of the best Microsoft Project sites run by individuals that I have found.
Dec 19, 2004 | Requirements for Issues, Risks and Documents
Just to be clear, if you want to use the Issue, Risk, or Document features in Project Server 2003, you must install Windows SharePoint Services. To install Windows SharePoint Services you must install it on Windows Server 2003. (Windows 2000 is not enough.)
Dec 30, 2004 | Graphical Fields Are Not Updatable in PWA
In retrospect, this should have been obvious to me. I was working with customer that wanted a graphical indicator at the task level to appear on their time sheets. It sounded simple enough.
Dec 31, 2004 | Resolutions for 2005
I resolve to complete my timesheets in a timely manner. I resolve to estimate tasks based on something other than the best-case scenario. I resolve to lose the weight I gained over Christmas.
Jan 3, 2005 | Do Not Assign Categories or Permissions Directly to Users
The Project Server security model allows Categories and Permissions to be assigned to both Groups and Users. It is a good idea to avoid assigning things directly to Users.
Jan 10, 2005 | Resolving an Odd SharePoint Issue
A small configuration error results in the SharePoint functionality of Project Server almost working but not quite.
Jan 14, 2005 | Management Pack for Microsoft Operations Manager
Microsoft recently released a Guide to accompany the Project Server 2003 Management Pack for Microsoft Operations Manager (MOM).
Jan 18, 2005 | A Handful of Issues When Working with the MSPJGrid
I have run across several small but finicky issues when working with the MSPJGrid control.
Jan 19, 2005 | Solution Starter: Project Server 2003 to ERP Connector
Yesterday, Microsoft published a new Solution Starter on their downloads site: a Project Server 2003 to ERP Connector.
Jan 21, 2005 | Why Can't I Check-In?
Why doesn't a checked out project plan appear in the list of projects available to be checked in?
Jan 31, 2005 | SQL to return an Outline Code Value
Sometimes one needs to access Project Outline Code values using SQL. This article has an example of a stored procedure that returns a list of projects with the project name, the value of Enterprise Number 1, the value of Enterprise Text 1 and the value of Enterprise Project Outline Code 2.
Feb 7, 2005 | More Websites to Read
To aid your continuing quest for knowledge -- I'm sure you don't have enough reading to do already -- here are some more Project Server, Project and Project Management websites.
Feb 14, 2005 | I Have Run; I Have Crawled
The googlebot finally got around to spidering my entire site, so I am now able to offer a search function.
Feb 22, 2005 | Securing a PWA Custom Menu
When extending Project Server, I have often added functionality with new web pages within PWA. It is easy to add the pages to the PWA menus but it is a little less obvious how to make the menu item appear for a subset of users.
Feb 28, 2005 | Rebuilding Views and OLAP Cube to Remove Corruption
I had a customer that was having problems building the Project Server OLAP cube and also was experiencing some performance problems. It turns out both were symptoms of the same problem.
Mar 6, 2005 | Looking at the ERP Connector
Microsoft recently released a new Solution Starter: a Project Server 2003 to ERP Connector.
Mar 13, 2005 | Now less ugly
I've been doing my best for quite some time now to disavow any knowledge of any browsers other than the latest version of Internet Explorer. I think it stems from my pain as a developer trying to support multiple browsers back in the late 1990's.
Mar 21, 2005 | It Ain't Over 'til It's Over
You might think that once you complete a set of tasks under a heading like "Installation", that you would be done the installation. Not so with Project Server 2003. You still have to complete the "Post-Installation Tasks".
Mar 23, 2005 | Orders of Magnitude
Yesterday someone became the 10,000th visitor to this site.
Apr 7, 2005 | So Much For So Few
A while back I was tasked with creating an architecture for a high-availability Project Server environment. What was unusual about this deployment was that the volume was expected to be low to medium. Not surprisingly, the Microsoft documentation does not really outline a high-availability, low-volume architecture. The challenge was to design a highly available system without using a dozen servers.
Apr 13, 2005 | No One Goes Wrong with Letters
The one where non-letter characters cause problems not once, but twice.
Apr 18, 2005 | New Microsoft Download
I just noticed Microsoft posted a new download for Project Server 2003 last week. It looks promising but I hope to have more time to review it later.
May 6, 2005 | More to Read
What? You didn't want more things to read? You already have enough outstanding reading and it's stacking up? Join the club.
May 8, 2005 | New Microsoft Downloads
Microsoft has released one new Guide (Project Server 2003 Solutions Planning Guide) and updated another (Project Server 2003 Administrator's Guide).
May 18, 2005 | The Size of the Request Exceeds the Limit Allowed by the Server
Calling PDS methods can be a wonderful thing. When the quantity of data in your XML request grows large though, Project Server returns a message: The size of the request exceeds the limit allowed by the server.
May 27, 2005 | Follow the Leader
In the default installation, the Team Leader does not have the "Open Project Template" permission
Aug 10, 2005 | The Killer Feature of RSS
This blog has been quiet for a little while. My involvement in a project that had been going on for a little more than 9 months abruptly skyrocketed. It's all good.
Aug 23, 2005 | Where are the Microsoft Microsoft Project Bloggers?
Perhaps I just haven't found them yet, but there does not seem to be any bloggers at Microsoft who write about Microsoft Project or Microsoft Project Server.
Sep 13, 2005 | Question Answered
Dieter Zirkler, the Group Program Manager for Microsoft Project has started a blog about the next version of Microsoft Project.
Sep 14, 2005 | SharePoint University Forum
Dustin Miller has created a Project Server 2003 forum at his SharePoint University site.
Sep 16, 2005 | Integrating Project Server 2003 with Visual Studio 2005 Team System
There is an article entitled "Integrating Project Server 2003 with Visual Studio 2005 Team System" that was recently uploaded to GotDotNet (via Barry Gervin).
Sep 28, 2005 | Service Pack 2 Released
Microsoft has released Microsoft Project 2003 Service Pack 2 and Project Server 2003 Service Pack 2.
Sep 29, 2005 | Is It Getting Crowded In Here?
The number of Project Server blogs continues to grow.
Nov 8, 2005 | New Solution Starter: Scrum for Project 2003
Microsoft has added a new technical article to the Project 2003 library: Solution Starter: Scrum for Project 2003.
Nov 16, 2005 | Project Server 2003 Service Pack 2: Gone
Microsoft is recommending that you not deploy Service Pack 2 for the server in a production environment.
Nov 29, 2005 | More Project Blogs
I really don't want this blog to turn into a mere link blog, but when I first started trying to extend Project Server I searched the web for resources like these.
Dec 18, 2005 | Project Server 2003 Service Pack 2a
Project Server 2003 Service Pack 2a released.
Mar 4, 2006 | Marching Forth
After taking a non-Project Server job about a year ago, I have now returned to Project Server work. Hopefully this will result in more frequent postings and postings of a higher quality. (And this post only satisfies one of the requirements.)
Mar 10, 2006 | Project Server 2007 Built on Sharepoint
As PWA for Project Server 2007 is built entirely on Windows Sharepoint Services, it would follow that PS2007 will require Windows Server 2003. This means that those clients that are using servers with Windows 2000 who want the newest version of Project server will either be left behind or dragged along.
Mar 17, 2006 | Speaking at WWITPro User Group
I will be presenting at the Waterloo Wellington IT Professional User Group (WWITPro) on Monday, April 24, 2006.
May 2, 2006 | Connect to the Project Server OLAP Cube with Excel 2000
Fortunately, OLAP cubes have been around awhile and Excel 2000 can deal with them. So instead of providing the report as a Portfolio Analyzer View in PWA, we could provide the report right in an Excel 2000 spreadsheet.
May 11, 2006 | Bye Bye PDS, Bye Bye
Why, Microsoft, why? Why are you dropping PDS in Project Server 2007?
May 23, 2006 | Project Server 2007 Beta and Project 2007 SDK
Microsoft has released the next Beta of Project Server 2007, Project Professional 2007 and the Project 2007 SDK.
Jun 5, 2006 | Enterprise Project Templates and the Project Guide
The Enterprise Templates are, by their nature, static. To improve them, make them dynamic!
Aug 23, 2006 | Which Service Pack is Installed?
How to know which service pack has been applied to Project Server and to Project Professional.
Sep 1, 2006 | Paradox Server
Implementing Project Server: you should only attempt it once you've done it successfully three times.
Jan 31, 2007 | Modifying the SharePoint Template for Project Server 2007
Earlier this week I tried following the instructions provided by Microsoft for 2007 and things went just as advertised until...
Feb 5, 2007 | Outlook Integration with Project Server 2007
Microsoft has published a TechNet article on Installing the Outlook Add-In for Project Server 2007. It is very detailed but it leaves out two issues that I have come across.
Feb 12, 2007 | Email Notification Issue
One thing to check when email reminders and notifications do not work from a Microsoft Project Server installation is whether the email server allows the relaying of messages from the Project Server box.
Mar 22, 2007 | Resources Checking Into the Hotel California
Recently I came across an installation of Project Server 2007 where the security groups were being populated with users by synchronizing with Active Directory but after each synchronization a few of the resources would appear to be checked out.
Apr 1, 2007 | PWA 2007 ActiveX Controls
Project Web Access 2007 ActiveX controls are available on the server.
May 30, 2007 | Who Picked The Dates?
Who picked October 28-31 to be the dates for the next North American Microsoft Office Project Conference? Obviously not someone with kids.
Nov 29, 2007 | SP1 before Christmas -- Now there's a good present
It looks like the release date for SP1 for Office 2007 (which includes Project and Project Server) will be Tuesday, December 11, 2007.
Dec 6, 2007 | The Placeholder
The SP1 placeholder has appeared in the Office Download section of the Microsoft website.
Jan 7, 2008 | Microsoft Project Conference 2007 Presentations
You can find the presentations from the Microsoft Office Project Conference 2007 (European version) at:
Feb 19, 2008 | #ERROR for Project Custom Field Formula
A co-worker was having a problem with Project Server 2007 where any formula put into a project-level custom field would come back with #ERROR.
Mar 6, 2008 | Coming Up Next: a 64-Bit World
Windows SharePoint Services 3.0 and Office SharePoint Server 2007 are the last SharePoint Products and Technologies versions able to run on 32-bit hardware and operating systems.
May 1, 2008 | Resolving circular references in MS Project
A customer presented me with a project plan with thousands of tasks. Somewhere within that large list of tasks lurked one or more circular relationships and the error message did not help. The task to which the error message was pointing was not, as far as I could tell, part of the circular relationship.
Nov 12, 2008 | Check out Michael Jordan's Series of Presentations
You can register for the upcoming webcasts and catch up on the ones you have missed at the Microsoft Project Webcasts page.
Nov 15, 2008 | Build Generic Team from Enterprise
A solution to give project managers the rights to use the Build Team from Enterprise functionality, but only for the generic resources.
Jan 10, 2009 | Removing Tasks from My Tasks
How to remove tasks from the My Tasks page in Project Server 2007
Jan 22, 2009 | Cannot Save Schedule to Project Server
A while back I was sitting in on a client training session when a bit of a puzzler presented itself. The class had been touring around PWA and had just created their first schedules in Microsoft Project 2007. Now everyone had successfully connected to Project Server 2007 from Project Professional 2007, but only half of the class was able to save to the server.
Mar 8, 2009 | My Tasks? Surely not all of these!
As a follow-up to the posting Removing Tasks from My Tasks, I wanted to describe the tasks that can show up in a user's My Tasks list that they may not be expecting.
Mar 20, 2009 | Pivot Table Width on Cube View Admin page
The width of the Pivot table on the View design page continues to irk me.
Jun 30, 2009 | Searching for Security Gaps
Finding the users that have permissions or categories assigned directly to them.
Oct 11, 2009 | Enterprise Calendars used by Enterprise Projects
A SQL query to return a list of Enterprise Calendars used by Enterprise Projects in Project Server 2007.
Feb 25, 2010 | The resource is owner on one or more projects and cannot be deleted
When I attempted to delete the resources (Server Settings, Delete Enterprise Objects, (Delete) Resources and Users), I received the error message "The resource is owner on one or more projects and cannot be deleted".
Sep 30, 2010 | Another Approach to Risk Matrix Calculation
I just read Alexander Burton's post on entitled "Encoding a Risk Matrix in Project Server". I saw where he was going with it, but I thought there might be an easier formula to produce the same output.
Posted by Gord Schmidt on Oct 14, 2004 | Permalink