Microsoft Project 2010
The official blog of the Microsoft Office product development group. Learn how to manage your work effectively

  • Microsoft Project 2010

    Time Tracking in Project Server 2010


    As you might imagine we are all very excited to be able to talk about the new features coming in Project Server 2010. One of the areas where we’ve made huge investments is in Time Tracking where we’ve had a huge amount of feedback from our customers. The feedback has been immensely valuable in helping us deliver a richer experience and I hope that you’ll be as excited by the upcoming features as we are.

    Given the size of the investment we’ve made it’s is going to be hard to squeeze a full description into a single blog entry so I’m going to point out the highlights and then we’ll follow up with some more detailed posts over the next few weeks, specifically:

    1. Task Statusing and the new Grid (Pat Malatack will do the honors)

    2. Timesheets and Single Entry Mode (my next article)

    3. Approval Center for integrated approvals (Pat Malatack and Nicolae Rusan)

    4. Exchange and Outlook Integration (Chris Boyd)

    5. Why Track Time? (my final (planned) article in this series)

    We’ll also be posting on the new Administration Blog, with a deep dive into the rich Time Tracking configuration options (my 4th article); and on the Programmability Blog, with two posts: one on extending the UI (Pat’s 3rd) and the other on reading/writing data in single entry mode (my 5th).

    As we post each article I’ll update this entry with links so you can quickly navigate around all of the posts

    Finally, as ever, if you have time tracking questions feel free to post them in response to our blog entries and we’ll do our best to get you an answer.


    I’m going to talk briefly about each of the areas above to give you a taste of what is coming over the next few weeks. Before I start with the new grid I just want to point out that we’ve deliberately minimized the changes we’ve made to our back end api (the Timesheet and Statusing Web Services), so those of you with customizations can relax!

    The screenshots below are from a post Beta2 build, so you may notice one or two differences from the Beta – let us know if you can spot them!

    Task Statusing and the Grid

    One of the areas of feedback was that the move away from Project Server 2003’s ActiveX grid was a good thing (no install on to Team Member’s desktops) but that the replacement grid had some missing functionality. The good news is that we have a spiffy new grid that makes the Team Member experience richer than ever, here is a screen shot:


    Figure 1 - Tasks Page

    Pat will talk more about this in the next post but first notice the client-like ribbon, we’ve done a lot of work to make the experience more document-centric than in the past, it tested well in the usability labs and I hope you’ll find it easy as well.

    Now notice the clean left navigation menu, again we’ve reworked the grouping a little (and this isn’t the final version, we expect the “Business Intelligence” option to move soon) to balance

    In the grid itself we’ve brought back the ‘splitter bar’ (so the right “pivot” grid can be pulled over the left grid’s fields) which will really help folks with lots of columns to add to the grid but who have smaller screen resolutions make better use of their real estate.

    The left grid is also a lot smarter, with the ability to reorder columns, hide/reveal columns and do custom sorts – and the bonus is that we remember these settings across sessions for each view that you select! There are many other improvements here that I’ll leave to Pat’s post where he’ll really exercise the grid’s capabilities for you.

    Timesheets and Single Entry Mode

    The first thing you’ll notice is that we’ve moved the old “Timesheet Center” down to “Manage Timesheets”, so when you navigate to the Timesheet page we’ll create/load the timesheet for the period for the current date, allowing you to get in and out with a minimum of clicks.

    You’ll be pleased to discover that the Timesheet page has adopted the same grid technology as the Tasks page, so you get all the benefits of efficient use of screen real estate and more. The two grids behave a little differently due to the nature of the data:

    - Timesheet shows only late tasks and tasks with work planned in the period;

    - Tasks shows all of a Team Member’s tasks plus those tasks where they are the assignment owner.

    They also behave differently due to the differences in workflow between task update approval and timesheet approval. Despite these difference we hope that they will behave closely enough for the Team Member to move easily between them.

    Here is a screenshot of the Timesheet:


    Figure 2 - Timesheet Page

    Notice the Status Bar (the blue bar below the Ribbon) – this is where we tell the team Member what to do next as well as displaying some global state such as the total hours and the period range.

    The big functional change is the introduction of “Single Entry Mode” (SEM) – it can be set on or off by the Administrator and governs the integration between timesheet and project task assignment data. When SEM is on the task update data automatically flows into the Timesheet and onto the Project wherever it is edited, until such time as the timesheet is sent for final timesheet manager approval.

    If SEM is on, then changes to task assignments are sent for approval to the Task Status Manager, and you can optionally hold back timesheet approval until all task updates are approved.

    There is a lot more to talk about that I’ll cover in the Timesheet post.

    Approval Center

    We reviewed how people did approvals in Project Server 2003 and 2007 and decided that we would make the process faster if we presented all the approvals in a single dialog, this is shown below:


    Figure 3 - Approval Center

    Note that there is a Timesheet approval mixed in with task updates. Again we’re using the new grid technology for a familiar look and feel as well as the splitter bar to make the page more scalable. We didn’t get round to integrating Workflow Approvals in this release, and this will be a separate menu option for those using Demand Management workflows.

    Pat will take more time to show you around the grid and to show you the history pages in a future post.

    Exchange and Outlook Integration

    In previous releases we shipped an Outlook add-in that collected timesheet data – this was nice but had limitations including the need to install client-side code as well as functional limitations that meant that Team Members had to head to PWA to do many things.

    We’ve now focused on connecting through to Microsoft Exchange™ and for our first revision we’ve targeted basic task assignment updates – using % complete or total work/remaining work – so it’s ideal for customers with basic progress tracking requirements.

    The Team Member uses an Exchange client (Outlook or Outlook Web Access) and updates their tasks – any work entered is auto-submitted to the Task Status Manager, making this the simplest of the Time Tracking options.

    Using Import or Single Entry Mode the data will arrive in the timesheet where it can be tidied up and then sent for approval.

    Chris will talk about this more in an upcoming post.

    Why Track Time?

    This will be our final post in in the initial series where I’ll take some time to guide you through the reasons for choosing each time tracking method, with the aim of helping you be successful from the get go.

    I know that the whole team is excited about sharing the new functionality in public for the first time and we are all looking forward to your feedback on what we did well (and what we may have missed)

    Patrick Conlan
    Project Development Team, Redmond.

  • Microsoft Project 2010

    Project 2010: Project Permissions


    Other Users Need Access to My Projects

    Consider this scenario. As a project manager you create your project and now you’re ready to let others collaborate with you and so you ask yourself “how do I let others get access to my project?” By default, users who are added as resources to the project or who have tasks in the project have some level of access to it. But, these users may only have read access to the project and what about someone who is not directly associated with work on the project? How do you change permissions so that, for example, these users can read, write and publish a project?

    How to Accomplish this in Project Server 2007

    In Project 2007, giving access to another user who was not directly associated with your project would have likely meant making a request to the Project Server administrator to accomplish this task for you. To give access to your project, the administrator would have likely added the project to a security category and then added the category to your user account or to a group in which you belong. This was a lot of work and as the project manager you were at the mercy of the server administrator to do this work. What this typically meant was that there was usually a lag between the time when you wanted other users to help you with your project and when they actually got access to do so.

    So, how has Project Server 2010 made this better?

    How to Accomplish this in Project Server 2010

    In Project Server 2010, the new Project Permissions feature allows users or groups that have been granted the “Manage Basic Project Security” category permission to grant users and groups access to the projects they own. To access the Project Permissions feature do this:

    1. As a user who is a member of at least the default Project Managers group, go to the Project Center.

    2. Select the project you want to add, remove or modify permissions on.

    3. Click on the Project Permissions button on the ribbon.


    On the permissions page, if no permissions have been granted, then the ribbon and page looks like this:


    Here, you click the New button and you are taken to the Edit Project Permissions page. Now suppose your goal is to allow the following:

    1. All Project Managers can access your project.

    2. All Project Managers can open your project using Project Professional or Project Web App (PWA).

    3. All Project Managers can Save changes to your project.

    4. All Project Managers have the ability to view your project in the Project Center.

    Here are the options on the Edit Project Permissions page you’d select:


    As you can see, you can add either users or groups to your Project Permission and in this case, you’ve added the Project Managers group. You can also enable one or a combination of seven different permissions and you’ve enabled the three that will give your users the access they need. What do these permissions do and how do things work? Let’s Talk about this.

    Key Point: Project Server 2010 provides the Project Permissions feature to allow self-serve security on projects.

    Project Permissions – How it Works

    How do Project Permissions work and what do you need to know about them? Are there cases where they won’t give you what you want? Or, are there other things you need to consider? Let’s begin by looking at the basics of the Project Permissions feature.


    At a high level, Project Permissions are like mini security categories with the differences being the following:

    1. These categories can be controlled by non-security administrators (at least those in the default Project Managers group).

    2. These categories cannot be controlled by server administrators nor seen by them on the Manage Categories administrative page.

    3. They apply only to the given project.

    4. There are only seven project level permissions you can grant access to.

    5. You cannot deny any of the given permissions. You only explicitly grant access on the given permission.

    For more detailed information about security categories, please see the following article:

    Key Point: Project Permissions function like security categories.

    The Seven Permissions

    Here’s is a list of the seven available permissions along with a short description of each:



    Open the project within Project Professional or Project Web App

    This gives the user or group read access to the project from either Project Professional or PWA. The assumption is that the user or group already has rights to connect from Project Professional or PWA.

    Edit and Save the project within Project Professional or Project Web App

    This gives the user or group write access (can save changes) to the project from either Project Professional or PWA.

    Edit Project Summary Fields within Project Professional or Project Web App

    This is a variation of the previous permission. This gives a user or group the ability to change the project level properties on a project and to save them, but it does not give them rights to edit the entire project.

    Publish the project within Project Professional or Project Web App

    This gives a user or group the right to publish a project. This assumes the user can also open, edit and save a project.

    View the Project Summary in the Project Center

    This gives a user or group the ability to see a project in the Project Center view. This assumes you already have permissions to a use at least one Project Center view

    View the Project Schedule Details in Project Web App

    This allows a user or group the ability to drill into a project from the Project Center so that they can see the details of the project. The assumption is that you can go to the Project Center or you know the project’s URL so that you can see Project Schedule view.

    View the Project Site

    If a workspace has been published for the project, then this permission allows the user to get to the workspace page in order to see documents, issues, risks and other items associated with the project. It does not imply that users will be able to edit any of the entities in the various lists.

    Key Point: There are seven permissions you can set for a given project.

    Project Permissions Dependencies

    There’s a reason why the Project Permissions are listed in the order that they are. This is because in some cases, a given permission may be reliant on the previous permission in the list. For instance, let’s say you want to allow a user the ability to publish a project. To do this, the user also needs to be able to open, edit and save the project. Thus, the project permissions you would select for your user would be “Open the project in Project Professional or Project Web App”, “Edit and Save the project within Project Professional or Project Web App” and “Publish the project within Project Professional or Project Web App”. What if you selected just the “Publish the project within Project Professional or Project Web App” permission and not the others permissions? Well, your user wouldn’t be able to open the project in order to invoke the publish command and therefore, the permission would be dormant.

    Key Point: The permissions page does not enforce relationships among the permissions. You have to set any related permission a user or group may need.

    Project Permissions and other Server Permissions

    Because Project Permissions are category permissions, they are additive to other permissions a user or group may already have. It also means that if a user or group has been denied access on a given permission elsewhere, they will still be denied the permission no matter how you set up the Project Permissions on your project. An example of this is a user who has been denied the Save Project to Project Server global or category permission. In this case, even though you give your user the right to edit and save the project, they will still be denied the ability to do this because the deny permission overrides any explicit allow permission given elsewhere.

    As another example, suppose your user has been denied access to the Project Center view. This deny will override your wish to allow your user to view the project summary in the Project Center and they will still be blocked.

    Key Point: Project Permissions don’t override explicit Deny permissions set elsewhere.

    Other Considerations

    If you consider the various Project Permissions available, you’ll notice that many of them are “Project Manager” centric. That is, they represent tasks such as saving and publishing a project that a member of the project managers group would normally perform. What this implies is that Project Permissions work well for peers who are also have similar permissions. But, Project Permissions become less effective as a user’s permissions are reduced. Here’s an extreme example to illustrate this. You have a user who only has the Log On global permission. As a project manager, you create Project Permissions for one of your projects and you specify that this user can view the project in the Project Center. This user logs on to PWA, but they still don’t have access to the project. This is because they don’t have access to any Project Center views. Now, if this same user were a member of the team members group, then by-default, they would have what they need to see the project in the Project Center. So, what’s the lesson here? Setting Project Permissions doesn’t provide an automatic path in PWA or Project Professional to projects.

    Key Point: Project Permissions are great for users or groups who are peers but are less effective for users or groups who have fewer rights.

    Using Project Permissions

    There are a couple of points to understand about what you may see on the Permissions page. Here’s an example of what this page may look like after you’ve created and saved several permission sets:
    So how do you interpret what you see here? Well, this means that there are at least three different unique permission sets. On the first one, the Project Managers security group has been given the Open Project, and Save Project to Project Server permissions. On the second one, team members 11 – 14 have the View Project Summary in Project Center and the View Project Site permissions. On the last one, team member 5 has been given the View Project Summary in Project Center permission. When you edit and existing or create a new permission, you can add multiple users, but when you’re finished, each user and group will appear as a separate row in the list and each appears with their own permission set.

    If you edit multiple users or groups, and if they don’t have the same permissions, then all permissions for those users are reset and you have to select new ones. As an example, suppose you select TM11 and TM5 from the list and click Edit. On the Edit Project Permissions page, you’ll see both users, but in the permissions section, no permissions will be selected. Before you Save, you will have to select at least one permission for these two users.

    Key Point: The Permissions page shows you each individual user or group and shows the permissions for that entity. Editing users or groups with dissimilar permissions resets the permissions.


    Project Permissions in Project 2010 make it so that project managers and others can easily grant users or groups the right to perform specific actions on the projects they own. This feature reduces the Project Server administrative burden and makes it much easier for project managers to manage this chore by themselves.

  • Microsoft Project 2010

    Introducing Inactive Tasks in Project 2010


    Inactive Tasks is a powerful new feature in Microsoft Project 2010 Professional that allows you to cut tasks in your projects, while maintaining a record of these cut items. Inactive Tasks allows you to quickly and effectively:

    · Manage Scope: As project begins to go over budget or over schedule, inactive tasks should be used to manage the scope of the project and retain a record of the tasks that you cut. Later, if there becomes additional funding or more time, you can re-activate some of the inactive tasks to fill the remainder of the budget or schedule

    · Perform What-if Analysis: You may want to experiment with different combinations of adds or cuts to your project. Inactive Tasks gives you the ability to quickly test multiple options by temporarily inactivating certain parts of the project without losing the original data.

    How to Inactivate a Task

    There are several ways to inactivate a task:

    · In the Tasks tab of the Ribbon, click Inactivate


    · Right-click and choose Inactivate Task in the context menu


    · In the General tab of the Task Information dialog, click the Inactive checkbox.

    · Set the Active field to “No”

    You can also perform one of the steps listed above to re-activate an inactive task.


    In Task Sheet views, an inactive task will appear crossed-out in semi-transparent gray text. In the Gantt Chart, the task will be outlined and filled with solid white. The task will retain its original duration, start, and finish values. If you do not want your inactive tasks to appear in the task sheet views, you can filter them out. To do this, in the Views tab of the Ribbon, select the Filter “Active Tasks”.


    Inactive tasks will not appear at all in the following views:

    · Timeline

    · Team Planner

    · Network Diagram

    · Relationship Diagram

    · Calendar


    Inactive tasks will no longer be taken into account by the scheduling engine. Assignments to inactive tasks do not roll up to the task or resource summaries. Inactive task do not affect resource availability and will not be taken into account by Leveling. Baseline values that have already been taken are retained, but any new baselines taken will not include data for inactive tasks. Tasks with actuals cannot be inactivated.

    Project Server and Inactive Tasks

    Inactive tasks will appear in the Schedule WebPart on PWA, however they will be read-only. Inactive tasks are not published, so inactive task assignments will not appear on a team member’s task list.

    Tips and Tricks


    Inactivating a task that is linked to other tasks has some interesting effects because it is no longer taken into account by the scheduling engine. In a schedule from start project, if you inactivate a task with successors, the successors will be scheduled as if that link does not exist.clip_image008

    It is important to be aware of this behavior when inactivating a task in a chain of tasks. In the example below, notice how Task 3 is re-scheduled now that Task 2 is inactive.



    If you wish to retain the link between two tasks after inactivating their connecting task, you will need to add the link manually. In the example above, we would add Task 1 to Task 3’s predecessors.


    Capturing changes to the Project

    Using the Created field (that existed in Microsoft Office Project 2007) and the grouping feature, you can quickly see which tasks have been added and which have been cut since the start of your project. To do this, click “Add New Column” and type “Created”. Then in the Views tab of the Ribbon, select the Group “Active v. Inactive”.


    Summary Tasks

    To cut large sections of a project, try inactivating a summary task, which will automatically inactivate all of its subtasks.


    Later, you can re-activate the entire summary task or selected subtasks. If you activate any of the subtasks, the summary task will also automatically be re-activated.


    Risk Management/What-If Analysis

    Projects often have external dependencies that add risk to completing successfully on time. You can use inactive tasks to represent these risks. To see the effects if the risk is realized, you can activate these tasks and see the overall effect on the project. When planning, you should use inactive tasks to schedule both with and without the risks to see the range of time when the project should finish.


    · The Inactive Task feature is available in Microsoft Project Professional only. Inactive tasks will appear read-only in Microsoft Project Standard 2010.

    · The Inactive Tasks feature is not available while in 2007 compatibility mode.

    · If you save to a previous version, the inactive tasks will be deleted completely from the project plan.

  • Microsoft Project 2010

    Templates – We’ve got some, Want more?


    imageI get questions on templates fairly often so I wanted to do a quick post pointing to a previous post we did on this topic.

    Essentially, if you are new to Project or starting a project and want to see a generic plan for how others broke down the work, check out a Project template.

    To access templates in Project 2010, go to File – New – Templates section. In Project 2007, go to File – New and in the New Project pane either select On Computer or Templates on Office Online.

    Now here’s where you come in…

    We are always looking to add more templates and wanted to get feedback from you. What templates should we add?

    You can either post comments directly to this blog (note they won’t show up right away) or you can send me your thoughts by emailing

    And here’s some template trivia for you:

  • Microsoft Project 2010

    Back to Basics: Working with task date constraints


    Microsoft Office Project uses constraints to build a project's schedule. That is, each task has a certain rule applied that helps the scheduling engine figure out when the task should start or finish. There are three types of constraints: flexible, semi-flexible, and inflexible.

    · Flexible constraints don't tie a task to a specific date. They simply identify that you want the task to start as soon as possible, or as late as possible.

    · Semi-flexible constraints have a date associated with them, but they don't require the task to start or finish on the exact date. That is, you can set a task to start no earlier or later than a specific date, or finish no earlier or later than a specific date. This way, depending on the constraint you choose, the task's start or finish date can be any date, as long as it falls before or after the date you choose as part of the constraint.

    · Inflexible constraints tie a task's start or finish date to a specific date. Depending on the constraint you choose, the task must start on a specific date, or it must finish on a specific date.

    When should I set a constraint type for my tasks?

    When it comes to scheduling, the more flexibility you have in your project's dates, the better. Given that, it is often best to leave the constraints set to As Soon As Possible, if you are scheduling from the project start date, or As Late As Possible, if you are scheduling from the project finish date.

    However, there may be times when you need a certain task started or finished by a certain date, or you know that a certain task can't begin or end before a certain date. In this case, you may want to use semi-flexible constraints. For example, let's say you're planning a construction project, and you know that the lot has to be prepped for the foundation by July 21, because the concrete truck is only available to pour the foundation on July 22. It's fine if the lot is prepped prior to July 21, but it has to be completed by that date. In Project, you can set a Finish No Later Than constraint for the "Prepare lot" task, and set the date to July 21.

    Keeping with this same example, there may be times when you need to set an inflexible constraint, such as when the concrete truck is available. In this case, you can set a Must Start On constraint for the "Pour foundation" task, and set the date to July 22.

    How do constraints impact scheduling?

    Flexible constraints are ideal for project scheduling, because they enable Project to schedule tasks as closely together as possible, resulting in the project getting finished on the most efficient schedule. For example, let's say you're in the wedding cake business, and you're planning for an upcoming cake order. You have three tasks: Bake cake, Decorate cake, and Deliver cake. Each task has a duration of 1 day, and the dependencies between them are set up so that when the "Bake cake" task finishes, the "Decorate cake" task begins, and then when the "Decorate cake" task finishes, the "Deliver cake" task begins. If all three tasks use the As Soon As Possible constraint, the project is scheduled to be completed in a total of 3 days.


    Now, let's say you were out of one of the colors you'll be using to decorate the cake, so you've placed an order, but it isn't being delivered until Thursday, June 26, at the earliest. You can set a Start No Earlier Than constraint for that task, and set the date to June 26.


    You'll notice the project is now set to finish on June 27, rather than June 25. This is because of that constraint set for the "Decorate cake" task. The "Bake cake" task is still set to begin As Soon As Possible, so it begins at the project start date, June 23. However, the "Decorate cake" task can't begin until June 26, so there are a couple of days when work isn't happening on the project. In some cases, this may be just fine, but in others, that downtime may be too valuable to pass up.

    Next, let's look at how inflexible constraints impact scheduling. In this example, the couple who ordered the cake is getting married on Wednesday, June 25, so the cake has to be delivered that day. With the "Deliver cake" task set to a Must Finish On constraint of June 25, Project warns us of the scheduling conflict, and then overlaps the tasks.


    Obviously, you can't deliver an undecorated cake, so the schedule indicates that you'll need to select a different color in order to complete the project on time. Once you've selected a different color, you can set the "Decorate cake" task back to the As Soon As Possible constraint, and the schedule is back on track for an on-time finish.


    How do I set constraint types for my tasks?

    There are two common ways to set a constraint type for a task. First, you can simply select a start or finish date for your task in the Gantt Chart view, or on the Task Information dialog box. To open the Task Information dialog box, click the Project menu, and then click Task Information.


    When you manually set the start or finish date for the task, Project automatically chooses the Start No Earlier Than or Finish No Earlier Than constraint type. This way, your selected date is met, but some flexibility is maintained to make scheduling the rest of your project a little easier.

    You can also set the constraint type on the Advanced tab of the Task Information dialog box.


    You can use the Constraint type list and the Constraint date box to set a specific constraint type for your task, and tie it to a date.

    Where can I learn more about constraints?

    The following resources can help you learn more about using constraints in your project:

    · Set a start date or finish date (constraint) for a task

    · How scheduling works in Project

    · Tried-and-true techniques for shortening projects

    · View and track scheduling factors

    · Definition of Microsoft Project constraints

  • Microsoft Project 2010

    Tips and Tricks: Create Deadline Dates


    Deadline dates are handy way to alert you to problems in your schedule, but they are often overlooked. Project managers will often try to create a deadline for a task by setting a task's start date or finish date. But entering the start and finish date sets a date constraint (or restriction) on the task, which limits the flexibility of your schedule and prevents Project from automatically handling the scheduling of your project.

    If you want a task to start or finish on a certain date but want to retain the flexibility of the schedule, you can enter a deadline date. Double-click on a task, and on the Advanced tab, enter a date in the Deadline box. A green arrow will appear on your Gantt chart that marks the deadline date. And if the task doesn't finish by the deadline date, a nasty icon will appear in the Indicators column to warn you.



  • Microsoft Project 2010

    Project Server Data Migration - Cheat Sheet


    Data Migration can be a long difficult progress. In Project 2007 we made a lot of investiments to make this process a lot smoother for users.


    This post provides a list of quick steps to migrate your Project Server 2003 data into Project Server 2007. I've done it several times and it works well. If there are any failures, the log gives you detailed information for troubleshooting the issue.


    This list doesn't provide a detailed documentation of the process or all the detailed steps or how to troubleshoot problems. For that, refer to the Beta 2 documentation.


    1)    Install Project Server 2007 and provision a Project Web Access site


    2)    Backup your clean Project databases (all 4 of them). If you run into problems you can restore the databases and start over


    3)     Get your Project 2003 database ready. Restore an existing Project 2003 database onto the same SQL server as the Project Server 2007. Or create a linked server on the Project Server 2007 SQL Server (SQL Server instance->Security->Linked Servers). Link it to the Project Server 2003 SQL Server. In the security tab choose ‘be made with this security context’ and give a SQL Auth account (Eg. user: sa   password:<whatever>)


    4)    Install Project 2007 Professional and choose the “install migration tool” advanced option in setup


    5)    Change the default Migration ini file that gets installed with Project Professional (you can find it at \Program Files\Microsoft Office\Office12\ P12MIGRATION.INI.SAMPLE)  Add in the right values for Project Server 2003 databases, Project Server 2003 Linked SQL Server, Project Server 2007 PWA etc. ***Spend some time to make sure all your parameters are valid. There are detailed explanation of each parameter***


    6)     Run the migration tool from the command line:   "<drive>:\Program Files\Microsoft Office\OFFICE12\p12migrationtool.exe" -c "<location>\p12migration.ini"


    7)     Look at the command line/migration log to make sure everything is fine. If not, do corrections and re-run migration tool - it should start from where it stopped last.  If there is a irrecoverable problem, make changes in Project Server 2003, restore the clean Project Server 2007 databases and retry migration.


    8)     If you have any local windows accounts (eg. <Machine\Brad Sutton>), make sure you use PWA->edit user functionality to edit those accounts so that they are valid.


    9)     Go to the migrated PWA site as an admin, edit each migrated security category, go to the “Views – add to category” section and add the ‘My Work’ set of views to the category. If you don’t add these views, migrated users will not be able to see any views when they navigate to the ‘My work’ page.


    10)  Go to PWA->Server Settings->Operational policies->project workspace provisioning settings and choose ‘Automatically create a project workspace…” option. This is the more common option.  If you don’t want workspaces to be created automatically, you need not do this.


  • Microsoft Project 2010

    Handling Changes to the Project Start Date


    How often are you told that your project will start on date x and then it is moved to date y, maybe date z before it finally gets going?

    Now when your project start date moves, you can just update the start date in the Project Information dialog and a lot of dates will update but not all of them (ex. deadlines, constraints, tasks with actual work). If you want those to move you need to go through Move Project.


    The advantage of Move Project is that everything in the project is moved with respect to its original offset from the project start date. For example, in this project task b has a deadline 5 days into the project and task c has a constraint to start 2 days after the project’s start date.


    Now I select Move Project to update the project start date to 1/12/11.


    And everything in the updated plan has the same offset as it had before. Task b has a deadline 5 days into the project and task c has a constraint to start 2 days after the project’s start date.


    In Project 2007 and earlier, you can access this functionality on the Analysis toolbar, Adjust Dates but there are a few limitations: deadlines and tasks with non-zero percent complete aren’t moved.

  • Microsoft Project 2010

    Project 2010: Business Intelligence Overview


    This post will provide an overview of the Business Intelligence (BI) investments that were made in Microsoft Project Server 2010.

    A Brief History

    In Microsoft Office Project Server 2007, the focus for reporting was on infrastructure, where we provided the infrastructure to make accessible reporting data available.  The new reporting database allowed you to more easily query data from Project without the need for advanced SQL skills.  The OLAP Database was also enhanced to 13 new cubes to provide richer data.

    Feedback indicated a need to provide further data segmentation of OLAP data.  Since we only had the one OLAP database, it contained all data.  Administrators wanted the ability to build more targeted and smaller OLAP databases based on a particular user audience.  They also needed a way to easily customize what data was contained within the OLAP database.  For example, having cost data in an OLAP database that was used by contractors made many administrators nervous.

    For accessing the data, we also released two SQL Server Reporting Service (SSRS) Report Packs.  Feedback indicated that this was a step in the right direction, but any solution that started with “Open Visual Studio” didn’t address the core data accessibility issue.  Another issue was the people who typically need to create reports don’t usually have the requisite SQL skills or access to programming tools to write the reports for SSRS.

    Project Server 2010:  Make Data Richer and Easily Accessible

    Consequently, three major investments were made in Project Server 2010 in OLAP, the Reporting Database and in Excel integration to address these needs.

    Multiple OLAP Database Support

    Multiple OLAP Database support enables the administrator to configure, customize and provision OLAP databases based on the particular needs of the target audience.  There are two primary ways that the OLAP database can be customized.

    Filtering the Data

    In Project Server 2010, an OLAP database’s data can be filtered based on a combination of date range, Project Department and Resource Department.  This provides a way to easily filter the OLAP data to the information relevant to a given user group.   In this case, the Information Technology OLAP database will only contain project and resource data that is assigned to their department.  No more having to filter out the Marketing projects to get an IT report!


    Controlling The Data Elements Published

    The second way of customizing an OLAP database is to specify which data elements are included in a given database.   The ability to add or remove custom fields as dimensions and measures is an easy operation.  For intrinsic data such as baselines and cost data, you can exclude the data from the OLAP database by merely deselecting the box for that data type.  If you are using the new Inactive Tasks feature, you can also easily exclude this task type from the OLAP data.  Lastly, if you like handcrafted MDX, you can add your own calculated measures to the database via the user interface.


    New Data in the Reporting Database

    A number of new data elements were added to the Reporting database in this release.  Now it is possible to create report using Timesheet administrative time data and timesheet custom fields data.  This enables the user to get a much richer view of where time has logged, as well as other uses like a list of planned vacation time or planned training time.  We also added data related to the new portfolio and workflow functionality.  Lastly, if you’ve used project properties in the past in Project Professional, these are now populated into the Reporting database.

    Excel Based Reporting

    In order to make data easily accessible, we need to use a tool that most people already have and know how to use.  Since the most commonly used tool for BI data visualization is Excel, it was a natural fit for the need.  Excel also made it easier for end users to extend the solution with creating new reports or assembling reports into a dashboard.

    In enabling the use of Excel as our BI solution, we made the following investments:

    New Business Intelligence Center

    This new website is created beneath PWA to house Excel, SSRS and PerformancePoint content.  This enables a one stop shop for all BI needs. 


    Pre-Connected Excel reports

    Connecting users to their data proved to be a challenge for many.  Therefore, we provide some pre-configured and pre-connected reports which can be used as dashboard components or as report starters to build your own version.  The example below is the Timesheet Actuals report, which was built based on the needs of a customer who was using our time tracking solution in Project Server 2007.


    Pre-Connected Reporting Database Templates

    We also provide pre-connected blank templates for report creation over the Reporting database.  These templates focus on key entities within Project Server.  This makes it much easier to create quick reports on these specific items.  The templates are:

    • Dependent Projects
    • Issues
    • Project And Assignments
    • Projects And Tasks
    • Resources
    • Risks
    • Timesheet

    Automatic Pre-Connected Template Creation for OLAP Databases

    When an administrator builds a new OLAP database, Project Server 2010 will automatically create a pre-connected blank template for each of the 14 cubes.  This makes it easy for a user to create reports quickly.  These templates include:

    • OlapAssignmentNonTimephased
    • OlapAssignmentTimephased
    • OlapDeliverables
    • OlapEpmTimesheet
    • OlapIssues
    • OlapPortfolioAnalyzer
    • OlapProjectNonTimephased
    • OlapProjectSharePoint
    • OlapProjectTimesheet
    • OlapResourceNonTimephased
    • OlapResourceTimephased
    • OlapRisks
    • OlapTaskNonTimephased
    • OlapTimesheet

    In addition to the templates, an Office Data Connection library is created and pre-populated.  These connections are used by the templates and sample reports, and these remove the need for the user to know the server name, database name and SQL.  In all cases, users can copy and modify these files to extend the reporting to meet their own needs. 

    Lastly, multi-lingual support is now provided.  For each language pack installed on the server, a folder with the requisite templates for each language will be generated.

    Pulling It All Together

    In the end, you can use Excel reports to share information, either by email, SharePoint or aggregating a number of reports into a dashboard.

    In the dashboard example below, I’ve created a Project Dashboard which shows me a time phased look at actual work versus planned work for the project, as entered from My Tasks.  Below it, I can see upcoming milestones report, which has time based conditional formatting of the Finish Date to highlight overdue milestones and upcoming milestones.  With this, I can see if hours were logged against the project as planned and see what milestones are impacted if the numbers are low.


  • Microsoft Project 2010

    We're Back (and with instructions on creating a Burndown Report)!


    Hi, I'm Heather O'Cull, another program manager on the Project team.  In case you're wondering what happened to Treb, he is still here but has decided to pass the blog on to give more variety to it.  Big thanks to Treb for all the great posts and hopefully he'll still be up for doing some guest posts.

    I work more on the client and client reporting so I'll be giving the blog more of a spin in that direction.  If there is anything you would like to see posts about, please let me know.

    At the Project Conference I presented on client reporting and promised to post instructions on creating a burndown report through Visual Reports.  Something like:


    And here are the steps...

    How to Create a Burndown Report:

    1. Have the project you want to report on open.

    1. Go to Reports - Visual Reports

    2. Select New Template, Excel, Assignment Usage, and click OK.

    Your report is now being created in Excel.  Switch over to Excel.

    3. Add Time Weekly Calendar to the Row Labels section.

    4. Check Cumulative Work, Actual Work and Baseline Work.

    5. Move Values to the Column Labels box.  Your fields should be setup like this:


    6. Expand the time dimension out to the weekly level (you can really choose to any time level you'd like).

    7. Make sure subtotals aren't showing (to remove in Excel 2007 go to the Design tab, Subtotals dropdown).

    8. In the cell to the right of Baseline Work, type Remaining Actual Work, to the right of that type Remaining Planned Work, then Cumulative Actual Work, and Cumulative Baseline Work so you have the picture below.  You now need to calculate all of these values.


    10. For Cumulative Baseline Work, in J3 type =Sum($F$3:F3) and fill down the column for the number of weeks in your Project.  You nave now calculated Cumulative Baseline Work for your project.

    11. For Cumulative Actual Work, in I3 type =Sum($E$3:E3) and fill down the column like you did in the last step.

    12. For Remaining Planned Work, in H3 type =(x-J3) where x is the total for the Cumulative Baseline Work column.  Fill down the column.

    13. For Remaining Actual Work, in G3 type =(y-I3) where y is the total from the Cumulative Actual Work column.  Fill down the column.  You've now calculate all the data that you need.  If I switch to show formulas, you should have something that looks like this:


    14.  You're almost there.  You now just need to graph your data.  To do this, insert a column to the left of remaining actual work.  This is the week column.  Now paste the week numbers there so you'll have them in your graph. 

    15.  Now just select the week column you just added, remaining actual work, remaining planned work, and choose to graph them as a line graph.  You should have something like the picture at the top of the entry.

    To make this look even better you can draw a status line to help demonstrate where you are in the plan.  I also prefer to delete the values in Remaining Actual Work that are in the future to make the graph more compelling.

  • Microsoft Project 2010

    Tips and Tricks: Deleting summary tasks


    One nice thing about summary tasks is that changes to them get reflected (or “rolled down”) to their subtasks. This is fine if you want to move summary tasks around, because all the subtasks move with them. But if you want to delete a summary task, then all the subtasks (and any subtasks under those subtasks in a more complicated outline) are also deleted.

    In a simple project, you might notice the unattended deletions, but it is easy to miss this kind of mistake in a more complicated project. If a complicated project is organized using three phases, for example, deleting one phase can delete one-third of your Project’s tasks. Yikes! That’s no way to handle scope issues.

    The solution: Demote the subtasks to the same level as the summary tasks, then delete the summary task.


    To demote (or outdent) tasks in a outline:

    1   Select the tasks you want to demote.

    2   If you’re using Project 2007, on the Project menu, point to Outline, and then click Outdent.

         If you’re using Project 2010, click the Outdent  image  button on the Task tab.

    3   Delete the former summary task.

    Note   Keep in mind that if you have a complicated outline with more than two levels of indented tasks, make sure you’re starting at the lowest level subtasks before you start deleting summary tasks.

  • Microsoft Project 2010

    Visio 2010 Add-in for Microsoft Project WBS Modeler


    Good news for all the Visio enthusiasts out there! Did you know that you could visualize, edit and even create a new project plan in Microsoft Office Visio 2010 (Professional or Premium) and then export it to Microsoft Project?

    Courtesy of the Visio product team, the Visio 2010 Add-in for WBS Modeler enables effective integration between Visio and Project by offering the ability to manage project elements in a graphical view, as well as capabilities to layout a Work Breakdown Structure (WBS) in Visio.

    The Modeling process in WBS Modeler offers a wide variety of options to manipulate the WBS data and layout. Custom ribbon elements enable intuitive import and export between Visio and Project. Sibling and Child tasks can be added to existing tasks at every level within the project plan. Shape data can be defined and assigned for every element within Visio and this data binding remains in place when exported to project.

    Download the add-in today and get more out of your Visio and Project investments.

    Microsoft Visio 2010 WBS Modeler

    Microsoft Visio 2010 WBS Modeler 

  • Microsoft Project 2010

    SQL Server Reporting Services Report Pack for Project Server 2007


    This post contains a zip file attachment which is the SQL Server Reporting Services(SSRS) 2005 report pack for Project Server 2007. 

    This attachment contains 9 items total: 

    1. One overview document describing the setup for each report as well as any new custom fields/lookup tables that are required to make these reports function. 
    2. Seven PDFs which are sample output for each report
    3. One zip file of the Visual Studio project with report source code. 

    This VS project file can be used within the SSRS Business Intelligence Development Studio to deploy and modify these reports to your own needs.

    The Project Server 2007 Report Pack provides usable reports for some common requests and illustrates some of the new functionality in Microsoft Office Project Server 2007.  The Report Pack also provides report developers with sample queries for correctly retrieving data from the Project Server Reporting database.

    The Report Pack includes the following seven reports:

    1. Cost Center Availability
    2. Project Give and Get
    3. Project Portfolio Trend
    4. Project Proposals Listing
    5. Project Review
    6. Timesheet Audit
    7. Work versus Effort Audit

    All of these reports use a shared data source, which makes it easy to direct these reports to your own instance of Project Server.  I hope you find these reports useful.  If you have questions, please post as a comment to this post.


  • Microsoft Project 2010

    Finding Project Server 2010 documentation


    Documentation for Project Server 2010 is spread across three websites: TechNet,, and MSDN. Each of these sites addresses a different audience. TechNet focuses on the IT Pro, focuses on the end user, and MSDN focuses on the developer audience. In addition to these three sites, blogs are also a great source of information.

    TechNet: Planning, deployment, migration/upgrade, and more

    TechNet provides Project Server 2010 documentation that focuses on the functions performed by administrators. You can find content on planning, deployment, migration/upgrade, operations, and troubleshooting, as well as technical reference material. There are two ways content is surfaced on TechNet: TechCenters and the Library.

    Project Server 2010 TechCenter

    First, let’s look at the Project Server 2010 TechCenter. The TechCenter provides links to content that we’ve identified as most commonly-used, as well as themed Resource Centers with links to content pertaining to a specific topic.

    To browse to the Project Server 2010 TechCenter:

    1. Go to TechNet.
    2. At the bottom of the left navigation list, click More TechCenters.
    3. Under Server Products, click Project Server 2010. The Project Server 2010 TechCenter is displayed.

    Information on the Project Server 2010 TechCenter is broken out into separate sections:

    News and Highlights This section provides a list of commonly used articles.
    Resource Centers This tab, in the Project Server 2010 Resources section, includes links to separate Resource Center pages. Current Resource Centers focus on Business Intelligence, Demand Management, and Upgrade and Migration.
    Evaluate, Plan,
    Deploy, and Operate
    These tabs, in the Project Server 2010 Resources section, contain links to articles that fall into that phase of Project Server 2010 implementation.
    Latest Content This section provides links to content we’ve recently published to TechNet. You can also keep on top of recent content updates by subscribing to this RSS feed.
    From the Trenches This column, written by Chris Vandersluis of HMS Software, provides deployment planning advice directly from someone who has been deploying enterprise project management solutions to customers in the field for years. Articles from this column are also available as an RSS feed.

    The Project Server 2010 TechCenter also includes many links to other resources, including blogs, forums, downloads, and other websites containing relevant content.

    Project Server 2010 Library

    For an all-up look at Project Server 2010 content on TechNet, use the Library.

    To browse to the Project Server 2010 Library:

    1. Go to TechNet.
    2. Click Library on the tabs going across the top of the page.
    3. In the left navigation tree, expand Products and Technologies, and then expand Project Server 2010.

    Here, you can browse through all published Project Server 2010 articles on TechNet, broken down into categories. The Newly published content article (as mentioned earlier, also available as an RSS feed) is updated regularly with links to recently-published articles, and is helpful for staying on top of new content on TechNet. Another great resource for learning about new content published to TechNet is the Enterprise Project Management Content Publishing News blog (also available as an RSS feed). This blog helps to surface broader updates to content on TechNet, as well as links to individual articles.

    Providing feedback

    To provide feedback on TechNet articles, first determine which view you are using: Classic, Lightweight, or ScriptFree.


    If you are using the Classic view, in the bar just above the article, you can use a five-star rating system. When you click to provide a star rating, a box appears where you can type in comments specific to the current article.


    If you are using the Lightweight view, scroll to the bottom of the article and click Feedback. From there, you can type comments specific to the article you are viewing.


    If you are using the ScriptFree view, click Feedback in the top-right portion of the article. This takes you to the MSDN, TechNet, and Expression Library Feedback Forum, where you can provide feedback on the script-free version of an article.

    image End-user content for Project Web App provides documentation for Project Web App users. You can find content on creating and working with projects, managing portfolios, submitting and approving time and status, reporting on projects, setting up Project Web App, and more.

    To browse to Project Server 2010 content on

    1. Go to
    2. Click Support on the tabs going across the top of the page.
    3. In the Current Product Help box on the top right portion of the page, click Project Server.
      The Project Server Help and How-To page is displayed.

    Here, you can see links to content in the main graphic at the top of the page, as well as in the lists below the graphic. These lists help to surface some of the more commonly-used topics within the Project Server 2010 content on

    For the full Project Server 2010 content set on, click through the categories listed in the Project Server 2010 box, on the top right portion of the page. Within a category, use the links on the left navigation list to browse through subcategories, or click Show all categories to return to the full list of top-level categories.

    Providing feedback

    To provide feedback on articles, scroll to the bottom of the article, and then use the buttons to answer “Did this article help you?”


    Once you’ve clicked the Yes, No, or Not what I was looking for button, you can provide comments specific to the article you’re viewing.


    MSDN: Project Server 2010 Developer Content

    Developer content for Project Server 2010, including the Project 2010 Software Development Kit (SDK) and the Visual Basic for Applications (VBA) Developer Reference, is available on MSDN. You can find API documentation, sample code, and other supporting information. Much like TechNet, there are two ways content is surfaced on MSDN: Developer Centers and the Library. MSDN also has other resources you may find helpful.

    Project 2010 Developer Center

    The quickest way to get to the Project Developer Center is to type

    To browse to the Project 2010 Developer Center on MSDN:

    1. Go to MSDN.
    2. In the gray box at the bottom of the page, under Core destinations, click Office Developer Center.
    3. Click Products on the tabs going across the top of the page.
    4. Under Project, click Project 2010.
      The Project 2010 Developer Center is displayed.

    Similar to TechNet, the Project 2010 Developer Center provides links to content that we’ve identified as most commonly-used, as well as links to links to other resources, including blogs, forums, downloads, and other websites containing relevant content. Note that the Project 2010 Developer Center includes information for both Project Server 2010 and the Project 2010 client application. You can subscribe to an RSS feed for newly-published content across all Office applications, and then filter for Project Server.

    Project 2010 Library

    For an all-up look at Project Server 2010 content on MSDN, use the Library.

    To browse to the Project 2010 Library:

    1. Go to MSDN.
    2. Click Library on the tabs going across the top of the page.
    3. In the left navigation tree, expand Office Development, then expand Microsoft Office 2010, and then expand Project 2010.

    Here, you can browse through the Project 2010 VBA Developer Reference and the SDK Documentation to find the relevant Project Server 2010 content. There is a link on the Project Developer Center home page to download the Project 2010 SDK, which contains documentation, 11 code samples, IntelliSense XML files for Web Services, VBA Help, schema references, and more.

    Other useful MSDN resources

    In addition to the Project 2010 Developer Center and the Project 2010 Library, MSDN has several other resources you may find helpful:

    • MSDN Community Content Wiki. If you are using the Classic view, you can also annotate Project topics in the MSDN Library using the MSDN Community Content Wiki. For example, you could add a tip or remark that you think other developers might find useful. This is different from providing feedback about a topic; you should use MSDN Feedback to report issues. The Project developer documentation team regularly monitors and responds to feedback, and we republish topics based on customer feedback. See “Providing feedback,” below, for more information.
    • MSDN Forums. You can also post a question to the Project 2010 MSDN Forums. There are three Project 2010 forums, including Project Customization and Programming.
    • Context-Sensitive Help and IntelliSense in Visual Studio. If you are using Visual Studio, you can also get context-sensitive Help by pressing F1 in your code. By default, Visual Studio 2010 uses online Help as its primary source. You can change this setting by clicking Help, and then clicking Manage Help Settings. The Welcome Guide of the SDK, which is accessible through the Start Menu shortcut by clicking Start > All Programs > Microsoft SDKs > Project 2010 SDK, includes detailed information about installing and using the updated IntelliSense XML files included in the download. Once the files have been copied to the right directory, you can get tooltips, auto-complete, and API descriptions in the Visual Studio integrated development environment (IDE) as you type and browse through code.

    Providing feedback

    To provide feedback on MSDN articles, first determine which view you are using: Classic, Lightweight, or ScriptFree.


    If you are using the Classic view, in the bar just above the article, you can use a five-star rating system. When you click to provide a star rating, a box appears where you can type in comments specific to the current article.


    If you are using the Lightweight view, scroll to the bottom of the article and click Feedback. From there, you can type comments specific to the article you are viewing.


    If you are using the ScriptFree view, click Feedback in the top-right portion of the article. This takes you to the MSDN, TechNet, and Expression Library Feedback Forum, where you can provide feedback on the script-free version of an article.


    Blogs: A great source for all kinds of information

    There are many, many blogs out there with Project Server, or enterprise project management, as a focus. Here are just a few Microsoft blogs worth checking out:

  • Microsoft Project 2010

    Change the font and color of text on the Gantt chart


    Many people know how to use bar styles to change the color of the bars on the right side Gantt chart. But I bet you don’t know how to use text styles to change the text on the left side of the Gantt Chart, and other sheet-like views. Let’s take a look at this.

    Here’s what my project looks like before applying text styles.


    And here’s what my project looks like after applying a green font, underlined, for milestones, with red for critical subtasks.                                                  


    A big difference. To apply the text styles:

    1. On the ribbon, click the Format tab.
    2. Click Text Styles


      Note   If you’re still using Project 2007, click Text Styles on the Format menu.    
    3. In the Text Styles dialog box, select the type of item you want to format, and then use the other options in the dialog box to suit your fancy. In the picture below, “Milestones Tasks” are highlighted.


    Now, don’t get carried away.  More than two colors will invite negative reactions from others who are looking at your project. You don’t want them scratching the eyeballs trying to figure out what’s important and what’s not.

  • Microsoft Project 2010

    Video Walkthrough of the Out of the Box Sample Proposal Workflow


    Out of the box, Project Server 2010 comes with a “Sample Workflow” which highlights many of the new features found within Project Server 2010 Workflows. The Sample Workflow was designed to help our customers not only just understand what our new workflows can do, but also give customers and partners the initial building blocks to create their customized workflows.

    The below videos is a step by step walk through of our Sample Proposal. It will show the end user experience, and highlight the different areas an admin must setup in order for this workflow to fully function.

    In addition to the posted videos, attached to this blog you will also find the Visio Diagram of the workflow. Please feel free to use this diagram to assist in traversing the workflow, and as a template for when you are creating your own custom workflow Visio diagrams.

    The source code for the Sample Proposal Workflow has been posted within our SDKs.  Please download the SDK to get access to the source code.  Once you have downloaded the source code, you should be able to modify the workflow logic and upload your own modified version of this sample proposal.

    If you have any questions, please leave them in the comments of this blog.

    Thank you,

    Sam Chung

  • Microsoft Project 2010

    Project 2010: Introducing Web Based Project Editing


    Have you ever wanted to make edits to a project plan far away from your desktop installation of Project? Perhaps you were in a meeting and pulled up Project Web Access to show project status but hoped to capture updates directly in PWA as the meeting progressed. Maybe you have multiple stakeholders on a plan who want the ability to add tasks even if they aren’t responsible for the entire project schedule and don’t have Project on their desktop.

    Hi, I’m Pat Malatack and today I’ll be introducing you to a new feature in Project Server 2010, web based project editing in Project Web Access (PWA). With this feature, these requests and many others will become a distant memory. Project Server 2010 enables the ability to create projects, edit the plan, assign resources to tasks, and publish the plan, all from the comfort and convenience of your browser. In Project Server 2010 you can expect to edit projects large and small on the server. Additionally, you can move effortlessly back and forth between editing projects in the browser and in the desktop client. This allows users to have the convenience of a browser based project editing solution together with the power of the desktop client.

    Now I know what you’re thinking “Do I need some fancy plugin for this?”, “How does it work?”, “How well does it scale?”, and “How does it differ from Project Professional?” Let’s answer each one of these questions and hopefully many more today.


    Do I need some sort of fancy plugin for this? Not at all! Web based project editing has been implemented in JavaScript and HTML so all you need is a browser, no ActiveX controls or any other plugin required. Yep you read correctly NO ACTIVEX!!!!!!!

    How does it work? Performing edits to projects in your browser is simple and easy to use. In PWA you can expect to find many of the same great features you are familiar with in the Project desktop. Although we don’t have time in this blog post to walk through each and every feature, I will walk you through a few by starting off with a brand new project plan that I have just created in the web as shown below.


    The first thing to take note of here is the user interface. There are 4 core interface elements that should capture your eye. First, you will see the Fluent User Interface at the top of the page (expanded in the screenshot below). Here you can manipulate the project plan. You are able to perform actions like linking, indenting and marking tasks as complete.


    Second, you will see a blue information bar. This “status bar” displays information about the current project plan you are working on. In the example below you will see the project was checked out on 10/28 and that I am viewing a “Draft” of the current project plan.


    Next you will see a grid. The grid is composed of two panes (our final two core UI elements). The left-most pane we will refer to as the “grid pane”. The grid pane is where the end users will complete actions on task level information. Users will be able to edit task names, assign resources and enter various project fields like start date & end date from this pane. As task information is entered we will begin to see a Gantt chart taking shape in the right half of the grid, we will refer to this as the “Gantt pane”. The grid, complete with both panes, is pictured below.


    For this particular example I will build a project plan for the launch of a new product. I will begin by defining some high level phases. In order to create each task I will start by typing a task name in the empty row on screen with the clip_image008 indicator.


    When I press ENTER on the keyboard or move to another cell the “new row”, as indicated with the clip_image008[1] icon, will move down one row, giving me another location with which to enter a new task.


    After a few more edits I begin to see the high-level structure of the plan taking shape. Unfortunately, I have made a mistake while entering the start date of one of my phases. Thankfully PWA has detected this typo and informed me of this error while continuing to allow me to make edits.


    Once I get a free moment I can click on the error. PWA will do its best to inform me of the problem and allow me to resolve the issue. In this particular case I have entered a value that is not a date for a date field.


    After resolving the typo I hope to insert some sub tasks in Phase 1. At this stage in the project, Phase 1 is the only phase I have sufficient information for which to plan. All this takes is a simple press on the “Insert” Button in the ribbon or the “Insert” key on my keyboard.


    After inserting each of my tasks I have a plan that looks something like this.


    Next I want to indent the newly inserted tasks under Phase 1. To do this I will click in the “row header” region on the far left of the grid pane. I will select each of the rows and press indent in the ribbon (or Alt+Shift+Right on my keyboard if I prefer to use the Keyboard Shortcut Support). This demonstrates the use of full Task Hierarchy and Indent/Outdent support in the browser.


    Now that I have created a summary task I want to establish dependencies on each of the subtasks. To do this I will select all of the subtasks and link them. In the screen shot below you will note that the tasks have been linked (which can be seen visually in the Gantt chart) but they have not been scheduled. The behavior is similar to that of Project Desktop if “calculate project after each edit” is turned off.


    Finally we will press calculate which is located in the ribbon and the tasks dates will be updated. You should also note in this picture that the items that were changed as a result of the calculate operation are highlighted in blue. This demonstrates the use of Change Highlighting in the browser.


    Some other notable features to call out here are support for Multi-Level Undo as well as Cut/Copy & Paste right in your browser (both are shown in the ribbon screen shot earlier in this post). If I had made a mistake in anyone of these edits and wanted to undo it or I wanted add a list of work items copied somewhere like Excel, I would effortlessly be able to do this in PWA.

    Now that I have some tasks created and scheduled I want to go ahead and make some resource assignments, before I do this though I want the resource column to be placed right next to the task name to make assignments easier to see visually. To do this in PWA I simply drag the resource column by clicking down on the column header and dragging with my mouse. A “ghost image” will appear so that a user can see where my column will be positioned, demonstrating the intuitiveness of Flexible View Manipulation in PWA.


    Together with my colleague Heather I will be “Identifying the Launch Team” as well as “Defining Launch Goals”. This demonstrates browser based support for Multi-Resource Assignment. Heather will be responsible for “Determining Sales Objectives” and I will be handling the other tasks defined. Making the assignments is depicted below.


    A few more items of interest to mention in PWA are high-fidelity (and colorful) Gantt charts, support for Grouping (as you would expect from Project’s desktop client), and support for User Controlled Scheduling in the browser.

    How well does is scale? Editing projects from small to the very large is supported in Project Server 2010. There are no explicit size limits for browser based editing. Coming soon – a video with a 6,000+ line project.

    How does it differ from Project Professional?

    Project Professional will continue to be your one stop shop for great project planning/tracking features like baselining, leveling and task warnings and suggestions as well as some of the new 2010 features like Timeline View and Team Planner. Features like defining work breakdown structures will only be available in the desktop client, which will continue to be the premium project editing experience. For basic project plan editing and manipulation though PWA will serve as a great compliment to Project Professional for traditional Project Managers and help to expand the use of Project to people within your organization whom traditionally did not use Project Professional.

    To recap here are just some of the features you can expect with web based editing in Project Server 2010.

    Rapid entry

    Multi-Resource Assignment
    Asynchronous editing, validation & error handling Fluent User Interface
    Multi-Level Undo User Controlled Scheduling
    Change Highlighting Keyboard Shortcut Support
    Cut/Copy/Paste Flexible View Manipulation
    Task Hierarchy High Fidelity Gantt Charts
    Grouping Support for Large Projects
    Indenting/Outdenting And many more…

    Remember everything demonstrated in today’s post was done in a browser and is included as part of Project Server 2010. We hope you are as excited for web based project editing as we are and be sure to download the beta when it is made available in November.

  • Microsoft Project 2010

    Tracking changes in Project 2007


    I apologize to readers for the delay in posting a new topic. The last few weeks have been busy for us in the product team as we start to get our Beta 2 build completed. The release will be in late spring and I’ll have a dedicated post on how that will work, for those interested in learning more. I have received a couple of questions about it but the details are still not finalized.


    This week I would like to show you two new features we have introduced in Project 2007 that will improve Project Managers’ productivity by giving you the ability to efficiently see how changes you make effect the rest of the project plan. In addition, Project 2007 gives you the ability to see what’s driving a task. That is, for example, if you want to understand why a task has pushed out the schedule, you easily can.


    Change Highlighting

    Project 2007 provides you with an option to view how the changes you make to the schedule impact the rest of the project. Change Highlighting illustrates all that is impacted by your change.


    In the example below, I am using one of the new Project templates we are shipping with Project 2007, “Strategic Merger or Acquisition Evaluation”.


    I changed task 17 ‘Define Selection Scenario…’ to have duration of ‘4 days’. After changing the duration value, everything that also changed as a result of my extension of the task duration got highlighted: the finish date for my task, the following task that dependent on task 17, the inner and outer milestone summary tasks.

    (Click to enlarge)

    This feature gives you incredible power to validate the change and helps you answer questions that were harder to answer before: Did this change cause a schedule slip? What other tasks will get impacted by the change? Should I make the change?


    The highlighting will persist until you make another change or save the project. Since Project 2007 offers multiple levels of undo, you can use both features combined to do many “What-if” scenario analysis with your projects.


    Task Drivers

    Another question you may be faced with when reviewing your project schedule may be what is causing my task to be scheduled when it is as opposed to on an ealier date? This can be especially problematic if you are managing a project with thousands of tasks. You may end up spending hours trying to trace back the dependencies, review resource availability, calendars etc. Project 2007 now does the work for you! When you select a task, you can select to view the Task Drivers pane and the information that you need to find out what is driving that task is displayed to you on a pane on the left of the project. You can easily turn on this pane by selecting the ‘Task Driver’ option on the Project menu (new in Project 2007). 


    I am using the same project I used above. Once I opened the ‘Task Driver’ pane for task 17, I get all the information I need to see “what are the factors causing the task to start when it is”. In addition to predecessor tasks, you also get a link to the calendar of the resource(s) assigned to the task. This is very helpful if your task is being delayed due to the resource being on vacation.

    (Click to enlarge)

    Both Change Highlighting and Task Drivers will be the first couple of new features you will immediately notice in Project 2007 and that I personally have become dependant on for my projects.


    The screen shots I used are from our latest build but since the product is still the Beta phase there may be some changes to the final version.

  • Microsoft Project 2010

    Microsoft Project Conference 2012 Session Recordings Are Live!


    Today we're excited to share all session recordings from Project Conference 2012 in Phoenix, Arizona with the greater Project community. Over 1250 people from 44 countries made the trip--75% for the very first time. The week featured 94 handpicked sessions with 20 delivered by customers eager to share their experiences. Many sessions were standing room only and from the evaluations, many only wished they could have attended more of them. Zach Heisinger, first time attendee, tells us he's already looking forward to the next Project Conference. His only complaint? "I wish certain sessions could be offered more than once during the conference. That way I wouldn’t have to pick one great session over another great session." So, we're excited to share these recordings with all of you as it represents a collection of the best content out there from our customers, partners, and industry leaders.

    This year's Conference focused on Project 2010 momentum and offered attendees both networking as well as training opportunities. We've said before, 2010 marks the biggest release in over a decade, but product innovation didn't end with its release. You'll find 87 recordings totaling over 100 hours of content. We suggest getting started by viewing both keynotes, first from Microsoft Office Division CVP Kirk Koenigsbauer and then from Microsoft Project GM Ludovic Hauduc. Then jump into some of the top rated sessions at the conference:

    1. Deliver SharePoint Success: Key Steps to Reap the Business Benefits
    2. Tips, Tricks, and Best Practices for Using Project Server 2010
    3. The painters, the policemen and the Pope...understanding task movement in Microsoft Project 2010
    4. Take Your Project Reporting To the Next Level: Dashboards and Other Tools
    5. YJTJ (Your Job Tool’s Job) ™ – Working in Concert with Microsoft Project
    6. Unleashing the Value of Earned Value: Applying Schedule and Cost Controls to Measure Project Performance
    7. Turning Project Data into Real World Reports: An Overview of Business Intelligence Options
    8. Leveraging Project 2010 with Office 365 for Project Management Success
    9. Be Loved By Your Development Teams: Using the Team Foundation Server – Project Server Connector
    10. Microsoft Project 2010 Desktop Overview

    From all the social media buzz (2.5 million Twitter impressions) and excitement, the Project community looks to be growing stronger and stronger each day. None of this would have been possible without each of you and we're thankful for the opportunity to have met many of you in person. A special thank you to those who were able to join us this year. Hope you enjoyed all the parties and the warm weather. We can't wait for the next one! For those who couldn't make the trip this year, we hope you find the sessions informative and enough of a reason the join us next time. Let us know what you think in the comments or via Facebook/Twitter.

    You can view all sessions on the Microsoft Project Showcase Channel

  • Microsoft Project 2010

    Back to Basics: Let's talk about the critical path…


    The critical path…sounds pretty intimidating doesn't it? Like some secret passageway to getting your project done on time that only highly experienced project managers could ever possibly identify. And certainly those experienced project managers are the only ones who could actually stick to the path and get things done as planned.

    It's not really as arcane as all that. The critical path is simply the series of tasks that controls the start and finish date of the project. When the last task in the critical path is complete, the project is also complete. Not too terribly complicated.

    Here's an example. Let's say I have three tasks:

    · Build forms (2 days)

    · Pour foundation (1 day)

    · Remove forms (2 days)

    Each of these tasks depends on the one before it. I can't pour the foundation until the forms are built, and I can't remove the forms until I've poured the foundation. I can set these relationships up in Project using dependencies. (Want to read more about this? Check out Create task dependencies within your project.)

    So now, with the dependencies set up and my project start date set to next Monday, my schedule looks like this:


    [Insert drumroll here.] And there you have it, that's your critical path for this project. Nothing fancy or overly complicated, just a series of tasks that determine the start and finish date for the project.

    What's that? You say you want to see something a little more complicated? Alright, let's say you have another task, Build walls, that can't start until your Build forms task is completed. (Maybe you're using the same resources on both tasks or something, I don't know, just run with me here.) The Build walls task will take two days. Let's see what this looks like in Project:


    Now let's look closely at this. Has the critical path changed? There are four tasks now, but the added fourth task currently has no bearing on when the project starts or finishes. That means that those first three tasks are still the only tasks that make up the critical path. You still only need to focus on getting those three tasks done on time in order to finish your project on time.

    That gives you the very basic understanding of what a critical path is, but there are a ton of resources out there to help you gain a more thorough understanding. Here are just a few:

    · Manage your project's critical path

    · Show the critical path

    · See what's driving the project finish date (critical path)

    · Change when a task becomes critical

  • Microsoft Project 2010

    Announcing Microsoft Project 2010 Technical Preview


    Today, we’re announcing that Microsoft Project 2010 has reached the Technical Preview engineering milestone.  The Project team is running a limited, invitation only Technical Preview program. While we’re not sharing Project 2010 details at this point, we did want to give our customers and partners a sneak peek of Project 2010!

    What is Project 2010?Project 2010 Investment Areas

    Project 2010 builds on the Project 2007 foundation to provide an end-to-end work management platform. The key investment areas are targeted at letting you choose the right tools that can evolve with you:

    • Enhance user experience and appeal
      • Fluent user interface
      • User controlled scheduling
      • Powerful new views
      • Web-based project editing
    • Improve execution with effective collaboration
      • Integration with SharePoint Server 2010
      • Richer workgroup collaboration
      • Enhanced time/status tracking
    • Unify project and portfolio management
      • Common user experience through full PPM lifecycle
      • Improved demand management
      • Better reporting and BI
    • Simplify deployment and extend interoperability
      • Microsoft Exchange integration
      • 64-bit compatibility of client and server
      • No ActiveX dependency

    How can I learn more about Project 2010?

    Attend the Project Conference on September 14-17 in Phoenix, AZ! Project Conference 2009 is the biggest public worldwide disclosure event and the best conference to attend to get in-depth, hands-on technical knowledge and training with Project 2010. Learn how the investment in Project 2010 will continue to move your business forward tomorrow and get the most out of your current investment with Project 2007 today.

  • Microsoft Project 2010

    Installing Project Server 2007 Beta 2 Technical Refresh


    [I am updating this post with more specific information - including webcast tomorrow]


    How to install Project Server 2007 Beta 2 Technical Refresh (Beta 2 TR) ?


    Important:  Read this message carefully and completely before you apply the Beta 2 TR Update/Patch


    The Beta 2 Technical Refresh release is an incremental revision to Beta 2 – it is applied as an “Update” or a “Patch” on top of a Beta 2 installation.  So, there is no “full installation” of Project Server 2007 Beta 2 TR.  To install Beta 2 TR, you need to first install Project Server 2007 Beta 2 and then install the Beta 2 TR Update/Patch. If you already have a Beta 2 installation, you can just install the Beta 2 TR Update/Patch.  There are 3 main installation scenarios:


    1. A new installation of Project Server 2007 Beta 2 TR:  This is for new users who do not have a previous Beta installation of Project Server 2007. This involves the following general steps:
      1. Install the Beta 2 version of Project Server 2007.
      2. Install the Windows SharePoint Services 2007 Beta 2 TR Update/Patch.
      3. Install the Project Server 2007 Beta 2 Technical Refresh Update/Patch.


    1. Upgrading from Project Server 2007 Beta 2 without  data upgrade: This is for customers who were in the early stages of Beta 2 evaluation.  They may have created some sample projects and timesheet entries, but data in Beta 2 is not important enough to carry over to Beta 2 Technical Refresh.  This involves the following general steps:
      1. Install the Windows SharePoint Services 2007 Beta 2 TR Update/Patch.
      2. Install the Project Server Beta 2 Technical Refresh Update/Patch. 


    1. Upgrading from Project Server 2007 Beta 2 with data upgrade:  This is for customers who may have created a lot of data on Project Server 2007 Beta 2 for a pilot or a proof of concept. This involves the following general steps:
      1. Backup data from the Project Server 2007 Beta 2 installation (this is not just a database backup, it is a set of manual steps. Detailed instructions provided in the documentation).
      2. Install the Windows SharePoint Services 2007 Beta 2 TR Update/Patch.
      3. Install the Project Server Beta 2 Technical Refresh Update/Patch. 
      4. Restore data on to the Project Server 2007 Beta 2 TR installation.


    Important things to note:

    1. Once you install the update/patch, it cannot be rolled back.
    2. If you plan to install the Project Beta 2 Technical Refresh update/patch onto a Beta 2 Server containing provisioned Project Web Access site(s), you need to delete those sites before the update/patch is applied.  
    3. Project Server 2007 Beta 2 and Project Server 2007 Beta 2 TR cannot exist on the same computer. This is not supported.
    4. Installing Office Project Server 2007 Beta 2 TR and Office SharePoint Server 2007 Beta 2 TR on the same computer is not supported. If you have Office Project Server 2007 Beta 2 and Office SharePoint Server 2007 Beta 2 on the same computer, and if you plan on upgrading and using the same computer, you will need to uninstall both and then install either Office Project Server 2007 Beta 2 TR or Office SharePoint Server 2007 Beta 2 TR.


    Data Upgrade:

    “Data upgrade” from Project Server 2007 Beta 2  to Beta 2 TR is a manual process.  Detailed step-by-step instructions, sample code, macros are available in the detailed documentation to help make your data upgrade a success.  Read the documentation carefully before you attempt the data upgrade.


    Detailed Documentation:

    Detailed step-by-step deployment instructions can be found at:   (content would be available around Beta 2 TR general availability). Meanwhile, ask your Microsoft contact to get a draft copy of the detailed instructions.




    When ?

    Sep 13th, Wednesday, 9 AM to 10 AM PST (Pacific Standard Time)

    Meeting Title

    How to install Project Server 2007 Beta 2 Technical Refresh

    Webcast link If you cannot click the meeting link above, or it does not work, please do the following:

         Browse to:

         Type your name

         Type the Meeting ID as: PublicWebcast

         Type the Password as: 736410

    Audio information

    1-866-500-6738 or 203-480-8000. Participant code: 852710#

    Who will present ?

    Microsoft Project Group members from Redmond, USA.

    Main objective

    To give an overview of how to install Project Server 2007 Beta2 TR and answer any questions you may have.

    Can I attend ?

    Yes. This is a Public Webcast – anyone can attend.


    You can also start reading more from the Office Project Server 2007 Deployment Guide.

  • Microsoft Project 2010

    Project 2010 Service Pack Update


    Some of you may have seen the recent Office blog post from the Microsoft Office sustained engineering team.  In that post, the Office and SharePoint teams disclosed that Service Pack 1 (SP1) will include some minor updates and should be expected in the usual time frame of 12 to 18 months after the products launched.

    I wanted to let readers of this blog know that Project 2010 SP1 will also be a part of the same Service Pack.  In addition to some minor updates, SP1 will contain a rollup of the updates we post every two months here.  Our guidance is the same as the Office and SharePoint teams, those customers thinking of deploying Project 2010 should not wait for SP1 and should deploy now and see all the great benefits that customers like Marquette University and Amdocs are seeing.  You can see even more Project 2010 case studies here.

    To get you started on Project 2010, check out the Project Server home page.

    Arpan Shah
    Director, Microsoft Project

  • Microsoft Project 2010

    Opening Project MPP files from different versions


    Here’s the problem. You’ve created a project schedule, and now you want to send it to a team mate for review. Your team mate is having trouble opening and viewing the project because she has a version on Project earlier than yours. At this point, you have a few options, depending on who has which version of what:

    Which Project version are you using?

    Which file version are you trying to open?

    Things to keep in mind

    Project 2007

    Project 2010

    No converter is available. If you received a Project 2010 file that you want to open using Project 2007, ask the person who sent the file to first save it to the Project 2007 file format.

    Alternately, you can install the trial version of Project 2010 and then view the file, or save it to the Project 2007 file format.

    Project 2003

    Project 2007 or Project 2010

    There are two possibilities here.

    • If you are using Project 2003 with SP3, project files from later versions of Project can be opened read-only. Download Microsoft Office Project 2003 Service Pack 3.
    • If you are using Project 2003 without SP3, there is no converter available. Upgrade to Project 2003 with SP3, or ask the person who sent the Project 2007 or later file to save the file first in the Project 2000-2003 file format.

    Project 2000 or Project 2002

    Project 2007 or Project 2010

    No converter is available. Ask the person who sent the Project 2007 or later file to save the file first in the Project 2000-2003 file format.

    Project 98

    Project 2000 and later versions

    No converter is available. Consider upgrading to the latest version of Project, or install the trial version of Project 2010 to try out Project’s enhanced functionality.

    Alternately, ask the person who sent the Project 2000-2003 file to save the file first in the Project 98 file format.

    Note Project 2007 and later versions of Project do not have the ability to save to the Project 98 file format.

    That’s a nice table, but how do I tell which version of Project I have?

    • For Project versions 98 through Project 2007, click the Help menu, and then click About Microsoft Office Project.
    • For Project version 2010, click the File tab, then click Help.

    Will I lose my data?

    In nearly all cases, no. There can be a few exceptions, however. if you open a Project file created from a later version and save it the file to your current version, you can lose data or formatting in areas where the later versions contains enhanced functionality.

    For example, new fields and custom fields Information within new fields from later versions of Project, or any formulas relying on new fields, will be lost. New options that are set on custom fields created in the later version of Project will be lost.

    Another example. New calendar exceptions that were added to project and resource calendar functionality (such as monthly exceptions, yearly exceptions, and those with arbitrary dates) will be lost.

  • Microsoft Project 2010

    Tips and Tricks: Tweak the Timescale


    You may not be able to speed up time in your project, but you can speed up the timescale-that is, how you use the timescale in views like the Gantt chart. If you've spent any time in Project, you may have wasted a lot of effort either scrolling the timescale or changing its time units. Fiddling with dialog boxes and scroll bars to get the timescale perfect gets old in a hurry.

    Fortunately, there are a few keyboard shortcuts that will dramatically speed up your timescale tweaking.

    Here is a list of my favorites:

    Scroll the timescale left or right              


    Show smaller time units on the timescale

    CTRL +  / (slash on the numeric keypad)

    Show larger time units on the timescale

    CTRL + * (asterisk on the numeric keypad)

    Scroll to a task's Gantt bar

    CTRL + SHIFT + F5

    . . . And if you like these tips, let us know in the Comments section. We'll start posting more of them.

Page 2 of 12 (287 items) 12345»