教你如何在TFS中让所有的成员都能够通过使用Project来读取计划的Start Date 时间

问题描述：
http://forums.microsoft.com/msdn-cht/addpost.aspx?postid=384665&SiteID=14

環境： A 電腦為安排進度(以下簡稱a)、 B 電腦為專案成員(以下簡稱b)

操作步驟如下

今天的時間為 2006年5月5日

一、a開啟了 project 2003 並連線到 TFS，新增了一個工作項，Assigned to 指定給 b 。設定預計完成時間  Start Date (2006/5/8) 、 Finish Date (2006/5/12)、Remaining work (16)。

最後在上面的 TFS增益集裡面 Publish。

二、b 在 VSTS中的 My work item 中收到 new work item ，確認以上三格時間都是正確的。(即相同的內容)

三、b 使用匯出至 project 2003 後，發現 Start Date 變成了今天 (2006/5/5 )，而原本因為 Remaining work 是設定 8 小時，所以導致了 Finish Date 就變成了 2006/5/8。

 

假使，B就直接用「錯誤的時間」直接設定完成工作進度 (completed work ) 的話！並按下 Publish 後。

回到 VSTS 裡的 work item 檢查，Start Date 、Finish Date 都已經被 B 改變成錯誤的時間了。

回到 A 的project 按下 Refresh 後，只有「工作進度(Completed work)」有正確更新。但，Start date 和 Finish Date 都還是和原來的一致！

 

請問，是不是小弟的操作上有問題呢？？還是 VSTS 和 Project 之間配合的問題！

若是搭配 project server 的話！是不是可以解決以上這種奇怪的問題呢？？

 

為何直接在 VSTS 上產生一個 New Work Item 時卻無法指定 Start Date 和 Finish Date 呢？？

背景：
微软TFS和微软的Porject之间通过一个Mapping文件来通讯，这个文件可以下载，修改，上传。

问题解决描述：（红色部分为重点部分）
http://msdn2.microsoft.com/en-us/library/ms181686(VS.80).aspx

How to: Change How Fields are Mapped to Microsoft Project 

 When you connect a project plan to Team Foundation, you may need to define how the work item fields are mapped to fields in Microsoft Project. To change how the fields are mapped, you must edit XML files.

Note

The mapping between work item fields and Microsoft Project is specific to a team project. You can change the field mapping at any point in the project.

Note

If you change a column name in Microsoft Project, the column will be renamed when you refresh from Team Foundation. If you want to change a column name permanently, use the TFSFieldMapping utility.

To view how work item fields are mapped to Microsoft Project

1. On the Team menu, click View Column Mappings.

   Note

   The mapping between work item fields and Microsoft Project is specific to a team project. You can change the field mapping at any point in the project.

2. Review how work item fields are mapped to Microsoft Project and determine if you need to make changes. If you decide to make changes, see the following procedure, "To change how work item fields are mapped to Microsoft Project".

To change how work item fields are mapped to Microsoft Project

1. Download the mapping file as follows:

   1. Open a command prompt window.

   2. Go to the folder where Visual Studio is installed (for example, drive:\Program Files\Microsoft Visual Studio 8), and in that folder, go to \Common 7\IDE. The TFSFieldMapping.exe utility program is in this folder.

   3. Download the mapping file using the TFSFieldMapping.exe utility by typing the following at the command prompt:

      TFSFieldMapping download http://Team_Foundation_Server team_project C:\MappingFile.xml

      Where:

      http://Team_Foundation_Server is the URL of your server.

      team_project is the name of your team project.

      C:\MappingFile.xml is the file name and location to which the mapping file will be downloaded.

2. Edit the mapping file as follows:

   1. Open the mapping file you downloaded (for example, C:\MappingFile.xml) in an XML editor.

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

      Copy Code

      <Mapping WorkItemTrackingFieldReferenceName="fieldname.value" ProjectField="projectfield" />

      For example:

      Copy Code

      <Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Common.Priority" ProjectField="pjTaskWBS" /> 

      Where:

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

      pjTaskWBS is the Microsoft Project field WBS for Tasks

      Tip

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

   3. If you want a field to be published to Team Foundation Server, but not refreshed from Team Foundation Server, add the PublishOnly attribute to the mapping section for that field and set the attribute to True. The default value is False, where a field is both published and refreshed from Team Foundation Server. This attribute can be used to allow team members to see a field value but not be able to change it in Team Foundation.

   4. Save the mapping file.

3. Upload the mapping file as follows:

   1. Open a command prompt window.

   2. Go to the folder where Visual Studio is installed (for example, drive:\Program Files\Microsoft Visual Studio 8), and in that folder, go to \Common 7\IDE. The TFSFieldMapping.exe utility program is in this folder.

   3. Upload the mapping file using the TFSFieldMapping.exe utility by typing the following at the command prompt:

      TFSFieldMapping upload http://Team_Foundation_Server team_project C:\MappingFile.xml

      Where:

      http://Team_Foundation_Server is the URL of your server.

      team_project is the name of your team project.

      C:\MappingFile.xml is the file name and location from which the mapping file will be uploaded.

Security

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