There was a question from a team member how to bulk edit TFS work items. In the past the only answer to this question would be use excel. Open a query in Excel and update and publish. Is there any other way to achieve this easily without doing one by one work item edit in a query result? Query result opened in Web or in Visual Studio you can edit each work item by clicking on each, and then save bulk of work items. But is it possible to change a value of a field for many work items at once. Let’s look at the bulk edit options available with TFS see the possibilities.
Edit Selected Work Items in a Query Result.
You can open a query result in web portal and select the required work items. Then right clicking and click “Edit selected work item(s)”.
In the popup window select the required field and value. You can edit multiple fields. Click OK when done editing.
Save all changes.
You need to have Team tab availability in excel to use Excel to edit TFS work items. If you do not have Team tab in Excel follow the instructions here. To edit work item field in excel it should be available as a column in the query you are using. You can change columns in the query using column options.
Open Selected Work Items in Excel via Visual Studio
Or you can open a new excel document and in the Team tab click New List. Connect to the team foundation server, team project. In the next popup window select the query to open it in Excel.
Do the changes required. Click Publish in Team Tab of Excel.
Change applied to work items.
SQL Server Integration Services (SSIS) projects can be created to perform ETL (Extract Transform and Load) operations. As Implementing of Co...
Generally windows services are deployed by creating an msi installer. It is possible to deploy msi via VSTS/TFS release management using the...
Task groups are really useful to share common actions with multiple build or release pipelines in Azure DevOps (VSTS). You can group multip...
GItHub has a easy way to get raw contents of a file by clicking on Raw button for any code file in GitHub, where it will redirect to url sta...
It is great if the latest updates to TFS can be applied as and when they are released. But for a large organization it might not be sometime...