Saturday, 2 April 2011

Test Link: Import Excel of test Requirement and test suite (support multi steps cases)

This contains the VB macros and sample test suite to be used to import into Testlink 9.2 and above version. Here the test suite example is something which has multiple columns to refer different fields for test cases based on the tester needs and also included 2 custom fields. Moreover, this will take care of requirement reference of each test cases.
The excel includes following 3 featured macros.
Ø  Generate Requirement XML : Which will eliminate duplicate of requirement and take unique requirement to XML
Ø  Generate test suite XML : Has ability create multiple suite base on the test case template. Also take care about incorporating multiple test steps for a test case into XML
Ø  Generate both Requirement and Test suite XML
Steps:
·         Run the micros
·         Go to desktop and get the generated XMLs
·         Import the test suite or requirement to Test Link 9.2 or above

Click Here for Macros


See below screenshot for Sample excel of test suite

- Enjoy the test management life
 Thanks - S.Janagan


13 comments:

  1. Could you post the xls itself with the macros?

    ReplyDelete
  2. HI Jana,

    appreciate if you can provide me this testlink excel copy.

    it would really help my team.

    bernardtan.jenn@gmail.com

    ReplyDelete
  3. Can u pls post here the xls with macro..

    ReplyDelete
  4. Hello,

    would you provide me the excel file ?
    sendmebytes@gmail.com

    Many Thanks !

    ReplyDelete
  5. Here is a program that you can use to conver test cases in xml to xls: https://sourceforge.net/projects/xlstoxml/ :)

    ReplyDelete
  6. Hi Jana,

    I would also much appreciate if you could provide me this testlink excel copy.

    it would really help my team also !

    KR
    A. DELCOURT
    adelaide.delcourt@gmail.com

    ReplyDelete
  7. Hi,

    May I have a copy too? Thanks! :)

    Best Regards,
    Vincent
    giraud.vincent@gmail.com

    ReplyDelete
  8. Hi
    Could you also send me a copy of this sheet ?
    Kind Regards,
    Markus
    markus.kali4@gmail.com

    ReplyDelete
  9. Could you send me copy of your excel with macros.

    Regards

    mail: mbekil@thy.com

    Metin

    ReplyDelete
  10. Could you send me copy of your excel with macros.

    Regards

    mail: mbekil@thy.com

    Metin

    ReplyDelete
  11. Could you please send me the excel file.

    ReplyDelete
  12. Regards for this terrific post, I am glad I discovered this site on yahoo. Venito

    ReplyDelete
  13. I’ve been exploring for a little for any high quality articles or blog posts on this kind of area . Exploring in Yahoo I at last stumbled upon this website. Reading this info So i’m happy to convey that I’ve a very good uncanny feeling I discovered just what I needed. I most certainly will make sure to don’t forget this website and give it a look regularly. Leather Watch Bands

    ReplyDelete