Testlink: Export complete test cases into OpenOffice

openoffice.org testlink
Peter S. picture Peter S. · Sep 25, 2013 · Viewed 17.7k times · Source

I have a large number of test cases in Testlink and I need to export them into either OpenOffice Calc or Writer (and then possibly reimport them), including test steps.

Currently Testlink only supports XML for exports and imports of test cases. To import an XML file into OpenOffice and export it, specifically formatted XSLT files are needed. To create them appears to be rather time consuming if you are not an XML expert.

Did anybody do this already? Does anybody have examples or working XSLT files for Testlink test cases, for Calc or Writer?

Answer

Peter S. picture Peter S. · Oct 7, 2013

My bad. It turns out that it is very easily possible to export test cases with test steps:

  1. Choose Test Reports in the topmost menu of Testlink.
  2. On the Reports and Metrics page, select OpenOffice Writer (or MS Word) as the Report Format.
  3. On the left side, select Test Plan Report. On the right side, select the checkbox Test Scenario (you don't need Test Summary or any other options). Below, click on the test case folder that you wish to export.
  4. You get the document for download. (Note: may require some formatting.)

Alternatively, it is possible to choose HTML in step 2 as the report format and save the frame.

While it is possible to select OpenOffice Calc/MS Excel, there doesn't seem to be a way to include test case steps.

Related questions

How To Format A Block of Code Within a Presentation?

I am preparing a presentation using Google Slides, though I can also work on the presentation within Open Office that will include code snippets. Is there any easy way to perform basic syntax highlighting on the code snippets with either …

Read More
Fill non-contiguous blank cells with the value from the cell above the first blank

I want to know if there is a way to do this conditional in excel or open office: if the cell is empty then the cell will have the same value as the cell above it else do nothing. Should …

Read More
C#: Getting the number of rows/columns with ExcelPackage

I need to read and write data from an Excel spreadsheet. Is there a method to finding out how many rows/columns a certain worksheet has using ExcelPackage? I have the following code: FileInfo newFile = new FileInfo(@"C:\example.xlsx"); …

Read More