Restrictions on Mapping Project Server Fields for Integration with Team Foundation Server

  • Article

When you add fields to participate in data synchronization between Visual Studio Team Foundation Server 2012 and Microsoft Project Server, make sure that you do not map fields that are restricted. You map fields by customizing the field mappings for a team project collection. You can map both built-in and custom fields in Project. You can map some of those fields only to the status queue and some fields only to Team Foundation Server. In general, you should map resource-level information, pjResource* fields, from Team Foundation Server to Project Server within the tfsToTarget element and only task-level information, pjTask* fields, from Project Server to Team Foundation Server within the targetToTfs element. For more information, see Field Mapping XML Element Reference for Integration of Team Foundation Server and Project Server.

You must also match the data types of mapped fields, both built-in and custom, according to the criteria that this topic describes. For more information about built-in fields, see Available fields reference.

In this topic

  • Restrictions on Units of Measurement and Renaming

  • Task Name and Work Item Title Field

  • Fields Available for Mapping to the Status Queue Only

  • Fields Available for Mapping from Project Server to Team Foundation Only

  • Fields Restricted from Mapping

  • Data Types and Field Mapping Criteria

Restrictions on units of measurement and renaming

The following restrictions apply to the mapping of fields that participate in data synchronization:

  • You cannot customize the units of mapped fields. For example, when you add the pjResourceAssignmentUnits to the field mappings, it is added using the unit of percentage, and you cannot change that measure.

  • Although you can add the Finish Date (pjFinishDate) field to the mappings, any value that you set in Team Foundation is not sent to Project Server. This restriction is by design. The project manager must set the Finish Date in the enterprise project plan.

  • If you rename the ActiveTfsAssignment(TFS) field in Project and try to publish your enterprise project plan, the Validation Resolution dialog box will appear. To resolve this condition, you must rename the field to its original name.

Back to top

Task name and work item title field

Project Name (pjTaskName) is the only field that is mapped from Project Server to Team Foundation and the status queue. This field maps to the Title (System.Title) field in Team Foundation. No other fields can be mapped to both Team Foundation Server and the status queue. The two-way mapping allows changes in both the enterprise project plan and team project to flow in both directions.

This mapping is represented in the following code of the field mappings:

<field tfsName="System.Title" tfsMirrorName="Mirror.System.Title" displayTfsField="false" displayTfsMirror="false" onConflict="PSWin">
   <tfsToTarget>
      <target provider="ProjectServerStatusQueue" name="pjTaskName" />
   </tfsToTarget>
   <targetToTfs>
      <target provider="ProjectServerPublished" name="pjTaskName" />
   </targetToTfs>
</field>

Back to top

Fields available for mapping to the status queue

You can map the following resource-related fields from Project Server to the Status queue. You can add these fields to the field mapping within the tfsToTarget element to send status updates to Project Server.

  • pjResourceActualFinish

  • pjResourceActualOvertimeWork

  • pjResourceActualStart

  • pjResourceActualWork

  • pjResourceAssignmentUnits

  • pjResourceConfirmed

  • pjResourceFinish

  • pjResourceOvertimeWork

  • pjResourcePercentWorkComplete

  • pjResourceRegularWork

  • pjResourceRemainingOvertimeWork

  • pjResourceRemainingWork

  • pjResourceStart

  • pjResourceUpdatesNeeded

  • pjResourceWork

In the following example, the Project Server Resource Work field is mapped to the MSFT.MappedTopjResourceWork field in Team Foundation for the status queue target.

<field tfsName="MSFT.MappedTopjResourceWork" tfsMirrorName="Mirror.MSFT.MappedTopjResourceWork" displayTfsField="true" displayTfsMirror="true">
   <tfsToTarget>
       <target provider="ProjectServerStatusQueue" name="pjResourceWork" />
   </tfsToTarget>
</field>

You can also combine the mapping of a resource-specific field with a task-specific field to form a full mapping. In the following example, the pjTaskWork field is mapped within the targetToTfs element to provide a complete round-trip mapping.

<field tfsName="MSFT.MappedTopjResourceWork" tfsMirrorName="Mirror.MSFT.MappedTopjResourceWork" displayTfsField="true" displayTfsMirror="true">
   <tfsToTarget>
       <target provider="ProjectServerStatusQueue" name="pjResourceWork" />
   </tfsToTarget>
   <targetToTfs>
       <target provider=" ProjectServerPublished" name="pjTaskWork"/>
   </targetToTfs>
</field>

Back to top

Fields available for mapping from Project Server to Team Foundation only

You can map the following task-specific fields from Project Server to Team Foundation Server. You can also combine the mapping of a task-specific field with a resource-specific field to form a full mapping.

  • pjTaskActualCost

  • pjTaskActualDuration

  • pjTaskActualFinish

  • pjTaskActualOvertimeCost

  • pjTaskActualOvertimeWork

  • pjTaskActualStart

  • pjTaskActualWork

  • pjTaskACWP

  • pjTaskBCWP

  • pjTaskBCWS

       

  • pjTaskBudgetCost

  • pjTaskBudgetWork

  • pjTaskCost

  • pjTaskCPI

  • pjTaskCreated

  • pjTaskCV

  • pjTaskCVPercent

  • pjTaskDeadline

  • pjTaskDuration

  • pjTaskDuration1

  • pjTaskDurationVariance

  • pjTaskEAC

  • pjTaskEarlyFinish

  • pjTaskEarlyStart

  • pjTaskExternalTask

  • pjTaskFinish

  • pjTaskFinishVariance

  • pjTaskFixedCost

  • pjTaskFreeSlack

  • pjTaskHyperlink

       

  • pjTaskHyperlinkAddress

  • pjTaskHyperlinkSubAddress

  • pjTaskIgnoreResourceCalendar

  • pjTaskLateFinish

  • pjTaskLateStart

  • pjTaskOverallocated

  • pjTaskOvertimeCost

  • pjTaskOvertimeWork

  • pjTaskPercentComplete

  • pjTaskPercentWorkComplete

  • pjTaskPhysicalPercentComplete

  • pjTaskPriority

  • pjTaskRecurring

  • pjTaskRegularWork

  • pjTaskRemainingCost

  • pjTaskRemainingOvertimeCost

  • pjTaskRemainingOvertimeWork

  • pjTaskRemainingWork

  • pjTaskSPI

  • pjTaskStart

       

  • pjTaskStartVariance

  • pjTaskSummary

  • pjTaskSV

  • pjTaskSVPercent

  • pjTaskTCPI

  • pjTaskTotalSlack

  • pjTaskVAC

  • pjTaskWork

  • pjTaskWorkVariance

  • pjTaskBaselineCost

  • pjTaskBaselineWork

  • pjTaskBaselineBudgetCost

  • pjTaskBaselineBudgetWork

  • pjTaskBaselineDuration

  • pjTaskBaselineStart

  • pjTaskBaselineFinish

       

  • pjTaskBaseline1Cost

  • pjTaskBaseline1Work

  • pjTaskBaseline1BudgetCost

  • pjTaskBaseline1BudgetWork

  • pjTaskBaseline1Duration

  • pjTaskBaseline1Start

  • pjTaskBaseline1Finish

       . . . 

  • pjTaskBaseline10Cost

  • pjTaskBaseline10Work

  • pjTaskBaseline10BudgetCost

  • pjTaskBaseline10BudgetWork

  • pjTaskBaseline10Duration

  • pjTaskBaseline10Start

  • pjTaskBaseline10Finish

In the following example, the Project Server Resource Work field is mapped to the MSFT.MappedTopjTaskBaseline1Start field in Team Foundation for the Team Foundation Server target.

<field tfsName="MSFT.MappedTopjTaskBaseline1Start" tfsMirrorName="Mirror.MSFT.MappedTopjTaskBaseline1Start" displayTfsField="true" displayTfsMirror="true">
   <targetToTfs>
       <target provider="ProjectServerPublished" name="pjTaskBaseline1Start" />
   </targetToTfs>
</field>

Back to top

Fields restricted from mapping

The following Project Server fields are restricted from mapping. Do not add these fields to the field mapping between Team Foundation and Project Server.

  • pjResourceID

  • pjResourceNotes

  • pjTaskCalendar

  • pjTaskCalendarGUID

  • pjTaskCommitmentFinish

  • pjTaskCommitmentGuid

  • pjTaskCommitmentStart

  • pjTaskCommitmentType

  • pjTaskConfirmed

  • pjTaskConstraintDate

  • pjTaskConstraintType

  • pjTaskContact

  • pjTaskCritical

  • pjTaskDelay

  • pjTaskHyperlinkScreenTip

  • pjTaskID

  • pjTaskLevelCanSplit

  • pjTaskLevelDelay

  • pjTaskNotes

  • pjTaskParentTask

  • pjTaskPreleveledFinish

  • pjTaskPreleveledStart

  • pjTaskProject

  • pjTaskResume

  • pjTaskRollup

  • pjTaskStartSlack

  • pjTaskStop

  • pjTaskSubproject

  • pjTaskSubprojectReadOnly

  • pjTaskSuccessors

  • pjTaskUniqueID

  • pjTaskWBS

Back to top

Data types and field mapping criteria

When you map a field from Team Foundation Server to Project Server, make sure that you match the data type of the Project Server field with that defined for the Team Foundation field according to the criteria that the following table outlines. In addition to the built-in fields that are listed earlier in this topic, you can create custom enterprise task-type fields and map them to support synchronization in either or both directions. For custom fields, make sure that you match the data types of fields as the third column of the table indicates. For more information, see Creating Lookup Tables and Enterprise Custom Fields.

Note

The units for work and task duration are specified in hours. You cannot customize the units.

Team Foundation Server

Fields that are built in to Project Server

Custom enterprise fields in Project Server

DateTime

Date

Date

Double

Work, Cost, Duration, Count, Percentage

Number, Cost, Duration

Integer

Count, Percentage

Number

String

Text

Text

TreePath

Text

Text

Back to top

See Also

Concepts

Field Mapping XML Element Reference for Integration of Team Foundation Server and Project Server

Other Resources

Customize the Field Mapping Between Project Server and Team Foundation Server