How To: Change Estimate/Remaining/Complete Fields Format To Days Instead Of Hours

15/11/2008

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???

1

2

Here is my answer for that question:

To download a mapping file
  1. Open a Command Prompt window.

  2. 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.

  3. 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,

3
4
 

Change The Days to Hours Calculation

Click on Tools -> Options
5
 
Goto “Schedule” Tab and change “Work is entered in:” to Days
 
 6
 
Here is the new View
 
7
 
Enjoy.
Add comment
facebook linkedin twitter email

Leave a Reply

4 comments

  1. Yifat18/11/2008 ב 10:45

    It’s works great!!!
    Thx a lot’s
    Yifat

  2. neongreen21/11/2008 ב 04:08

    Well thx a lot for posting this solution of that problem…i was faced with this same problem of Changing Complete Field Format To Days Instead Of Hours..and have spent a lot of time on it without a real solution….so thx a lot for saving me the trouble of having to spend many more hours on what now seems to be a pretty easy thing to do! :)

  3. neongreen21/11/2008 ב 05:06

    Well thx a lot for posting this solution of that problem…i was faced with this same problem of Complete Field Format To Days Instead Of Hours..and have spent a lot of time on it without a real solution….so thx a lot for saving me the trouble of having to spend many more hours on what now seems to be a pretty easy thing to do! :)

  4. Shai Raiten21/11/2008 ב 06:31

    Glad I can help!
    If you have any more problem you are welcome to ask me.