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

Azure Static Web Apps - Plan Comparison #cloud #azure Hi All! Azure Static web app is a good service when we have static web apps like javacript frameworks and libraries applictions (Ex: Angular, React, Svelte, Vue, Blazor). It also supports Python 3.10 based static web app as well as per the latest azure news. Other advantage of it is coupled with your Azure AD. so that your code can be directly pushed to azure static web app via either Azure DevOps or Github whenever code push occurs. At the time of azure static web app creation, it asks for deployment source as any one of the below. Based on the selection, it allows you to select the organization, project and repositories from the source. Azure DevOps - Azure AD connected Devops organizations will be listed out Github Other - For ex: If you want to deploy code from other organization. Below table will be helpful to choose the best pricing plan for your workload. Plan/Feature Free Standard ...
1 comment
Read more
Azure Blob - Convert blob access tier on Page and append blobs Hi All Azure storage account is one of the mostly used service by many people and it has page, append and block blob types on storage blob. To have blobs in "Hot" tier incur some more cost but it is prffered for frequently accessed. so if our blob is required but less access then we can change its access tier to keep it with low cost then at the time of need we can change it back to original type. we can set access tier only for block blobs. For remaining blob types, there is no direct way to set access tiers. so how can we achieve it? we need to change blob type to block blob and apply access tier for it then when we need original blob with appropriate, we need to typecast from the recent one we converted. In the below image, Initially I have an append blob called "1.JPG". when you see it, you could not see its access tier whereas bloc blob shows as "Hot" Now, Let's...
1 comment
Read more
What IP address I can not get it from Azure subnet CIDR to azure resource(s)? What? Will I not be able to get some IP(s) from subnet? How many IP(s) I am not able to get and what are they and why? Azure Virtual Network is one of the main service from azure to create private network in cloud. subnet is the main part of Vnet for segregation. while creating a subnet we have to define CIDR. If I create /24 mask subnet, I should get 256 IP(s) but why am I not getting 256 fully for my resources. I can get only 251 IP(s) because azure reserves 5 IPs from every subnet. consider I'm creating a subnet called DMZ with subnet/cidr range as 10.1.2.0/24 and I'm going to get IP(s) from 10.1.2.4, 10.1.2.5, 10.1.2.6.......10.1.2.254 and please look into the below table for the reason and IP why they are not able to assign to user created azure resources. IP Purpose 10.1.2.0 Network address 10.1.2.1 Reserved by Azure for the defau...
1 comment
Read more