Friday, April 9, 2010

Tool for import word test case documents to Microsoft Test Manager

Updates to my extensions of the TestCase Migrator Tool http://mskold.blogspot.com/2010/06/updates-to-my-extensions-of-testcase.html

Recently I had a case there I needed to import old test cases written in word into Microsoft Test Manager. I looked around for a tool capable of importing an ordinary test case written in word, but I didn't find any tool or solution.

Word - the world's most used test tool ?
In my experience most projects who have had formalized test cases has done them in word documents containing test case information (title of the test case, description, pre-conditions, use case identification) and test steps. The test steps has the format of a table with columns for actions and expected results.

Test Case Migration Tool on codeplex
The best match I found was the Test Case Migrator Tool on codeplex (http://tcmimport.codeplex.com). With this tool I could import Excel test cases and MTH files (Microsoft's word template for test cases from earlier versions of Microsoft Test Edition). This looked like a promising tool but when I tried it on our existing test cases written by a standard test case template the tool didn't manage to import the test cases. It seemed the tool was to hard connected to the structure of the MTH template.

Extending the Test case migration Tool
As the project was on codeplex with the source code available I did take a look to see if I could adopt the tool to our template. As the tool had a nice separation of the logic for parsing and importing data sources , I simply created a new data source and wrote my own parsing logic for our template. At first i simply replaced the MTH data source with my, but ones I got the parsing logic to work I started to integrate it as a new data source in the UI. This turned out to be a bigger task then writing the parsing logic. It took some time but at least the result looks good.

The extended Test Case Migration Tool is available
I have uploaded both the compiled version and the source with my modifications as I guess many other will find themselves in the same situation as I was - looking for a tool to batch import word test cases. Hopefully this could be a solution for some of you .
Upplagd av kl.
Etiketter: ,

11 comments:

  1. AlexJuly 28, 2010 at 1:20 AM

    This morning something happened with my .doc files. I didn't understand because of all of them were corrupted. To my good fortune I by accident discovered - fix corrupted word files on the Inet. The tool worked out my issue effortlessly...

    ReplyDelete
  2. AnonymousFebruary 6, 2012 at 8:45 PM

    thanks

    ReplyDelete
  3. pdf digital signatureFebruary 17, 2012 at 12:53 PM

    I came across a similar requirement and I also finalized to use codeplex but as you gave an extended tool for Test Case Migration so I'll give it a try too and will update you about my result.Thanks

    ReplyDelete
  4. Jayprakash ParmarJuly 19, 2013 at 8:48 AM

    Thanks the tool helped to upload the Test cases...

    ReplyDelete
  5. AnonymousAugust 26, 2013 at 7:37 AM

    Hi, is there a tool to export the list of defects from excel to Test Manager "Defect" module?

    ReplyDelete
    Replies
    1. MattiasAugust 28, 2013 at 10:20 PM

      As you want to export defects from excel to tfs, I assumes you don't have any external data, like attachments for example, linked to your defects ?
      In such case, YES, MTM stores its defects in TFS Work Item Tracking, and you can both read and publish work items to TFS.
      The simpliest way is to open a "Bug" query to excel (from within Visual Studio), copy and paste the data you want to export to tfs into the opened excel workbook, and then select Publish from the team menu.

      Delete
  6. AnonymousOctober 24, 2013 at 8:55 AM

    Hi, I appreciate your work. Thanks for it. But I have multiple test cases in different MS Word files with different test steps and data . Will your extended Test Case Migration Tool be compatible with all these files ?

    Please reply soon...

    ReplyDelete
  7. Taylor November 1, 2018 at 4:10 PM

    One program is Cute PDF Writer. This is a free for individual utilize program that relies on Ghostscript programming to deliver PDF documents. https://www.altoconvertpdftoword.com/faq

    ReplyDelete
  8. StevenJanuary 14, 2019 at 10:34 AM

    Nonetheless, this requires a month to month membership. On the off chance that you just need to convert a couple of records, you might have the capacity to do as such by utilizing the free preliminary membership. https://altomerge.com/blog/how_to_merge_pdf_documents

    ReplyDelete
  9. JennetMarch 2, 2019 at 2:07 PM

    As understudies coordinate technology into finding out about and doing science, accentuation ought to be set on the most proficient method to thoroughly consider issues and undertakings, not exactly what to think. diebesten vpn

    ReplyDelete
  10. Jack DowsonJune 2, 2023 at 11:23 PM

    Organizations begin to put more into their advanced promoting. As displayed in the concentrate by RNTS Media, there was a specific development in the area of automatic exchanging. It is a crucial constituent of computerized promoting liable for inception and execution of online arrangements and calculations compromise. In 2013, just 7% of US publicists had financial plans for web based publicizing, in 2015, there were at that point 32% of financial plan apportioned for computerized promoting, which is essential to any new AdTech advancement organization available. Developing of versatile publicizing or the "third screen" will prompt further development of AdTech. Individuals invest increasingly more energy online in their telephones, utilizing applications, web-based entertainment organizations, or programs, and this implies that this is another huge region for internet promoting.>> Mobilunity

    ReplyDelete

Subscribe to: Post Comments (Atom)