Importing and exporting plans with Microsoft Project

The import and export feature allows the integration of project planning and tracking information between Rational® Team Concert and Microsoft Project. You can import a Microsoft Project XML file to a plan in Rational Team Concert. In addition, you can export a Rational Team Concert plan to an XML file that can then be opened in Microsoft Project.

Supported version: Microsoft Project versions 2007, 2010, and 2013 are supported for import and export.

To import a plan, save the Microsoft Project file as a XML file and import the XML file. When you export a plan, an XML file is generated that you can open in Microsoft Project. Only the functions and attributes of Microsoft Project that are supported by your plan are imported or exported.

Import and export mapping

Mapping replaces a task type or resource from Microsoft Project with a supported work item type or resource in your target project. When you import a project plan, you can map the task types from Microsoft Project to the work item types in your project.

When you map task types, the attributes of task types in Microsoft Project are replaced with the attributes of the supported work item types in your target project. For example, you might map a task of type Summary Task from Microsoft Project to a Task work item type in your project.

The following tables illustrate how the resources and attributes of Microsoft Project map to the resources and attributes of your application.

Table 1. Mapped resources after import
Microsoft Project Plan Your existing plan
User Contributor
Summary Task Any work item type
Task Any work item type
Task Assignment The mapped user is assigned as the owner of the work item.
Project Plan
Dependency If you are using the Formal Project Management process, the Finish-to-Start dependency is imported and mapped to the Finish-to-Start dependency type. Other dependencies are not imported or mapped. In processes where no dependencies are defined, such as Scrum, dependencies are not imported or mapped.
Constraints If you are using the Formal Project Management process, the As soon as possible, Start no earlier than, and Finish no later than constraints are imported and mapped to the same constraints. For Start no earlier and Finish no later than constraints, the constraint dates are also imported. Other constraints are not imported or mapped. In processes where no constraints are defined, such as Scrum, constraints are not imported or mapped.
The following resources in the Microsoft Project plan are not imported:
  • Project and user calendar
  • User rate
  • Schedule
  • Dependency other than Finish-to-Start
  • Constraints other than As soon as possible, Start no earlier than, and Finish no later than

Constraints and dependencies

The import and export capabilities in your application support the Finish-to-Start dependency among tasks in Microsoft Project. The remaining dependencies in Microsoft Project are not imported. Similarly, the import and export capabilities support only the As soon as possible, Finish no later than, and Start no earlier than constraints. The remaining constraints in Microsoft Project are not imported.

If constraints and dependencies exist in the import file, they are imported along with the constraint dates, if any. The constraints, constraint dates, and dependencies are then mapped to the compatible constraints and dependencies that are defined in your process template. If your process template does not contain dependencies or constraints, or if a compatible dependency or constraint is not found, the constraints and dependencies are not imported.
Note: For Agile plans, instead of constraints and dependencies, a sequence number is calculated and assigned to the work item. This sequence number determines the order of the work items in the project plan.

Task with multiple assignments

A task that has multiple assignments in Microsoft Project is imported into your project as a parent Summary Task and child tasks. For example, a task in Microsoft Project is assigned to Resource1, Resource2, and Resource3. When the task is imported to the target project, a Summary Task named T1 is created with three child tasks: T1_Task1, T1_Task2, and T1_Task3. As a result, Resource1 is assigned to T1_Task1, Resource2 is assigned to T2_Task2, and Resource3 is assigned to T1_Task3.

Table 2. Mapped resources after export
Your existing plan Microsoft Project Plan
Project and iteration plans Project
Contributor User
Leaf work - items Task
Non leaf work - items Summary Task
Dependency and Constraints Dependency and Constraints
Assignment Assignment
Related information:
Microsoft Project integration with Rational Team Concert

video icon Watch videos

CLM playlist
Jazz.net channel
User Education channel

learn icon Learn more

CLM learning circle
Agile learning circle
Learning circles

ask icon Ask questions

Jazz.net forum
developerWorks forums

support icon Get support

Support Portal
Deployment wiki
Support blog