How to display query from TFS into excel?

You want to work with excel files, that will be great but you dont need to COPY-PASTE the data from TFS, its too many thing to do, maybe other Dev or QA or BA may adding new record in TFS, then no need to double check open and close the TFS many times. Use the step below so you can automatically have the update data from TFS by working on Excel files.

1) Open Microsoft Excel

2) Under Team tab, click on New List button

 3) Connect to TFS window is displayed. Choose Servers, Team Project Collection and Team Project to be open. Click on Connect button.

 4)  New List window is displayed. Tick on Query List radio button and choose the Query available in TFS. Then click on OK button.

 5) Select Query window is displayed. Select the query available in TFS and click on OK button

 6) Verify the excel files. New table is generate in the line.

 7) Select any rows or column and tick on Refresh button to get the update data.

Awesome, right? Cheers..

How to Select All and Tick the box for configuration at "Select Test Configuration" in MTM VS2010

Tired to click one-by-one on the box to set the configurations for each test cases "Select Test Configuration" in MTM. So here is the how the shortcut works.

1) Select all test cases that need to configure. Verify Contents template will be displayed like below snapshot. "Select Test Configurations".

2) Tick on "Enable range selection...." at the bottom checkbox.

 3) Click on selected box as starter. Verify the box line is [........], like below snapshot.

4) Enter Shift on keyboard while click on selected box as end section. Verify the other box line is in bold line

 5)  Click on the box with [.....] dot line. Verify the box highlighted is checked/ticked.

ASP.NET is not exists in the IIS Web Service Extensions

Let say you found this problem, don't panic. No need to worry. Just need to install the ASP.NET on IIS that all. Here is the step you can follow.

1) Click open Control Panel and click Program and Features (using Window 7) or click Add or Remove Program (using Window XP)

2) Click on "Turn Windows features on or off". Window Component Wizard will displayed

3) Tick on Application Server checkbox.

4) Click on Details button

 

5) Then click on OK button to start install

 

 6) Verify in IIS the ASP.NET Web Services Extensions is available

Search Test View in VS 2012

The VS 2012 UI is so awesome and nice than VS2010. So in this version VS 2012, the Microsoft have change the Test View window name. Test View is use to show the list of Unit Test, Coded UI and Ordered Test that are ready to be run for testing.

In VS 2010 its called as Test View, while in VS 2012 its called as Test Explorer

Using VS 2010

Using VS 2012