exporting TFS to Microsoft Project - Priority Field Not mapped

Question

When exporting from TFS to Project the Project priority field does not mapped to anything. In project the priority field is used when leveling resources.

Here is my downloaded mapping file...which is the default.  I publish to Project and i've include screen shots of my column mapping.  It isn't there.

Note:  Backlog Priority is mapped and it isn't even in the mapping file.

<?xml version="1.0" encoding="utf-8"?>
< MSProject>
  <Mappings>
    <Mapping WorkItemTrackingFieldReferenceName="System.Id" ProjectField="pjTaskText10" ProjectName="Work Item ID" />
    <Mapping WorkItemTrackingFieldReferenceName="System.Title" ProjectField="pjTaskName" />
    <Mapping WorkItemTrackingFieldReferenceName="System.WorkItemType" ProjectField="pjTaskText24" />
    <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.Discipline" ProjectField="pjTaskText17" />
    <Mapping WorkItemTrackingFieldReferenceName="System.AssignedTo" ProjectField="pjTaskResourceNames" />
    <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.CompletedWork" ProjectField="pjTaskActualWork" ProjectUnits="pjHour" IfSummaryRefreshOnly="true" />
    <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.RemainingWork" ProjectField="pjTaskRemainingWork" ProjectUnits="pjHour" IfSummaryRefreshOnly="true" />
    <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.BaselineWork" ProjectField="pjTaskBaselineWork" ProjectUnits="pjHour" IfSummaryRefreshOnly="true" />
    <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.StartDate" ProjectField="pjTaskStart" PublishOnly="true" />
    <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.FinishDate" ProjectField="pjTaskFinish" PublishOnly="true" />
    <Mapping WorkItemTrackingFieldReferenceName="System.State" ProjectField="pjTaskText13" ProjectName="State" />
    <Mapping WorkItemTrackingFieldReferenceName="System.Reason" ProjectField="pjTaskText14" />
    <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.Priority" ProjectField="pjTaskText19" ProjectName="Work Item Priority" />
    <Mapping WorkItemTrackingFieldReferenceName="System.AreaPath" ProjectField="pjTaskOutlineCode9" />
    <Mapping WorkItemTrackingFieldReferenceName="System.IterationPath" ProjectField="pjTaskOutlineCode10" />
    <Mapping WorkItemTrackingFieldReferenceName="System.Rev" ProjectField="pjTaskText23" />
    <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.CMMI.RequirementType" ProjectField="pjTaskText27" />
    <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.CMMI.Probability" ProjectField="pjTaskText28" />
    <ContextField WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.TaskHierarchy" />
    <LinksField ProjectField="pjTaskText26" />
    <SyncField ProjectField="pjTaskText25" />
  </Mappings>
< /MSProject>

Answer 1

Hi Trish,

Thank you for your question.

I am trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.

Thank you for your understanding and support.

Best regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi,

Are you exporting Task in team project of Visual Studio Scrum team project template?  If so what you see is expected, Task in this Visual Studio Scrum template has only these columns in mapping.  I see same column mapping on my test lab. 

So Backlog priority could be the one you're looking for.  If you're looking for exact Priority field in Task, you'll need CMMI team project template

---

Forrest Guo | MSDN Community Support | Feedback to manager

Answer 3

I added the Priorty field to the template.  Shouldn't it come across if it is the the Mapping file? 

Answer 4

Hi,

I don't see Field Name has option of Microsoft.VSTS.Common.Priority, did you do other customization before get to this page?

Note that I'm with Visual Studio Scrum project template.

---

Forrest Guo | MSDN Community Support | Feedback to manager

Answer 5

I managed to add Priority field and add control to layout. However, the customized workitem results in all workitem types doesn't show up in Work Item node in Team Explorer.  Finally, could not create new item of such customized Task.  Are you able to get the customization work?

best regards,

---

Forrest Guo | MSDN Community Support | Feedback to manager

Answer 6

I can put a value in the priority field save it and pull it back up and it is there.  The mapping file has the priority field in it.  But it doesn't make it to MS project.

<?xml version="1.0" encoding="utf-8"?>
 < MSProject>
   <Mappings>
     <Mapping WorkItemTrackingFieldReferenceName="System.Id" ProjectField="pjTaskText10" ProjectName="Work Item ID" />
     <Mapping WorkItemTrackingFieldReferenceName="System.Title" ProjectField="pjTaskName" />
     <Mapping WorkItemTrackingFieldReferenceName="System.WorkItemType" ProjectField="pjTaskText24" />
     <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.Discipline" ProjectField="pjTaskText17" />
     <Mapping WorkItemTrackingFieldReferenceName="System.AssignedTo" ProjectField="pjTaskResourceNames" />
     <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.CompletedWork" ProjectField="pjTaskActualWork" ProjectUnits="pjHour" IfSummaryRefreshOnly="true" />
     <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.RemainingWork" ProjectField="pjTaskRemainingWork" ProjectUnits="pjHour" IfSummaryRefreshOnly="true" />
     <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.BaselineWork" ProjectField="pjTaskBaselineWork" ProjectUnits="pjHour" IfSummaryRefreshOnly="true" />
     <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.StartDate" ProjectField="pjTaskStart" PublishOnly="true" />
     <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.FinishDate" ProjectField="pjTaskFinish" PublishOnly="true" />
     <Mapping WorkItemTrackingFieldReferenceName="System.State" ProjectField="pjTaskText13" ProjectName="State" />
     <Mapping WorkItemTrackingFieldReferenceName="System.Reason" ProjectField="pjTaskText14" />
     <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.Priority" ProjectField="pjTaskText19" ProjectName="Work Item Priority" />
     <Mapping WorkItemTrackingFieldReferenceName="System.AreaPath" ProjectField="pjTaskOutlineCode9" />
     <Mapping WorkItemTrackingFieldReferenceName="System.IterationPath" ProjectField="pjTaskOutlineCode10" />
     <Mapping WorkItemTrackingFieldReferenceName="System.Rev" ProjectField="pjTaskText23" />
     <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.CMMI.RequirementType" ProjectField="pjTaskText27" />
     <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.CMMI.Probability" ProjectField="pjTaskText28" />
     <ContextField WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.TaskHierarchy" />
     <LinksField ProjectField="pjTaskText26" />
     <SyncField ProjectField="pjTaskText25" />
   </Mappings>
 < /MSProject>

Answer 7

Hi,

I managed to get the customized field ported to Project.  The new added Priority field is of type integer, so we need map to Number field in Project.  Just change ProjectField="pjTaskNumber2" should get it work. 

The whole process is:

• Run TFSFieldMapping download to download the mapping file;
• Add a mapping entry to above file:  <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.Priority" ProjectField="pjTaskNumber2" /> 
• Run TFSFieldMapping upload to upload the mapping file
• In VS query editor, open query in Project, then in Project, select Number2 in "Add New Column" dropdown.

Hope this gets you started.  Cheers !

I'm referring to: http://msdn.microsoft.com/en-us/library/ms404687(v=vs.100).aspx

best regards,

---

Forrest Guo | MSDN Community Support | Feedback to manager