Setting Email Alerts in Team system 2008

In the new release of the "Power Tools" (located here) there is a new tool that sets email Alerts.

In this post I will show how to use this tool.

First I have installed the "Power Tools" and opened my Team Explorer, there are two new folders in my menu: "Work Item Templates" that will be covered in a different post and the "Alerts"

Double Click the Alerts folder.

The Alerts window will be opened.

Click the New button to create a new alert.

The Alert Settings window is opened.

The Alert Settings Window contains 3 groups of alerts.
Each of the groups contains out of the box alerts (Marked in green pen) and the ability to create a new alert (Marked in blue pen).

Choosing out of the box alert will automatically fill all the settings.

 Choosing the [Blank Alert] option will open the settings with one line filled automatically.

Filling the settings is very simple, just choose the field operator and the desired value.
In my example I have asked to be alerted for all the change requests in Agile_Test2 project.

 Enjoy using this grate tool!!!

How To Work with Team System using Excel - Introduction

One of the most powerful tools in the Team System is the Excel, when I say Excel I mean the good old Excel tool that we have in our Office tools.

Team System is integrated with Excel which gives the user the ability to use all the grate features of the Excel and still work directly with the TFS (Team Foundation Server), for example lets say I need to change the state field of 100 work items from Proposed to Active, with the Team Explorer I will need to go one by one and change its state but with the Excel all I will do is change one and drag the cell to all the rest, publish my changes and that is it.

When I look at my customers using the Team System I see users that don't really understand the full potential that is hidden in this grate tool so for them and for all the rest of our readers I decided to dedicate this blog post and 6 of my future blog posts to write a guide that will (hopefully) cover the main features.

These days I am participating in a unique project at one of our customers sites, the project is a beta implementation of the Team System code name "Rosario".
Unfortunately I can't talk about any of the things we are doing there but I like to dedicate the last 2 posts of this guide to the Rosario new features added to Excel.
All features that I will show in these 2 posts are already available in the CTP12 that was already released so you can start evaluating them.

These are the blog posts subjects:

1. Introduction - This is the current blog post that opens the guide. 
2. Export to Excel - I will show different ways to export work items from the Team explorer to Excel, I will add one more option later when I present the Rosario.
3. Choose Columns - I will explain how to set the columns in the document to get the maximum efficiency and conformability and I will present the most important and helpful columns.
4. Publish and Refresh - I will explain how to Publish and to deal with publish problems, I will also explain how to refresh the data and how to control what we are refreshing.
5. Get Work items and Change List Configuration options - I will show how we can change the list of work items so you will have better control over your items.
6. Rosario: Parent Child relation - I will show how to add children to items and how it is shown in the Excel, I will also add one more option for the export from the Team Explorer.
7. Rosario: Generate Reports - I will show how to create reports with a click of a button and how to configure them in the Rosario.

See you on the next post...