Export all Open tickets to CSV
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.
Discussions are closed to public comments.
If you need help with Lighthouse please
start a new discussion.
Keyboard shortcuts
Generic
| ? | 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
1 Posted by Will Duncan on 01 May, 2009 04:48 PM
It looks like the query count is not currently working as expected.
Thanks for the heads up, we'll investigate shortly.
2 Posted by System on 01 May, 2009 04:50 PM
A Lighthouse ticket was created for this discussion
3 Posted by Justen Holter on 01 May, 2009 05:25 PM
Thanks for the quick reply! Is "query count" a parameter I would specify in my search?
4 Posted by Rick on 01 May, 2009 10:12 PM
It uses limit. I'm deploying a bugfix now.
5 Posted by scott (at organ... on 16 Sep, 2009 08:32 PM
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 Posted by Rick on 17 Sep, 2009 03:59 PM
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 Posted by scott (at organ... on 18 Sep, 2009 06:41 PM
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?
Thanks!
8 Posted by Rick on 18 Sep, 2009 07:03 PM
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 Posted by scott (at organ... on 18 Sep, 2009 07:42 PM
Understood. Thanks
10 Posted by David Conrad on 25 Oct, 2009 07:57 PM
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 Posted by Chris Ramakers on 25 Feb, 2010 07:52 AM
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 Posted by Paul Prescod on 03 Jun, 2010 12:52 AM
I need to export titles with descriptions for the same reason. Reports to clients.
13 Posted by Brian Koehler on 22 Jun, 2010 05:05 PM
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 Posted by Tom on 07 Sep, 2010 09:34 PM
Is description going to be added to the export at some point?
15 Posted by Will Duncan on 08 Sep, 2010 12:07 AM
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 Posted by Tom on 08 Sep, 2010 12:56 AM
Thanks for getting back to me Will. No problem at all. Was just curious because it would have been useful today.
Cheers!
Will Duncan closed this discussion on 13 Sep, 2010 11:53 PM.