OnRoad Test Management

Welcome to OnRoad Test Management Sign in | Join | Help
in Search

OnRoad Weblog

March 2007 - Posts

  • Featured Item: How to Export Test Cases with Design Steps from Mercury Quality Center into Excel, part II

    Coming back to this ever so interesting area discussed in here: How to Export Test Cases with Design Steps?

    For this we offer a tool called General Reporting Utility, which is part of Utility Tools for Mercury Quality Center.

    With this utility you can do other types of reporting as well this special report where you can have all test case details with design steps in Excel format for reviews etc.

    The idea behind this utility is that you first select the data you want to appear in your reports and export it from Quality Center. Selection can include various criterias, like requirement, test case, test set, test case in test set, run or defect fields or any combination of these.

    Then you will select which fields you want to include in your reports. Depending on your needs, you can select from Quality Center entities any number of fields or all of them. Including memo fields with or without html tags in them.

    This selection will also narrow down your exported data: if you have set your criteria to certain defect field value and you select test case fields, you will get only those test cases that have linked defects that match your criteria. You can also set your criteria to selected test sets, select all test case fields and as a result, you will get all test case fields which are in your selected test sets.

    And all of these selections can be saved as a favorites to be reused when next time exporting data out from Quality Center and/or creating your report.

    Just do some trials with it and use your imagination!

    After you have got your data out from Quality Center, you will still need to select your report. If you just want test cases with design steps, select Test Case Report -> Detailed Test Case Report and select all test case and design step fields you want in your report. You can also sort the fields into the order you want.

    TIP: First time you do this, don't forget to check menu option Tools -> Options -> Include memo fields - and Strip HTML tags -settings. By default memo fields are not exported from Quality Center, but this settings is saved for future use, so you will need to select this only once.

    After this you will get an report that looks like this: Detailed Test Case Report Sample which you can then distribute to the persons who need to look at the test cases with design steps.

    Here is also more detailed steps with pictures on how to do this: Export Test Cases with Design Steps into Excel.

  • Question: Does Juvander Consulting Provide Support for Tools and Utilities during Evaluation Period?

    Answer: Yes.

    While you are evaluating any of our tools and utilities, you are entitled to the same level of support that we offer to our licensed customers. Details for the level that we offer you can find over here: Customer Support.

    We do understand that our instructions might not be perfect, but if you just get in touch with us, we will guide you through your issues, look at your configurations and log files and tell exactly what you need to do next in order to get things running.

    If you need trial license or extension to an existing one, use the license request form.

    So, just contact us if you have a specific question you can not solve in timely manner on your own!