US 1.877.212326.2662
Browse Search
HOWTO: Use the Bamboo Microsoft Project Add-in With PM Central R1.8 or Newer for SharePoint 2010: Exporting Tasks From SharePoint Tasks Lists or the Portfolio Site's Project Task List to Microsoft Office Project 2010
Created on: 16-Jul-10. Print Article
Last Modified on: 24-Jan-11. Email Article
Skill Level: Intermediate.
Article has been viewed: 13635 times.
Rated: 5 out of 10 based on 4 votes.
KB.12506
APPLIES TO:
  • PM Central
  • SharePoint Foundation 2010 and SharePoint Server 2010

SharePoint Project Management Central R1.8 or newer for SharePoint 2010 is bundled with the Bamboo Microsoft Project Add-In. This add-in lets you import and export tasks between your PM Central projects and Microsoft Project 2010. You must install the add-in on an environment that already has Microsoft Project 2010 and Visual Studio Tools for the Office system 3.0 Runtime installed. The add-in is compatible with Microsoft Project 2010 and with both SharePoint 2007 and 2010.

Note: Before you install the add-in, make sure you only have Microsoft Project 2010 installed, not Microsoft Project 2010 and Microsoft Project 2007 installed. If you have both versions installed, the add-in will fail.

For information on importing from MS Project to your PM Central projects, read
KB.12485: How to Use the Bamboo Microsoft Project Add-in With PM Central R1.8 or Newer for SharePoint 2010: Importing Tasks into SharePoint Tasks Lists From Microsoft Office Project 2010.

This article has three sections:

A. Exporting From the Cost View, Tracking View or Scheduling View to Microsoft Project

Each project site's Tasks tab has several list views. You can export the Cost View, Tracking View or Scheduling View to Microsoft Project using the Bamboo MS Project Add-In. These list views use the Bamboo Data-Viewer Web Part to display the data.


choose your view


To export one of the list views:

1. Click the tab of the list view that you want to export, for example: Tracking View. At the bottom of the page, click Export to MS Project.


click "Export to MS Project"


2. The source fields are automatically populated from the tasks list. You need to manually map the source fields to the destination fields.

map the Destination Fields


 Use the table below to map your source fields. Only the fields listed in the table can be mapped to export data.



Note: For the Task Summary and Predecessor Task fields, map to OutlineParent and PredecessorTask as shown in the table. Due to the limitation of the Task Master Web Part, only one predecessor can be selected per task item. Constraints with lag time such as +3days are not supported in this version.

Since Bamboo's Tasks list is using Custom Column for Cost, Actual Cost and Remaining Cost, you can only map Cost (Enter), Actual Cost (Enter) and Remaining Cost (Enter) to MS Project’s Cost, Actual Cost and Remaining Cost. The values that you import in will overwrite the values in the custom columns.

3. Click Next to review the data. Use the Back button to make changes. Click Export.

review the data and click "Export"

4. The data is created as an xml file. Click Save to save the file to your local drive.

save the file

5. In the Save As screen, you can give the file a more specific name.

give the file a specific name

 

6. Use MS Project 2010 to open the xml file. Make sure you select xml as the file format.

 

open the xml file in Project

7. In the Import Wizard window, choose how you want to import the file, then click Finish.

 

import the file

8. When the schedule is imported successfully, save the project schedule as an mpp file.

save the file as an mpp file

Exporting From the Portfolio Site's Project Tasks List to MS Project

1. Navigate to the portfolio site and click the Schedules tab. Scroll down to the Project Tasks list and click Export To MS Project.


export to Microsoft Project



2. Follow steps 2-8 from Section A above to export.

C. Exporting From the Bamboo MS Office Project Integration Web Part Page

If the Cost View, Scheduling View and Tracking View do not include all the fields that you want to export to MS Project, you can add additional fields by exporting from the Bamboo MS Office Project Integration Web Part page.

1. Go to the page that contains the list view you want to export, such as the project site's Tasks tab. Click the list view that you want to export, such as the Tracking View. Use the ribbon to edit the page by selecting Page > Edit Page.

 

use the ribbon to edit the page

2. Click Add a Web Part. Under the Bamboo Solutions category, select the Bamboo MS Office Project Integration Web Part.

 

add the Bamboo MS Project Integration Web Part

3. After the Web Part is installed on the page, enter the path where the file is located. Click on the green arrow. Select the file from the SharePoint Task List field. Click OK.

enter the site path and choose your list

Review the section above on how to map fields from SharePoint to MS Project.


4. Follow steps 2-8 from Section A above to export the data to MS Project.

 

Related Articles
Q12376 - HOWTO: Use the Bamboo MS Project Add-In to Import Tasks into SharePoint Tasks List From MS Office Project 2007 with PM Central R1.5 or Newer
Q12380 - HOWTO: Export Tasks From a Tasks List or the Portfolio Site's Project Tasks List to MS Office Project 2007
Q12485 - HOWTO: Use the Bamboo Microsoft Project Add-in With PM Central R1.8 or Newer for SharePoint 2010: Importing Tasks into SharePoint Tasks Lists From Microsoft Office Project 2010

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.