There have been occasions where I've wanted to create work items in bulk.
For example: Every time you create a User Story your team has several standard Tasks that need to be created. Write Test Cases, Execute test cases, Deploy to QA, etc. I don't want to manually go through dozens or work items adding the same set of work items as children to each one over and over.
Excel is a pretty good option, certainly faster than doing it one at a time via Team Explorer or the Web interface. In the past I have written C# applications to do this through the TFS API. This works great and is very easy to code.
I am always trying to force myself to get better with PowerShell, so I started searching for examples of calling the TFS API from PowerShell. This helped me piece together the parts I needed to solve this problem with PowerShell.
These were my requirements:
As you can see a simple cut and paste in Excel won't do, because I would still have to edit each work item to add the report name to the title and populate the fields from the parent that I want brought over.
PowerShell to the rescue
if ( (Get-PSSnapin
#Get the TFS Collection
#Get the WorkItemStore Service
#Get the Team Project
"Team Project Collection: "$teamProjectCollection
#Write a query to get the parent work items
$ws.Query("SELECT [System.Id] FROM WorkItems WHERE [System.AssignedTo] = 'Dave Lloyd' ")
#the Sub Stories you want to create as Children
= @( "Report Attributes","Data Lineage","Gap Analysis","Impact Analysis","Remediation","Testing")
#For each Parent Work item
$WorkItemParent.ID "-" $WorkItemParent.Title
#For each Parent create 6 New User Stories
#Append the Parent Title to the end of the Child Title
#System fields like title can be referenced directly and show up in intelliSence
$workItemChild.Title = $childTitle
" for "
#There is an order so I used a counter to set the Stack Rank on the CHild Stories
#For non-system fields use the fields member the name of the field and the value property
$workItemChild.Fields["Stack Rank"].value =
#take any fields from the parent that you want to bring down into the child
$workItemChild.AreaId = $WorkItemParent.AreaId
" Child workItem"
#Link the CHild work item to the Parent Work item
Microsoft has released a DevOps self-assessment online tool that allows you to gauge your readiness in the 7 key DevOps practice areas. Complete the form below to step through the assessment and see your results including guidance on which areas to focus on next. Total time commitment is approximately 10 minutes. DevOps self-assessment tool can be found at http://devopsassessment.azurewebsites.net/
Installing TFS 2015 hosted build/release agent is extremely easy:
- Open TFS Web Access
- Click on Settings in the top right corner
- Click on project collection in the breadcrumbs
- Click on Download agent link to download .zip file with build/release agent in it. Right click on downloaded .zip file, click on Properties and Unblock the files if it is blocked
- Now the tricky part, the installation of build/release agent is essentially unzipping the file into a folder. Please make sure that you unzip the file into a folder that is not under your user profiles (for example, Downloads or Documents) or Program files folders, because this will cause UAC to kick in when build/release job will try to call to build/release agent. So, unzip folder somewhere like D:\BuildAgent\. Once you've unzipped the file into a folder, you have installed build/release agent. Now we need to configure it.
- Open PowerShell (preferably as administrator), and browse to the folder where you unzipped the build/release agent
- Run ConfigureAgent.ps1 and follow the wizard
That's it. Easy…
In the new TFS 2015/VSO build, you can save the output to the server or to the good old drop location. If you would like to use the drop location, you will need to remember to specify how you would like the output to be stored. What I mean is that you will have to specify in the build definition the folder structure you would like to create. For example, instead of \\servername\drop, you will need to specify \\servername\drop\$(Build.DefinitionName)\$(Build.BuildNumber)\
There are quite a few system/metadata variables in TFS 2015, but that will be another blog post.
UPDATE: There is now Publish Build Artifact action in new TFS Build that you should use to control where and how your build output is produced.
P.S. : If you're not using new TFS 2015/VSO build system, you should give it a try. It's awesome.
It has been a while since we were able to write PowerShell scripts against TFS. For those who has not tried it yet, give it a shot. It's actually very easy to use and powerful tool. For those who has not tried PowerShell yet, I strongly encourage you to do that. There is no escape, PowerShell is everywhere J
Anyways, here is what you need to do to be able to write PowerShell script against TFS:
- Make sure you have PowerShell 3.0 installed or better. PowerShell is part of Windows Management Framework. To get PowerShell 3.0, you need to download and install Windows Management Framework 3.0 from https://www.microsoft.com/en-ca/download/details.aspx?id=34595. You might have to reboot your machine after this install.
- You also to download and install Windows PowerShell Cmdlets. This tool provides a Windows PowerShell interface that supports basic version control commands and a pipeline and glue to enable scripting. Windows PowerShell Cmdlets for TFS are part of Microsoft Visual Studio Team Foundation Server Power Tools that can be found at https://visualstudiogallery.msdn.microsoft.com/f017b10c-02b4-4d6d-9845-58a06545627f. Just make sure that you pick PowerShell component during the install.
That's it. Happy scripting.
Couldn't go to //Build/? Not to worry Build is coming to you.
June 12th at the Design Exchange you can see Joe Stegma, Jeff Burtoft, Nikola Metulev and Vlad Kolesnikov deliver a day of sessions from Build.
8:00 - close
8:00 - 9:00
9:00 - 10:30
10:30 - 10:45
10:45 - 11:45
Session #1 Universal Windows Platform
11:45 - 12:45
12:45 - 13:00
13:00 - 14:00
Session #2 Microsoft Edge & Web Apps
14:00 - 15:00
Session #3 Lightning Talks
15:00 - 15:30
15:30 - 16:45
16:45 - 17:00
Register here or if you can't get there but would like to join the Live Webcast register here.
ObjectSharp's At the Movies event is back in town. It's is going to be awesome! And, not just because of the good looking and courageous Captain America in the last event poster. J So, mark May 13th in your calendar and join us for the free and highly informative geek event. As usual, it will cover all the latest and greatest technologies:
- The new TFS 2015 with its new completely overhauled build and release tools, improvements to backlog management, the kanban board, the task board, card customization and more. A lot more… And, yes, the long awaited project rename capability… Presented and demoed by Microsoft MVPs in Visual Studio ALM - Dave Lloyd and Max Yermakhanov
- All the latest and the most excellent changes to Azure, and there are quite a few of those… Presented and demoed by Shane Castle
- All the coolest and most amazing technical news and changes that were announced in Build 2015 that would be relevant to you now and in the near future… Presented and demoed by Lori Lalonde
As I said, it will be awesome! And, it's not just for developers. It's for DevOps as well. It's for any IT person who had a pleasure to work with Azure or Team Foundation Server. Think about, Dave's and my session will cover builds and deployments using TFS. That's DevOps and Ops. Shane's session will cover Azure. That's again, DevOps and Ops related. Lori's and Dave's session will have quite a bit of DevOps and Ops goodness too.
So, don't wait. Register today at http://www.objectsharp.com/atm! It's free! it's fun! And, you will learn a thing or two J
If you haven't registered what are you waiting for?
Click the movie poster below to Register.
World-class free online conference that features technical content presented by Americas' region MVPs that is open to the public
More technical content (Level 200, 300, 400), less marketing
5 tracks: IT Pro English, Dev English, Consumer English, Mixed Spanish, Mixed Portuguese
Event will be broadcast via Lync using L+ which enhances the conferencing capabilities of Lync
Two full days of sessions with simultaneous webcasts running across all 5 tracks
Thursday May 14th and Friday, May 15th
Start at 8am PT and running until 6pm PT (Pacific)
Day 1: 45 sessions + Keynote, Day 2: 50 sessions
Keynote on Day 1 to be delivered by Steve 'Guggs' Guggenheimer, Corporate VP of DX
On Demand content available via Channel9
This event is not just for MVPs, it's for everyone!
Here are a couple of offers from Microsoft you may want to take advantage of.
Enjoy the free stuff, and you're welcome.