import excel/spreedsheet to testlink

Environment: Testlink 1.8.5, Office 2003/Openoffice

Problem description: Testlink 1.8.5 supports only XML format importing, how to import test case in excel or spreedsheet format?  

Solution: to obtain a XML file that Testlink supports.

HOW TO:

1. Create 1 or 2 testcases in testlink.
2. Then export these testcases, the exported file is testcases.xml.
3. Open testcases.xml file with MS Excel.
4. When you open it, choose the option "Use the XML source task pane".
5. Then you will see the XML map in XML Source window.
6. Click and drag the elements to the excel sheet, e.g. ifnameto be your first column, click and drag "name" element to A1 grid so that the column A will be "name" column.

7. Copy/Paste required elements in Excel

8. Save current excel as xml date format.

Finally, you need to add corresponding test suite name to xml, and after that, you can import this  XML file from testlink.