Skip to main content

Azure Devops - work items bulk import-update-publish to Devops using Excel

#cloud #azure #devops

Hi All!

As a azure devops guys and work on scrum or any other methodologies, we have many chances to update our tasks in devops.

There are chances that project manager and/or project lead need to work on consolidated work items for presentation.

We can update our task one by one individually which takes more time and Consider the below scenaio.

  1. Project lead or we need to modify the state of 100 work items.
  2. More than 15 work items title need to be modified.

To achieve the above with minimal effort and time, we have Azure Devops Office Integration feature which will help us to work on excel and update the work items altogether from excel to Devops all at once.

Here before, we used query in Devops and then we would export into CSV. Now with the help of above software, we can work in an excel for updation very easily.

Please look into the below images.

In the first image before installed the software, we have no Team option. After installation we could see it at the end of menu section.

In the second image, after clicked the New List

  1. we need to connect to our devops organization/account
  2. Select the project from where you need the task(s)

In the third image, I modified the titles of 2 work items and then publish them. After publish and refresh the devops page, published changes affected in Devops

We can change the state of multiple tasks all at a time and publish.

In this post, I used only 2 work items for an illustration but it helps us for lot of work items altogether all at once.

To Download the software, Click the below link
Azure DevOps Office® Integration 2019

Hope this post will be helpful. Play around it. Cheers!

Comments

Post a Comment

Popular posts from this blog

View powershell history and invoke Hi All! When you do administration activities, you may need to work around with multiple commands in powershell. It is bit difficul to remember all the commands we tried because some of them may be fetched from internet. Consider you tried more than 100 commands in current powershell session and may require to try the same large command. One of the way is you can press up arrow many times to see the previously tried command. we have another easy way is to see the history and invoke it by using its order number instead of whole command typing. Please look into the below example
Post a Comment
Read more
Wow! Monitor web apps running in azure VM and VMSS via app insights Hi All! Application insights monitors the telemetry of web applications, function app, APIM and etc., Consider a scenario that your organization has some web applications hosted in IIS of an azure VM and they want to monitor performance of those applications. Azure VM was not the eligible candidate to map with Application insights then how can we monitor app(s) running inside azure VM? Now azure offers the feature of monitoring azure vm's web applications through application insights generally available. Please follow the below steps and have a look into the picture You need to have a connection string of an existing application insights. If have, copy it. Go to the VM which has web apps running in IIS Click "Extension+applications" and then click Add Find Application insights agent for .NET and click next Paste the copied connection string of app insights and click Review+Cre...
Post a Comment
Read more
While loop with head and tail in linux Hi All! In today's post we're going to see/refresh about while loop with head and tail in bash. head - Read the first top 'n' lines. Example: head -n 5 reads first 5 lines from a file or input. tail - Read the last 'n' lines. Example: tail -n 5 reads last 5 lines from a file or input. Please look into the below image we have a txt file called file1.txt which has 3 lines of text and we read using head and tail as above.
Post a Comment
Read more