Change How Fields are Mapped to Microsoft Project

Article
02/04/2013

If you want to change the publishing behavior for Office Project, you must change the Office Project mapping file. By modifying the mapping file, you can specify which fields in Team Foundation are mapped to by Office Project fields. You can also control publishing behavior through the PublishOnly attribute, and designate special fields such as the context field.

A mapping file is associated with one team project. You can change the mapping file at any point in time on a team project. The mapping file a team project starts with is determined by the mapping file from the process template that was used to create the team project.

Note

When you modify the mapping file for a team project, you are modifying the Office Project field maps for all team members on that team project.

Required Permissions

To perform these procedures, you must be a member of the Project Administrators group or have your Edit project-level information and View Project-level information permissions set to Allow. Additionally, you must have permissions to create the mapping file in the local path that you specify. For more information, see Team Foundation Server Permissions.

To change how work item fields are mapped to Office Project

Download the mapping file from the team project that you want to modify. For more information, see Download or Upload a Microsoft Project Field Mapping File.
Open the mapping file that you downloaded (for example, C:\MappingFile.xml) in an XML editor.
Add new mappings or edit existing mappings in the following format:
```
<Mapping WorkItemTrackingFieldReferenceName="fieldname" 
   ProjectField="projectfield" 
   ProjectName="user friendly name"
   />
```
For example:
```
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.Priority"
   ProjectField="pjTaskText19"
   ProjectName="Work Item Priority" />
```
Where:

Microsoft.VSTS.Common.Priority is an existing field in the Microsoft Solutions Framework (MSF) for Agile Software Development process.

pjTaskText19 is a custom text field in Office Project.

Note

For a full list of all the Office Project field values for the ProjectField attribute, see Field Mappings in Microsoft Project.
(Optionally) Indicate if the field is to be published but not refreshed. Add the PublishOnly attribute to the mapping section for that field and set the attribute to true. This attribute can be used to allow for team members to see a field value but not be able to change it in Team Foundation.
Designate which Office Project field is the synchronization field by using the following syntax:
```
<SyncField ProjectField="" />
```
The following example shows how to specify pjTaskText25 as the synchronization field:
```
<SyncField ProjectField="pjTaskText25" />
```
Save the mapping file.
Upload the mapping file to the team project that you want to modify. For more information, see Download or Upload a Microsoft Project Field Mapping File.

Share via

Change How Fields are Mapped to Microsoft Project

To change how work item fields are mapped to Office Project

See Also

Reference

Concepts

Other Resources

Additional resources