This is using the VSTS Release Candidate and Beta3 server software.
I can perform all other tasks that I know of, but anything with Work Items outside of the IDE fails.
If excel integration works then this is going to be an MS Project integration specific issue which we can investigate further.
Please feel free to mail me with the info.
thank you
Some new information, but very strange.
1. Excel seems to work fine. I can add new items from there with no problems.
2. I added 2 new items in Excel (one Change Request, one Risk) and there is no way to select them via the Query drop-down. Will this be fixed?
3. When i did select All Tasks, only Task 2 came back, not 3 or 4.
4. I had to select Select All My Team Project Work Items. When I did I got the following message:
"You are trying to add work items that are not in the selected team project for this Microsoft Excel file. Only the work items from the DemoProject team project will be added to your work item list. If you want to add work items from another team project, open a new Microsoft Excel file from that team project."
The only problem was that it was a brand new excel file so there shouldn't have been any issues.
5. Task #1 NEVER showed up in Excel - only in VSTS (again I selected Select All My Team Project Work Items).
6. The error I got in Project was the following (after selecting Choose Team Project and selecting the server and project):
Microsoft Office Project
TF82024: The following fields could not be mapped because the fields could not be found on the server:Microsoft.VSTS.Common.QualityOfServiceType
OK
--Note also that this was a fresh MS Project File.
7. I tried to open the project file from VSTS through the IDE, which opened fine, but when I selected Choose Team Project I got the following error message:
Microsoft Office Project
TF80071: Team Foundation encountered an error while accessing the work item database. Please contact the Team Foundation Server administrator.
OK
I'm running as Admin in TFS.
I hope this helps or you can tell me what might be going on. If you need to look at my systems (remote desktop or even examine my system) please let me know (or if there is any additional information I can provide you). Everything is repeatable.
Jeff
In MSProject case it looks like the MS Project mapping file that maps the Team System columns into MS Project columns is out of Sync with the rest of the schema. You can fix the mapping file using the TFSFieldMapping utility to upload/download the project mapping fix and fixing the error entry. In your case it looks like the "QualityOfServiceType" entry.
TFSFieldMapping.exe is found in Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies folder. Here is what you will be doing.
1. TFSFieldMapping download <ServerName> <projectname> <mapping filepath>
2. Update the mapping file to fix the issue
3. TFSFieldMapping upload <ServerName> <projectname> <mapping filepath>
Please send me email if this does not resolve the problem so that we can investigate the issue further and fix it.
<?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"/>
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.RemainingWork" ProjectField="pjTaskRemainingWork" ProjectUnits="pjHour"/>
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.BaselineWork" ProjectField="pjTaskBaselineWork" ProjectUnits="pjHour"/>
<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" />
<Mapping WorkItemTrackingFieldReferenceName="System.Reason" ProjectField="pjTaskText14" />
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.Rank" ProjectField="pjTaskText16" />
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.Issue" ProjectField="pjTaskText15" />
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.ExitCriteria" ProjectField="pjTaskText20" />
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.QualityOfServiceType" ProjectField="pjTaskText21" />
<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" />
<ContextField WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.TaskHierarchy"/>
<LinksField ProjectField="pjTaskText26" />
<SyncField ProjectField="pjTaskText25" />
</Mappings>
</MSProject>
Thanks!
Jeff
<?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"/>
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.RemainingWork" ProjectField="pjTaskRemainingWork" ProjectUnits="pjHour"/>
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.BaselineWork" ProjectField="pjTaskBaselineWork" ProjectUnits="pjHour"/>
<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" />
<Mapping WorkItemTrackingFieldReferenceName="System.Reason" ProjectField="pjTaskText14" />
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.Rank" ProjectField="pjTaskText16" />
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.Issue" ProjectField="pjTaskText15" />
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.ExitCriteria" ProjectField="pjTaskText20" />
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.QualityOfServiceType" ProjectField="pjTaskText21" />
<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" />
<ContextField WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.TaskHierarchy"/>
<LinksField ProjectField="pjTaskText26" />
<SyncField ProjectField="pjTaskText25" />
</Mappings>
</MSProject>
I am guessing the Team Project you are working does not contain "Quality of Service Requirement" work item type. If that is correct remove the line marked in read and upload the mpp using the TFSFieldMapping utility.
TFSFieldMapping.exe is found in Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies folder. Here is what you will be doing.
1. TFSFieldMapping download <ServerName> <projectname> <mapping filepath>
2. Update the mapping file to fix the issue
3. TFSFieldMapping upload <ServerName> <projectname> <mapping filepath>
One thing also - just a note. When you select All My Task Items for a project, it actually tries to pull task items from other projects and that's why it throws up that message dialog. It probably shouldn't do that but I just wanted to note it.
One other question - how do you change the queries that are displayed in the drop down lists for retrieval of items in Excel and Project? Is it as simple as creating another query in the IDE and it will be available everywhere?
Thanks.
Jeff
