How To: Change Estimate/Remaining/Complete Fields Format To Days Instead Of Hours
How To: Change Estimate/Remaining/Complete Field Format To Days Instead Of Hours
I receive the following question:
How do I change the format for reporting a work: estimate/ remaining/complete - to days instead of hours???
Here is my answer for that question:
To download a mapping file
-
Open a Command Prompt window.
-
Open the folder where Visual Studio is installed (for example, drive:\Program Files\Microsoft Visual Studio 9),
and in that folder, locate \Common 9.0\IDE.
The TFSFieldMapping.exe utility program is in this folder.
-
Download the mapping file by using the TFSFieldMapping.exe utility by typing the following at the command prompt:
TFSFieldMapping download http://TFSServerName:8080 TeamProjectName MappingFile.xml
Now open MappingFile.xml and look for CompletedWork, RemainingWork, BaselineWork.
Change the ProjectUnits to pjDay instead of pjHour.
Like This:
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.CompletedWork"
ProjectField="pjTaskActualWork" ProjectUnits="pjDay" />
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.RemainingWork"
ProjectField="pjTaskRemainingWork" ProjectUnits="pjDay" />
<Mapping WorkItemTrackingFieldReferenceName="Microsoft.VSTS.Scheduling.BaselineWork"
ProjectField="pjTaskBaselineWork" ProjectUnits="pjDay" />
Save MappingFile.xml.
To Upload the mapping file back to TFS
TFSFieldMapping upload http://TFSServerName:8080 TeamProjectName MappingFile.xml
Now you give your estimation in Days and Not in Hours.
But you can see that the value from Team System automatic translated into Hours in MsProject,
Change The Days to Hours Calculation
Click on Tools -> Options
Goto "Schedule" Tab and change "Work is entered in:" to Days
Here is the new View
Enjoy.