• Call now: US 1.877.226.2662   INTL +44 (0) 203.598.2917   
  • Home
  • Contact Us
 
 
Import Microsoft Project tasks into a SharePoint Tasks list using the Microsoft Project Add-In for PM Central 3.5
Browse Search
HOWTO: Import Microsoft Project tasks into a SharePoint Tasks list using the Microsoft Project Add-In for PM Central 3.5
Created on: 04-May-12. Print Article
Last Modified on: 13-May-13. Email Article
Skill Level: Intermediate.
Article has been viewed: 2345 times.
Rated: 4 out of 10 based on 4 votes.
KB.12819

APPLIES TO:

SharePoint Project Management Central R3.5 includes the Bamboo Microsoft Project Add-in. With the Add-in, you can import tasks from Microsoft Project into your PM Central project site's Tasks list. The installation package includes 32-bit and 64-bit versions of the Bamboo Microsoft Project Add-in for Microsoft Project 2010.

About This Article

This article has four sections:

Related Information

  • For information about exporting tasks from your PM Central Tasks list to Microsoft Project, read KB.12820 - How to export SharePoint tasks to Microsoft Project in PM Central 3.5.
  • For information about synchronizing tasks from Microsoft Project 2010 to SharePoint, see KB.12827 - How to synchronize tasks from Microsoft Project 2010 to the PM Central Tasks list in PM Central 3.5.
  • For a list of limitations related to this feature, see the release notes for PM Central R3.5.

Installing the Add-in Using the Setup Program

If you want to install the Bamboo Microsoft Project Add-in for Microsoft Project 2010, you can use the PM Central Setup program. To install the Add-in from the Setup program:

  1. Copy the product .exe file to the desktop machine where you want to install the Add-in. Double-click the file to extract its contents. 
  2. Double-click Setup.bat to launch the PM Central Setup program.
  3. Click the correct version of the Bamboo Microsoft Project Add-in component in the left menu and click Install.

    • If you have the 32-bit version of Microsoft Project 2010, click Microsoft Project Add-in (x32).
    • If you have the 64-bit version of Microsoft Project 2010, click Microsoft Project Add-in (x64).

    To find out which version you have, open Microsoft Project. Under File > Help, the version is listed in the About Microsoft Project section.

  4. After clicking Install, follow the prompts in the setup wizard. When the installation is complete, click Close.

    launch the setup wizard

    close the setup wizard

  5. In the Control Panel, go to Programs and Features. Verify that the Bamboo Microsoft Project Add-in is displayed in the list of programs.

    the add-in is displayed

TOP


Installing the Bamboo Microsoft Project Add-in Using the Setup.msi 

All current versions of the Bamboo Microsoft Project Add-in are included in the msi folder of the PM Central installation package.

To install the Add-in using the Setup.msi:

  1. Run the product .exe file to extract its contents. Browse to the msi subfolder. 

    choose your version of Microsoft Project 2010

  2. Copy the appropriate Setup.msi to the desktop machine where you want to install the Add-in.
    • If you have the 32-bit version of Microsoft Project 2010, copy Bamboo.MSProjectAddInSetup.x32msi.
    • If you have the 64-bit version of Microsoft Project 2010, copy Bamboo.MSProjectAddInSetup.x64.msi.

    To find out which version you have, open Microsoft Project. Under File > Help, the version is listed in the About Microsoft Project section.

    locate the version

  3. After you copy the file, double-click it to launch the setup wizard.

    launch the setup wizard

  4. Follow the prompts in the wizard to install the Add-in. Click Close after the installation is complete.

    close the setup wizard

  5. In the Control Panel, go to Programs and Features. Verify that the Bamboo Microsoft Project Add-in is displayed in the list of programs.

    the add-in is displayed

TOP


Allowing Other Users to Use the Add-in

Note: Users must have at least the SharePoint Design permission level in order to import data from Microsoft Project.

When the Add-in is installed, it will only be available in Microsoft Project for the user who performed the installation. To allow other users on the same computer to use the Add-in:

  1. Log in using a different user account than the one used to install the Add-in. Open any Microsoft application, such as Microsoft Excel. A pop-up is displayed:

    Publisher has been verified

  2. Click Install.

The other user accounts are now able to use the Bamboo Microsoft Project Add-in without having to perform the full installation.

TOP


Importing Tasks from Microsoft Project into a SharePoint Tasks List

Note: Users must have at least the SharePoint Design permission level in order to import data from Microsoft Project.

Before you import task items into a PM Central Tasks list, make sure that the Task Master Web Part and your Microsoft Project file (mpp) have similar working hours and workdays, such as Monday-Friday, 8 AM-5 PM. Remember that the Task Master Web Part does not exclude lunch hours.

To set working hours in the Task Master Web Part, navigate to your project site and select the Tasks tab. For the All Tasks, Overdue Tasks and My Tasks tabs, click the arrow on the right to edit the Web Part and open the configuration tool pane. Scroll down to Working Hours Settings and verify your Workdays and Working Hours match your Microsoft Project workdays and working hours. If you are excluding holidays in Microsoft Project, you can do the same in the Task Master Web Part. Add your holidays to a SharePoint Calendar list and specify that list in the Holiday List Settings. When you have made all required changes to the Task Master Web Part settings, click Apply and then OK.

For more information about changing Task Master Working Hours Settings and Holiday List Settings, see Configuring SharePoint Task Master in the Task Master online documentation. For more information about changing Microsoft Project working hours, see Set working times, vacations, and holidays for your project on Microsoft.com.

To import tasks into a SharePoint Tasks list:

  1. In Microsoft Project, open the .mpp file that contains the list of tasks you want to import into SharePoint. In the PM Central Add-In tab in the ribbon, click the Import to SharePoint Tasks List button.

    export to SharePoint task list

  2. Enter the URL of the SharePoint site where the destination Task list is located and enter the login information for a SharePoint account with the Design permission level on the site. Click Connect.

    enter the path

  3. In the Bamboo Microsoft Project Add-in screen, select Actions > Import Wizard.

    export wizard

  4. In the Mapping Fields window, select a mapping option:
    - Automatic Map With PM Central Tasks List will map fields from the PM Central Tasks list to Microsoft Project as shown in the table in step 5. This is the recommended option.
    - Manual Map lets you select the fields to map. If you choose this option, select the Tasks list in the Map Source Fields to SharePoint List Columns drop-down menu.
    - Create New List and Automatic Map creates a new Tasks list using the field map shown in the table in step 5. This option is not recommended for importing tasks to PM Central.

    map the fields

  5. If you elected to map fields manually, use the table below to map SharePoint fields to the Microsoft Project source field. Only the fields in the table can be mapped to import data. Click Next.

    SharePoint Field

    MS Project Source Field

    Title

    Name

    Priority

    Priority

    Status

    Status

    % Complete

    PercentComplete

    Assigned To

    ResourceNames

    Start Date

    Start

    Due Date

    Finish

    Constraint Type

    ConstraintType

    Constraint Date

    ConstraintDate

    Work

    Work

    Actual Work

    ActualWork

    Remaining Work

    RemainingWork

    Parent Task

    OutlineParent

    Predecessor Task

    Predecessor Tasks

    Milestone

    Milestone

    Cost (Enter)

    Cost

    Actual Cost (Enter)

    ActualCost

    Remaining Cost (Enter)

    RemainingCost

    Duration

    Duration

    Project Name

    Project

    WBS

    WBS

    Notes:

    • Make sure to map the SharePoint Parent Task and Predecessor Task fields to the MS Project OutlineParent and PredecessorTask fields, as show in the table above. These fields define the task outline.
    • Tasks with multiple predecessors can be imported, if your SharePoint task list is configured to support them. For more information about configuring your PM Central Tasks list to support multiple predecessors, see Configuring Multiple Predecessors in the SharePoint Task Master online documentation.
    • The Task Master Web Part does not support lag time. If you import a Microsoft Project task with a constraint that includes lag time (such as "+3days"), the lag time will be ignored.
    • The PM Central Tasks list columns Cost, Actual Cost and Remaining Cost are Calculated columns. Therefore, map the Microsoft Project columns with these names to the Tasks list columns Cost (Enter), Actual Cost (Enter) and Remaining Cost (Enter), which are Currency columns. After the import, the calculated columns will be updated to reflect the imported cost data.
       
  6. Choose a method for publishing tasks: Assignment Based or Task Based.

    • Assignment Based should be used when you want to see one assignment per task. This is recommended as the chosen method with PM Central. When importing, the Bamboo MS Project Add-in creates multiple tasks based on how many resources you assign to a particular task. For example, for Task 123 you have Resource A, Resource B and Resource C assigned. The Bamboo MS Project Add-in creates Task 123 with the same title three times and assigns each resource to each task as follows: 

      In MS Office Project:
      Task 123 < > Resource A, Resource B, Resource C

      In SharePoint List:
      Task 123 < > Resource A
      Task 123 < > Resource B
      Task 123 < > Resource C

      Note: Unlike MS Project, the Start Date, Due Date and Duration are exactly the same for all three tasks.
       
    • Task Based is not a recommended selection with PM Central. When importing, the Bamboo MS Project Add-in creates one task only and assigns the first resource to that task. For example, for Task 123 you have Resource A, Resource B and Resource C assigned. The Bamboo MS Project Add-in creates Task 123 and assigns the first resource to that task as follows:

      In MS Project:
      Task 123 < > Resource A, Resource B, Resource C

      In SharePoint List:
      Task 123 < > Resource A

    choose the publish type

  7. Map resources from Microsoft Project to SharePoint users. Select the resource from the Microsoft Project Resources list to map to the SharePoint Users & Groups list and select Add Mapping. Note that this is a one-to-one mapping only. Click Next.

    select the resource

  8. In the Import Data window, click Import. If you want to skip importing items if they already exist in the target SharePoint Tasks list, check the option Don't create duplicate items if existing. An item exists if its Title is the same as the Name in Microsoft Project.

    select import

    If the import is successful, you see the following results screen.

    results

    Below is an example of a results screen where duplicate items were skipped. A duplicate item is one where the ID and Title field match an ID and Title in the SharePoint Tasks list.

    results

    If the import is not successful, the Results window will display an error. Click Back to go back and review the mapping fields. Go through the import steps again. Your mapped fields will be available for re-use for future imports.

TOP

Related Articles
No Related Articles Available.

Article Attachments
No Attachments Available.

Related External Links
No Related Links Available.
Help Us Improve This Article
What did you think of this article?

poor 
1
2
3
4
5
6
7
8
9
10

 excellent
Tell us why you rated the content this way. (optional)
   
Approved Comments
No user comments available for this article.