Import from TestLink

<testsuite name="Regression">
  <testsuite name="Login">
    <testcase internalid="25" name="Login with valid credentials">
      <externalid><![CDATA[1]]></externalid>
      <summary><![CDATA[<p>Happy path</p>]]></summary>
      <preconditions><![CDATA[<p>User exists</p>]]></preconditions>
      <importance><![CDATA[3]]></importance>
      <steps>
        <step>
          <step_number><![CDATA[1]]></step_number>
          <actions><![CDATA[<p>Open the login page</p>]]></actions>
          <expectedresults><![CDATA[<p>Form is shown</p>]]></expectedresults>
        </step>
      </steps>
      <keywords><keyword name="smoke"><notes><![CDATA[]]></notes></keyword></keywords>
    </testcase>
  </testsuite>
</testsuite>

#!/usr/bin/env python3
"""Convert a TestLink XML export (test suite, test project, or test cases) to a QA Sphere CSV.

Usage: python3 testlink_to_qasphere.py export.xml output.csv
"""
import csv
import html
import re
import sys
import xml.etree.ElementTree as ET

PRIORITY = {"1": "low", "2": "medium", "3": "high"}


def text(elem, *names):
    for name in names:
        child = elem.find(name)
        if child is not None and child.text:
            return child.text.strip()
    return ""


def emphasis(mark):
    def wrap(match):
        inner = match.group(2)
        if not inner.strip():
            return inner
        lead = inner[: len(inner) - len(inner.lstrip())]
        trail = inner[len(inner.rstrip()) :]
        return f"{lead}{mark}{inner.strip()}{mark}{trail}"

    return wrap


def to_markdown(value):
    """Convert TestLink's HTML to plain text with Markdown line breaks."""
    value = re.sub(r"<br\s*/?>", "\n", value, flags=re.I)
    value = re.sub(r"</(p|div|ul|ol|h[1-6])>", "\n\n", value, flags=re.I)
    value = re.sub(r"<li\b[^>]*>\s*", "\n- ", value, flags=re.I)
    value = re.sub(r"<(strong|b)\b[^>]*>(.*?)</\1>", emphasis("**"), value, flags=re.I | re.S)
    value = re.sub(r"<(em|i)\b[^>]*>(.*?)</\1>", emphasis("_"), value, flags=re.I | re.S)
    value = re.sub(r"<[^>]+>", "", value)
    value = "\n".join(line.strip() for line in html.unescape(value).splitlines())
    value = re.sub(r"(?m)^(- .*)\n\n+(?=- )", r"\1\n", value)  # keep lists tight
    return re.sub(r"\n{3,}", "\n\n", value).strip()


def walk(elem, path, rows):
    for suite in elem.findall("testsuite"):
        walk(suite, path + [suite.get("name", "").strip() or "Imported"], rows)
    for case in elem.findall("testcase"):
        steps = []
        for step in case.findall("steps/step"):
            steps.append((to_markdown(text(step, "actions")), to_markdown(text(step, "expectedresults"))))
        tags = [re.sub(r"\s*,\s*", " ", kw.get("name")) for kw in case.findall("keywords/keyword") if kw.get("name")]
        preconditions = to_markdown(text(case, "preconditions"))
        summary = to_markdown(text(case, "summary"))
        if summary:
            preconditions = f"{summary}\n\n{preconditions}".strip()
        rows.append(
            {
                "Folder": "/".join(path) or "Imported",
                "Name": case.get("name", "").strip()[:511],
                "Priority": PRIORITY.get(text(case, "importance"), "medium"),
                "Legacy ID": text(case, "fullexternalid", "externalid")[:255],
                "Tags": ",".join(tags),
                "Preconditions": preconditions,
                "steps": steps,
            }
        )


def main(src, dst):
    root = ET.parse(src).getroot()
    rows = []
    if root.tag == "testsuite":
        name = root.get("name", "").strip()
        walk(root, [name] if name else [], rows)
    else:  # <testcases> root
        walk(root, [], rows)
    max_steps = max((len(r["steps"]) for r in rows), default=0)
    header = ["Folder", "Name", "Priority", "Legacy ID", "Tags", "Preconditions"]
    for i in range(1, max_steps + 1):
        header += [f"Step {i}", f"Expected {i}"]
    with open(dst, "w", newline="", encoding="utf-8") as f:
        writer = csv.writer(f)
        writer.writerow(header)
        for r in rows:
            line = [r[h] for h in header[:6]]
            for step, expected in r["steps"]:
                line += [step, expected]
            line += [""] * (2 * (max_steps - len(r["steps"])))
            writer.writerow(line)
    print(f"Wrote {len(rows)} test cases to {dst}")


if __name__ == "__main__":
    main(sys.argv[1], sys.argv[2])

python3 testlink_to_qasphere.py export.xml testcases.csv