locked
Mass Transitions RRS feed

  • Question

  • Mass Transitions

    In our current workflow tool (i.e. Serena's TeamTrack) we have a concept of "Mass Transitions" where you can take a number of requests (e.g. 1000) and do a mass update to the work item states (or any other fields) instead of laboriously updating each work item. For example we have "Enhancement" work items that queue up in a "Code Complete" state. Once the build is deployed to QC (i.e. Test) we run the "Mass Transition" to update all work item states to "Deployed To QC." We can handle hundreds up updates with a simple "Mass Transition" and a cup of coffee.

    Does Team Foundation have a similar concept?

    Mac Noland

    Tuesday, September 12, 2006 8:21 PM

Answers

  • This is another bulk edit for TFS, and it can be done by exporting items to excel and changing the states. Also, we have actions feature in work item type definition which makes such operation easy from a script, and using one loop transistions can be done for different work item types with differing states and transistion rules.
    Tuesday, September 12, 2006 8:33 PM
  • Two options here. Create a small utility or plug-in to do so using the objectr model or the preferred and much easier method for mass maintenance: Do it from excel.

    If I need to mass maintenance a set of work items open up excel, attach to the TFS and the Team Project of interest and run a query to get the workitems and fields of interest. Then I change the field value of the first item and do the little right corner drag to apply it to all the items in the spreadsheet and then publish it back to TFS. Voila. mass update.

     

    Tuesday, September 12, 2006 8:34 PM

All replies

  • This is another bulk edit for TFS, and it can be done by exporting items to excel and changing the states. Also, we have actions feature in work item type definition which makes such operation easy from a script, and using one loop transistions can be done for different work item types with differing states and transistion rules.
    Tuesday, September 12, 2006 8:33 PM
  • Two options here. Create a small utility or plug-in to do so using the objectr model or the preferred and much easier method for mass maintenance: Do it from excel.

    If I need to mass maintenance a set of work items open up excel, attach to the TFS and the Team Project of interest and run a query to get the workitems and fields of interest. Then I change the field value of the first item and do the little right corner drag to apply it to all the items in the spreadsheet and then publish it back to TFS. Voila. mass update.

     

    Tuesday, September 12, 2006 8:34 PM
  • Thanks Micheal!  Yep just gave the little Excel trick a try and it worked fine.  Still not as easy as TeamTracks Mass Transtion report you can simply click on to run, but I think this workable.

    Mac

    Tuesday, September 12, 2006 8:46 PM
  • Just out of professional curiosity how exactly does that work??? Drop me a note offline if you'd like. I'm always curious about other software and mechanism they employ to accomplish given tasks.

    michaelr is my email at Magenic.com

    Wednesday, September 13, 2006 5:28 PM
  • We were not using TeamTrack but the PVCS Tracker application (before the Merant/Serena merger). Bulk transactions were executed as follows:
    - run a query
    - select all items you want to update
    - select the field (only one per transaction) you want update
    - select a new value for the field
    - click OK
    You had following options (rights protected)
    - override dependent and transition field rules (great for breaking built-in rules, eg: when dropping a bunch of items that are no longer of interest without having to specify all 'normally' required fields
    - disable notifications (users are not notified of the changes made)
    This was a great feature we are now missing in VSTS.
    The only thing we could not do, was adding a note for bulk updates.
    Friday, September 15, 2006 2:41 PM
  • yep that is pretty much how TeamTrack works as well.

    1. Create a mass transition "report"
    2. Run report and select the requests (i.e. work items) you want to update.
    3. Put in the value of the field you want to update.  E.g. State = "Deployed To Test"
    4. Run the report and you're done.

    We also use it to update the "Business Description" when the technical writers want to update a number of requets (i.e. work items) with the same Business Description.

    Works pretty slick.


     

     

     

    Tuesday, October 3, 2006 8:57 PM
  • The Team System Web Access tool has the ability to do a bulk edit within the app, but I think it's limited to a few fields.  It would be nice to be able to do the same thing within Team Explorer, but with all fields available.  The Excel option does work great in the meantime.
    Friday, June 8, 2007 12:27 PM