How to export bug status summary to excel.

Do you means a report from Launchpad? bugzilla-launchpad is a plugin for old bugzilla that allows Lp to extra bug data -- it is not for for users.

You can write a Launchpad API script that will get all the bug tasks for a project and iterate over them to create a report. https://help.launchpad.net/API . You can do something like this:

    lp = Launchpad.login_with(
        'testing', service_root='https://api.launchpad.net',
        version='devel')
    project = lp.projects['MY-PROJECT']
    bug_tasks = project.searchTasks(status=[
        'New', "Won't Fix", 'Incomplete', 'Opinion', 'Expired',
        'Confirmed', 'Triaged', 'Fix Committed', 'Fix Released',
        'Incomplete (with response)', 'Incomplete (without response)'])
    rows = []
    for task in bug_tasks:
        rows.append(
            '%s, %s, %s, %s' % (
                task.bug.id,
                task.status,
                task.importance
                task.assignee.name,
                )
            )
        for row in rows
            print row

Hi Curtis,

Thanks for your help. Script is good, but still have some question that is related to bug reports. Not covered by any of the FAQs.

Easier to chat live. Can a conf call be arranged?

- Q

-----Original Message-----
From: <email address hidden> [mailto:<email address hidden>] On Behalf Of Curtis Hovey
Sent: Tuesday, December 18, 2012 4:06 AM
To: Quyen Dang (qudang)
Subject: Re: [Question #216825]: How to export bug status summary to excel.

Your question #216825 on Bugzilla Launchpad Plugin changed:
https://answers.launchpad.net/bugzilla-launchpad/+question/216825

    Status: Open => Answered

Curtis Hovey proposed the following answer:
Do you means a report from Launchpad? bugzilla-launchpad is a plugin for old bugzilla that allows Lp to extra bug data -- it is not for for users.

You can write a Launchpad API script that will get all the bug tasks for a project and iterate over them to create a report.
https://help.launchpad.net/API . You can do something like this:

    lp = Launchpad.login_with(
        'testing', service_root='https://api.launchpad.net',
        version='devel')
    project = lp.projects['MY-PROJECT']
    bug_tasks = project.searchTasks(status=[
        'New', "Won't Fix", 'Incomplete', 'Opinion', 'Expired',
        'Confirmed', 'Triaged', 'Fix Committed', 'Fix Released',
        'Incomplete (with response)', 'Incomplete (without response)'])
    rows = []
    for task in bug_tasks:
        rows.append(
            '%s, %s, %s, %s' % (
                task.bug.id,
                task.status,
                task.importance
                task.assignee.name,
                )
            )
        for row in rows
            print row

--
If this answers your question, please go to the following page to let us know that it is solved:
https://answers.launchpad.net/bugzilla-launchpad/+question/216825/+confirm?answer_id=0

If you still need help, you can reply to this email or go to the following page to enter your feedback:
https://answers.launchpad.net/bugzilla-launchpad/+question/216825

You received this question notification because you asked the question.

You can reply here or ask in our support IRC channel (#launchpad on irc.freenode.net).

Never mind. Think I figured it out.