Share via

Upload or Download the Microsoft Project Mapping File

  • Article

Use TFSFieldMapping to upload and download the Microsoft Project mapping file. This file controls how Microsoft Project publishes tasks to a specified team project that was created in Visual Studio Team Foundation Server 2012. For example, you can modify the file to support fields you added to work item types or modify the way in which existing fields are published and refreshed.

You can specify which fields in Team Foundation are mapped to Microsoft Project fields. You can also control publishing behavior through the PublishOnly attribute, and designate special fields such as the context field. For the complete XML syntax of the mapping file, see The Microsoft Project Field Mapping File. This file is the same file that was defined in the process template that was used to create the team project. See Map Microsoft Project Fields to Team Foundation Fields

To access the TFSFieldMapping command-line tool, open a Command Prompt window where you have installed Project and either Team Explorer or TFS and enter:

cd %programfiles%\Common Files\microsoft shared\Team Foundation Server\11.0

Note

Even if you are logged on with administrative permissions, you must open an elevated Command Prompt to perform this function on a server that is running Windows Server 2008. To open an elevated Command Prompt, choose Start, open the context menu for Command Prompt, and then choose Run as Administrator. For more information, see the Microsoft Web site.

Required Permissions

To use the TFSFieldMapping command, you must be a member of the Team Foundation Administrators or the Project Administrators security group. For more information, see Team Foundation Server Permissions.

TFSFieldMapping upload | download /collection:CollectionURL /teamproject:ProjectName /mappingfile:MappingFile

Parameters

Argument

Description

upload | download

Specifies whether to download or upload the field mapping file.

/collection:CollectionURL

Specifies the URI of the team project collection in the following format: http://ServerName:Port/VirtualDirectoryName/CollectionName

If you do not specify a virtual directory is used, you must use the following format:

http://ServerName:Port/CollectionName

If you have previously connected to the server, you can specify the friendly name for the server instead of the URI.

/teamproject:ProjectName

Specfies the name of the team project whose mapping parameters you want to modify. If the name contains spaces, enclose it in quotation marks.

/mappingfile:MappingFile

Specifies the name and file path of the mapping file.

To change how work item fields are mapped to Project

  1. Open a Command Prompt window where you have installed Project and either Team Explorer or TFS and enter:

    cd %programfiles%\Common Files\microsoft shared\Team Foundation Server\11.0

    Tip

    Project isn't required to download the mapping file, however, it is required to upload it.

  2. Download the mapping file by entering the following command:

    TFSFieldMapping download /collection:CollectionURL /teamproject:ProjectName /mappingfile:MappingFile

    Tip

    If a name contains spaces, enclose the name in quotes.

  3. Open the mapping file in a text editor or XML editor.

  4. Add new mappings or edit existing mappings in the following format:

    <Mapping WorkItemTrackingFieldReferenceName="System.Id" 
   ProjectField=""
   ProjectName=""
   ProjectUnits=""
   PublishOnly=""
   IfSummaryRefreshOnly=""/>

    For example, to add additional scheduling fields to a team project created using the Scrum process template, add the following mappings:

    <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.StartDate" ProjectField="pjTaskStart" PublishOnly="true" />
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.FinishDate" ProjectField="pjTaskFinish" PublishOnly="true" />
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.OriginalEstimate" ProjectField="pjTaskBaselineWork" ProjectUnits="pjHour" IfSummaryRefreshOnly="true" />
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.CompletedWork" ProjectField="pjTaskActualWork" ProjectUnits="pjHour" IfSummaryRefreshOnly="true" />

    The default Scrum template only maps the Remaining Work field to Project.

    Note

    For a full list of all the Office Project field values for the ProjectField attribute, see Field Mappings in Microsoft Project.

  5. (Optional) 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.

  6. (Optional) Indicate how summary tasks are to be refreshed in Project. Add fSummaryRefreshOnly="true" attribute to indicate that the field is never published to the work item database but is refreshed from the work item database when the row for the field is a summary task in Project, the summary task has Publish and Refresh=Yes, and the summary task contains at least one child task that is published to TFS.

  7. Save and upload the file:

    TFSFieldMapping upload /collection:CollectionURL /teamproject:ProjectName /mappingfile:MappingFile

See Also

Reference

Field Mappings in Microsoft Project

Concepts

The Microsoft Project Field Mapping File

Other Resources

Quick Tips and Operational Differences when Tracking Tasks Using Microsoft Project and Team Foundation

Using Team Foundation Server Command-Line Tools