Azure DevOps - Lesson 08 | Import Work Items | Import Test Cases from Excel to Azure DevOps
ฝัง
- เผยแพร่เมื่อ 7 ก.พ. 2025
- Azure DevOps Test Management | Work Items Bulk Upload to Azure DevOps | Import Test Cases from Excel to Azure DevOps | Import Work Items from CSV file to Azure DevOps | Test Case Design using Test Plan Grid View
Azure DevOps Total 30 Lessons Playlist
• Azure DevOps and Conti...
I was looking for this video past many days and eventually found it 👍
Thank you. Please subscribe to my channel
I have just started looking your videos. So far so good
Please subscribe to channel
Thanks Ravi for the Video, it refreshed my memories
Awesome!! Glad you visited my channel 🙏
Such a helpful video. Thanks 🙏🏻
Thank you Prakyath, please subscribe to my channel for more videos.
any suggestion how to upload Test Cases with Test Steps ??
I am trying to import Child work items to a Prent work item along with Description. How do I mention to keep/not change the Description of Parent. If I leave Description of Parent in CSV as blank, import is complaining that Description is mandatory, but I don't want to specify the existing Description of Parent in CSV as it is very lengthy
I want to learn it from the begining from registration to creating company and so on. Please give me the link for the previous video to the current video as I am assuming that, the prev video is the start of this course..
Please subscribe to my channel for more videos. Here is the play list of all Azure DevOps videos. You can find everything in this play list
th-cam.com/play/PLkLerKPSoQ_M1kA_FzK1106ZsJdSZFIhp.html
@@RavikanthReddy I have subscribed it already.. thanks for responding.I live in hyderabad and I want to work as a scrum master. I belong to human capital management industry, n I work as a qa and take care of my clients payroll.. do u have an opinion on this
Ravikanth, there was a video on Azure Boards- Queries which is missing, am I not seeing it which is available somewhere in your videos? Pls help
How to run entire test suite with multiple subfolders in bulk
Hello Ravi can you please attach sample csv files link bcoz when I am exporting csv it is throwing error like invalid ID, work item type etc
Can you please make a video how to create team and table design
My connection keeps breaking with 365 login or something, then i have to recreate the link and columns from scratch, since it won't use the headers already there. 4 Times now! How can i fix this or recover it faster.
Hello @RavikanthReddy could you please share a sample csv file as I am getting errors:
Invalid column headers: Title;Work Item Type;State;Effort;Business Value;Value Area;Area Path;Tags;Project.
Missing required column headers: Title, Work Item Type. Thank you.
Very interesting and useful video.
I wanted to ask you one thing, but if I wanted to import a csv in which one of the columns contains text with commas how do I get them accepted by the import and not make it break due to the extra commas he sees as a column separator ?
One General Question. This is regarding User story
Is there a way we could create predefined tasks in Azure when a User story is created.
For example- When I create a User story, I want one dev task and one test task should be created along with the user story
Hi Sandeep, we don't have such option in Azure DevOps. We have to create tasks
Manually
So much knowledge.. thanks for the videos . Please just take care of back ground noise while recording.
Sure. please subscribe to channel
Thanks for the video. It was helpful. While importing the work items ( Bug ), is it possible to update the excel / csv sheet with the additional columns of "System Info" and "Discussions". If yes, can you please let us know accordingly.
Yes, we can add additional columns. You can refer to my other videos
Is there any way you can delete existing work items?
Hi suppose i have 5 test step under 1 test case how do i upload it? or how can i manage this issue of adding test steps?
Hi Vini, please subscribe my channel. You cannot upload test steps from excel sheet using Teams Add-in. However, Azure DevOps providing an alternative option called 'Grid view' where you can copy all the test cases from excel to Azure DevOps Grid available in Test Plans
@@RavikanthReddy done subscribed✌
Thank you
@@RavikanthReddyhow to add test steps from Excel to the testcases can you please explain
Hi sir
Do u provide training in the se technology
Send an email to me ravikanth@ficusroot.com for more details
@@RavikanthReddy please check mail sir
How to include test steps?
Is there a way we could import steps also in the bulk test case upload?
No, as of now Azure DevOps doesn't have such feature
@@RavikanthReddy okay thank you for your reply.
Hi Sir, does that mean if I have more than 1 test steps, I cannot use bulk upload feature?
Have you found any way to do that?
@@RavikanthReddyis there any feature as of now?
Hi Ravi, How do we get User Story Work Item Imported? After doing a connection I dont see Story in the Work Item type drop down..can you please advise.
Refer my latest videos to understand the same
Azure DevOps and Continuous Integration Concepts for IT Corporation: th-cam.com/play/PLkLerKPSoQ_M1kA_FzK1106ZsJdSZFIhp.html
Please subscribe to channel
@@RavikanthReddy Bro I have already Cheerss...
@@vs8738 😀
How to migrate with sprints?
How to export test cases from one project and upload it to another project ?
I tried it to export in CSV and upload the same in another project but it said it could not be possible. Is there any way to do it?
Hi Arun, please subscribe to the channel. We have to upload test cases as same as we upload the new test cases. You need to remove the unique IDs freon excel sheet that got generated
Hi,
do you provide training in this technology.
Please drop an email to ravikanth@ficusroot.com or ravikaanthe@outlook.com
Hi Ravikanth,
how to get the "Team" tab in excel? is there any plugin that i should be installing to get this tab?
Yes there a TFS integrator that needs to be downloaded. I have explained this in one video related to azure develops. Please go through it
And subscribe to channel for more info
Thank you for your reply. Will check out the video and subscribe
Ravikanth Reddy , could u plz say whats that video. so that i wil go n watch it. i need to get team option in excel
@santosh, did you get it? how to add Team tab?
How do i Import test Cases in to the DevOps ?
Please follow my videos Srinu
Hi, how to bulk upload test cases with Test steps also.
Hi Sanjay, currently Azure doesn't support test steps upload. We need to create an API tti upload test cases
Please subscribe to channel, soon i will be publishing the method to upload test steps as well in azure
@@RavikanthReddy did you find a way to upload test cases with test steps ?
@@RavikanthReddy did you find a way to upload test cases with test steps?
@@Ellaz201 Go to 26:55 of his video here and that might help you th-cam.com/video/abrEhuKNxTg/w-d-xo.html
Hi, Thank You for the Video its useful. Thumbs Up...
I have a query i did add in extra column like Description Acceptance Criteria Story Points
similar to available in azure, however I see that the text data under these column is not displayed when import is done... its blank column only.
Hi Vaibhav, Please do subscribe to my channel. Yes, Azure do not support importing work items description and Acceptance Criteria as of now. They might include that in future releases
Done @@RavikanthReddy but whats the alternative? I need to import my data from service now into boards...
Hello Brother can you please make video how to install Team foundation server, Why I can't see team option in my Excel, is it because of office standalone server or what??
\
You have to install TEAMS plugin, provided by Azure devops. I have explained this in one of the videos related to important test cases.
@@RavikanthReddy Thanks for the videos. Please share the video that how to add team options in excel
poor sound quality makes this difficult to understan
Is it voice not clear or is there any background noise?? Please suggest, so that I can correct in next videos. As of now I don't have such complaints. Sorry for the inconvenience
@@RavikanthReddy The audio sounds quite heavily compressed. It might be your mic or a setting you need to change in the recording options, to ensure you're recording at the high bitrate?
Tab