Export all Open tickets to CSV

Justen Holter's Avatar

Justen Holter

01 May, 2009 04:28 PM

Is it possible to view more tickets per page? I am trying to export a single CSV document with all open tickets, instead of exporting each page individually.

  1. 1 Posted by Will Duncan on 01 May, 2009 04:48 PM

    Will Duncan's Avatar

    It looks like the query count is not currently working as expected.

    Thanks for the heads up, we'll investigate shortly.

  2. 2 Posted by System on 01 May, 2009 04:50 PM

    System's Avatar

    A Lighthouse ticket was created for this discussion

  3. 3 Posted by Justen Holter on 01 May, 2009 05:25 PM

    Justen Holter's Avatar

    Thanks for the quick reply! Is "query count" a parameter I would specify in my search?

  4. 4 Posted by Rick on 01 May, 2009 10:12 PM

    Rick's Avatar

    It uses limit. I'm deploying a bugfix now.

  5. 5 Posted by scott (at organ... on 16 Sep, 2009 08:32 PM

    scott (at organicstartup)'s Avatar

    Great to have a CSV export option, but it's not really useful without exporting the notes/description field too. That's the "meat" of any ticket...is there a way to include all the ticket fields in the CSV? If not, can you please add at least the Description field? Thanks!

  6. 6 Posted by Rick on 17 Sep, 2009 03:59 PM

    Rick's Avatar

    Some of the ticket bodies are pretty large, I'm not sure how that'll
    work out on for CSVs. It's meant to be a summary like the ticket
    index page.

  7. 7 Posted by scott (at organ... on 18 Sep, 2009 06:41 PM

    scott (at organicstartup)'s Avatar

    From a PM's POV, makes me nervous not to keep a local backup of all the ticket data. Best case, if we need it for some future reason, it's a hassle (bothering you for an export or having to deal with the API). Worst case, (with all due respect) there's a real risk that Web2.0 SaaS providers can disappear without much warning ;-)

    I'd guess that most ticket bodies are < a few k, easily within reason for a CSV. No?


  8. 8 Posted by Rick on 18 Sep, 2009 07:03 PM

    Rick's Avatar

    CSV isn't for backup purposes though. It's just not a good format for
    nested and structured data such as a ticket stream. The API is really
    your best bet. We do have plans to offer exports (which include other
    data like messages, attachments, milestones, etc). We can send
    exports on demand right now.

  9. 9 Posted by scott (at organ... on 18 Sep, 2009 07:42 PM

    scott (at organicstartup)'s Avatar

    Understood. Thanks

  10. 10 Posted by David Conrad on 25 Oct, 2009 07:57 PM

    David Conrad's Avatar

    For the record, I'd second a vote for exporting tickets with a description field. We have clients that want to kept up to date on open issues. Right now, there is no easy way to do this with Lighthouse because the description field is missing from the CSV export.

    A second option would be some degree of read-only access to tickets and a clean, simple way to show what has been fixed and what needs to be fixed.

  11. 11 Posted by Chris Ramakers on 25 Feb, 2010 07:52 AM

    Chris Ramakers's Avatar

    Yes, exporting ticket descriptions would be great too ... indeed this could cause issues with CSV but an XML export would be the next best thing then and shouldn't be too complicated :)

  12. 12 Posted by Paul Prescod on 03 Jun, 2010 12:52 AM

    Paul Prescod's Avatar

    I need to export titles with descriptions for the same reason. Reports to clients.

  13. 13 Posted by Brian Koehler on 22 Jun, 2010 05:05 PM

    Brian Koehler's Avatar

    There should be an icon to export to CSV when you choose a single milestone. currently when I only have milestone 1 listed the icon is gone. you should allow CSV export from any list. if I use lighthouse queries to limit the count below 100 that would help minimize the problem

  14. 14 Posted by Tom on 07 Sep, 2010 09:34 PM

    Tom's Avatar

    Is description going to be added to the export at some point?

  15. 15 Posted by Will Duncan on 08 Sep, 2010 12:07 AM

    Will Duncan's Avatar

    Probably not in the near future. There are a ton of Lighthouse updates coming up. We're working as hard as we can to get things rolled out, but the CSV export will follow after the core updates to Lighthouse.

  16. 16 Posted by Tom on 08 Sep, 2010 12:56 AM

    Tom's Avatar

    Thanks for getting back to me Will. No problem at all. Was just curious because it would have been useful today.


  17. Will Duncan closed this discussion on 13 Sep, 2010 11:53 PM.

Discussions are closed to public comments.
If you need help with Lighthouse please start a new discussion.

Keyboard shortcuts


? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac