Team Foundation Server (TFS) 2010 enables the users to manage test cases as Work Item(s). The complete description of the test case along with steps can be managed as single Work Item in TFS 2010.
Before migrating to TFS 2010 many test teams will be using MS Excel to manage the test cases (or test scripts). However, after migrating to TFS 2010, test teams can manage the test cases in the server but there may be need to get the test cases into excel
sheet like approval from Business Analysts or sending it for review to a person who is not having access to the organization’s VPN.
“Test Case Export to Excel” enables the users to export the test cases present in TFS as Work Item(s) to excel sheet. Thus, the users will have backward compatibility with the process they were using.
Visual Studio 2010 offers “Test Manager” that connects to Team Foundation Server for managing the testing artifacts and carrying out end-to-end testing activities.
“Test Case Export to Excel” follows the concept:
- A Team Project consists of Test Plans.
- A Test Plan contains Test Suites.
- A Test Suite can contain Test Cases or Sub-Suites which in turn can contain test cases.
“Test Case Export to Excel” can export the test cases present in a test suite to an excel file. User has the flexibility to export the test cases present in the selected Test Suite only or to export all the test cases present in the selected
Test Suite and the Sub Suites under the selected Test Suite.
“Test Case Export to Excel 1.0” is built on .NET Framework 4.0. Thus, .NET Framework 4.0 is required to be installed on the client machines to run “Test Case Export to Excel 1.0”.
If .NET Framework 4.0 is not present on the client machine, then at the start of installation user will be prompted to install .NET Framework 4.0.
Run the “Test Case Export to Excel Setup.msi” file to install “Test Case Export to Excel 1.0” on a client machine. User will be guided through a GUI wizard for complete installation of “Test Case Export to Excel 1.0”
By default “Test Case Export to Excel 1.0” is installed in ‘Program Files\TFS-API\Test Case Export to Excel’ folder.
A desktop shortcut will be created upon successful installation.
Also, user can access the tool from Programs menu à TFS-API à Test Case Export to Excel 1.0.
5. Running “Test Case Export to Excel 1.0”
“Test Case Export to Excel 1.0” is a GUI based simple tool that guides the users to export test cases from TFS to MS Excel.
5.1 Selecting the “Source”
Source for “Test Case Export to Excel (Beta)” is the Test Suite in Team Foundation Server that contains the test cases.
For selecting the Test Suite you are required to connect to Team Foundation Server and then connect to a Team Project.
For connecting to a Team-Project click the “Connect TFS…” button. You will be presented with a screen with option to connect to a Team-Project.
If there is no Server present in the dropdown box then click the “Servers…” button to add a Server.
You will be presented with dialog to “Add/Remove Team Foundation Server”.
Click on “Add…” button to add details of Team Foundation Server you want to connect.
In “Add Team Foundation Server” dialog you can enter the details of Team Foundation Server that contains your Team-Project.
After successfully connecting to the Team-Project, complete hierarchy of the Test Plans and Test Suites will be displayed in the tree view in the left part of the screen.
Select a “Test Plan” from the available Test Plan(s) in the tree view. User can select the radio button in the right part of the screen to export Test Cases present in the selected Test Suite or to export all the Test Cases present in the selected
Test Suite and the Sub Suites present under selected Test Suite.
5.2 Selecting the “Destination”
Destination is the location where the excel file with exported test cases will be saved.
Select the folder location using the “Browse…” button where you want to save the file.
Specify a valid file name for the excel file.
After entering both “Source” and “destination” details click on “Export” button.
If the fields are populated correctly, export process will start; otherwise error message will be displayed and you are supposed to correct the error(s) before you proceed.
During export, mouse cursor will be shown in busy state. The export may take some time depending upon the data to exported and network speed.
After successful export, a confirmation message will be displayed.
Product information i.e. version detail and developer information is available by clicking on “About” button.
Current product version is 1.0.
Following is the known issues present in version 1.0
If client machine is having version of MS Office higher that 2003, then a compatibility warning is displayed with “Continue” and “Cancel” button. If user clicks “Continue” the excel file is
saved successfully; but if user clicks “Cancel”, application throws “Fatal Error” and terminates.