All these days I was getting emails from people asking about where they can download this tool.
As I mentioned before also that I was working on few modifications in the tool and also I was bit busy, so got bit delayed... :)
But now the wait is over. "Test Case Export to Excel 1.0" is now available for download along with few enhancements.
As mentioned in the previous post, user has to first connect to the Team Foundation Server and then to the Team Project. After connecting to the Team Project, the Test Plans were populated in the dropdown box; and based on the selection of the Test Plan the Test Suites at the root level were being populated in the next dropdown box. Thus, the user has the limitation to select only the Test Suite present directly under Test Plan, also all the test cases that were present under the selected Test Suite and Sub Suites will be exported.
But now in the enhanced version i.e. "Test Case Export to Excel 1.0" user gets the complete view of the Test Plans and all the Test Suite in the form of tree structure, similar to the way it is displayed in MS Test Manager. Also, user is now having the flexibility select the test cases he/she wants to export. He/She can either choose to export the test cases present under the selected Test Suite or to export test cases present under selected Test Suite and its Sub Suites. Below is the screenshot of the enhanced version of the tool.
If you want to download the tool you can download it from the following codeplex site:
http://exporttfs2excel.codeplex.com/
Please post your comments or suggestions on this tool. Also, if you face any issues in the tool, please let me know.
11 comments:
Hi,
Thanks for this great idea, I have a little problem though : when launching the export, i have the following fatal error :
"Unable to cast object of type Microsoft.TeamFoundation.TestManagement.Client.SharedStepReference to type Microsoft.TeamFoundation.TestManagement.Client.ITestStep Application has encountered Fatal Error.
Please contact your System Administrator"
Any clue ?
Thanks again,
Tom.
hi Raghav,
I downloaded the Application from the Link Mentioned in the http://raghavranjan.co.cc/
But when we say Export it throws an Error saying "Has encountered problem and needs to close. We apologize for the inconvenience" both in Widnows XP and Windows 7
Any Idea of what is Happening ?
thanks in advancce
Hi,
nice idea but it doesn´t work for me.
I have the same problem as Tom. when launching the export, i have the following fatal error :
"Unable to cast object of type Microsoft.TeamFoundation.TestManagement.Client.SharedStepReference to type Microsoft.TeamFoundation.TestManagement.Client.ITestStep Application has encountered Fatal Error.
Please contact your System Administrator"
Any idea ???
i try Windows 7 64Bit for my Client
Best regards,
zwergigor.
Hello again,
i try it without Shared Steps and it works.
Ist there any solution for it??
Thanks
zwergigor
As of now the tool will not be able to export the test cases if it includes Shared steps, as Shared Steps as managed as different work items in TFS.
Will try to address this issue in further release.
Thanks, for your work
Is it possible to fix it in future?
zwergigor
Latest version of Test Case Export to Excel is now available for download.
It can now export test cases with shared steps.
Please visit: http://exporttfs2excel.codeplex.com/releases/view/70526 for details.
Hi Raghav,
Thank you very much for providing this tool. This is exactly what I'm looking for and it works beautifully.
Ngoc Vo
Hi Raghav,
Few days ago I downloaded the "Test Case Export To Excel", it worked pretty well. But today, when I use it again, I get a problem. I have 5 test cases in the suite, but the application only exports 3 of them. I've tried many times, but this problem is still exist. Do you have any idea about this issue?
Thanks,
Ngoc Vo
At first thanks for the useful tool.
One of the features which I would like to see there is the ability to show the hierarchy of test suites in the Excel file as it appears in Test Manager.
So let's say if a new suite starts in Excel, there can be a colored row in it with Test Suite name.
I really appreciate your proficient approach. These Measure area unit of measurement unit things of really useful knowledge which is able to be of nice use on behalf of me in future.
Post a Comment