Time entry behaviour in Project server - TFS integration

Question

Hi,

I would like to confirm the time entry behavior in the case of the Project server – TFS integration.

When we are entering time from TFS, It is reflecting in Timesheet even if it in submitted or approved.  Is there a way that completed hrs entry from TFS is reflected in Project plan without editing entries in Submitted ot approved timesheets?

---

Thanks, Lovely

Answer 1

Are you running in Single Entry Mode?

---

Abhijeet M. Mohite

Answer 2

Yes Abhijeet. Its in Single Entry Mode.

---

Thanks, Lovely

Answer 3

Hi,

 

This is what happens in my environment.

 

1. PS 2010 with SP1 operating in Single Entry mode

2. PS 2010 integrated with TFS 2010

3. I create a task in one of the Project, work is 40 Hours, assign a resource to the task and publish it to TFS

4. Resource fills up timesheet for that week and enters 40 hours against that task

5. Timesheet goes to timesheet manager  for approval as well the task update goes for Status Manager approval

6. In my case the Status Manager and Timesheet Manager for the resource is same person

7. Approver approves both the task update and timesheet
8. Timesheet is approved with 40 Hours in that week and Task is also approved. Project Plan is updated with task completed and 40 hours in work and actual work
9. Resource goes to TFS and adds another 20 Hours in completed work for that task from Visual Studio and saves work item
10. Status Manager receives only task update in EPM and approves it
11. Project Plan gets updated where work and actual work gets updated to 60 Hours
12. Nothing happens to approved timesheet and it remains on earlier entered 40 Hours

---

Abhijeet M. Mohite

Answer 4

You can set a rule within Project Server to autoapprove updates...

 

 

---

Andrew Lavinsky [MVP] Blog: http://azlav.umtblog.com Twitter: @alavinsky

Answer 5

thanks for the response.

I did the testing similar to what abhijeet has done and now the time entry in approved and submitted timesheet is not getting changed.

and the in progress timesheets are affected. In my case whatever the entry from TFS is updated as the actual hrs in Project plan and the time entry from timesheet is getting added to the actual hrs in th eproject plan while in abhijeets case the entry from TFs is gettign added to the actual hrs in the project plan.

Anyway the result I got now looks almost fine.

In TFS - Project server integration I have used the default field mapping.Given below the settings for actual hrs in the field mapping for the integration.

           <field tfsName="Microsoft.VSTS.Scheduling.CompletedWork" tfsMirrorName="Mirror.Microsoft.VSTS.Scheduling.CompletedWork" displayTfsField="true" displayTfsMirror="true">
        <tfsToTarget>
          <target provider="ProjectServerStatusQueue" name="pjResourceActualWork" />
        </tfsToTarget>
        <targetToTfs>
          <target provider="ProjectServerPublished" name="pjTaskActualWork" />
        </targetToTfs>
      </field>

---

Thanks, Lovely

Answer 6

Hi Lovely,

Even I am also using default field mappings.

Hope my reply helps you a little.

---

Abhijeet M. Mohite