CODEWITHSUNDEEP
visual-studiotfsvisual-studio-2013scrum
grizzly
grizzly

Reputation: 1156

Update TFS Sprint Burndown Chart Retroactively

Can I update the TFS chart retroactively?

Assume it is Wednesday, and I want to update TFS Work Item (Eg. the remaining hours) for Monday and Tuesday and the TFS Scrum Burndown Chart to reflect this.

Is there a way how to do that? Either from within Visual Studio, TFS Web Access or at least programmatically through TFS API?

Upvotes: 2

Views: 995

Answers (1)

Milan Jaros
Milan Jaros

Reputation: 1147

No, this is not possible and if you achieve that, it is not officially supported. I have not find any way to modify it using VS, Web, Excel, Project nor API.

Time-machine

It is possible to change date of server where TFS is running and then manipulate Work Items. I was able to increase the curve (useful when preparing demo data).

  1. Backup.
  2. You may need to stop sync of clock.
  3. Change a date on TFS server.
  4. Manage work items (e.g. using Web Access).
    • You will find that system doesn't allow you to change values of "work items from future", so you will need to create new work items.

Drity SQL job

For sure, it is possible to change data directly in SQL.

  1. Backup. Don't work directly on production because you can hurt TFS a lot.
  2. Connect to TFS SQL database and look around a dbo.WorkItemsWere table.
  3. Ensure you really want to get database into unsupported state. (See Michael Ruminer's answer.)

API

It is not possible to influence Burn-down chart retroactively using TFS API.

Event if it is possible to modify field "System.CreatedDate" of work item, it is not possible to change "Microsoft.VSTS.Scheduling.StartDate" and "System.AuthorizedDate" which seems to be used for calculation of graph (work item field reference).

More information you can find in Tarun Arora's post and Richard Hundhausen's blog.

Upvotes: 1

Related Questions