VSTS RollUp is a web service which provides summed values of select fields for all child work items of a parent. Most project managers are interested in getting rollup of estimated or completed work, effort etc. Hence RollUp will automate the process of summing up the Effort fields, viz., Original Estimate, Remaining Work and Completed Work from child work item Tasks and show it at Requirement level, in the same fashion show summation of effort fields of all child Requirements(PBI/User Story) at Feature level and continues for Epic level. Once you register your VSTS Team Project with Canarys-VSTS RollUp service, it will create the following items: • Creates 3 Service Hooks viz., Work Item Create, Work Item Update and Work Item Restore • Creates a Query listing the hierarchical work items with effort fields • A Dashboard showing the query on you VSTS Team Project home page
Before You Start
Below are the pre-requisites to get your VSTS Team Project registered for RollUp web service: You will need a Visual Studio Team Services (VSTS) account - if you do not have one, you can create one now - https://www.visualstudio.com/team-services
• You will need a Personal Access Token for the account. An overview of Personal Access Tokens (PAT) with instructions to create PAT is available here - https://www.visualstudio.com/en-us/docs/setup-admin/team-services/use-personal-access-tokens-to-authenticate • Create web Service hook using this tool, please refer below section • Once web service is created using this tool, test the service once to activate them. Please refer below section.
How to Create Service Hooks • Sign into the tool using your VSTS credentials. You will find sign-in button below. • After successful, select the VSTS Account and Team Project for which you want to create service hooks. • Provide Personal Access Token (PAT). Click on Create Hook Button. • After successful creation of service hook, you need to test it once to activate the hooks. • Click on the VSTS Project link provided in Success message. Go to Web Service Hook section. You will find 3 web hooks created, click on ellipse button for each hook and click edit. Click on Test button • That’s it! Now when you modify the effort fields in Task and save item, RollUp service will run in the backend and sums-up the efforts and updates the parent-level items.
Share your experiences, feature requests and feedback on our email