tag:help.lighthouseapp.com,2008-09-20:/discussions/questions/259-export-all-open-tickets-to-csvLighthouse: Discussion 2016-03-03T19:51:54Ztag:help.lighthouseapp.com,2008-09-20:Comment/1502542009-05-01T16:48:39Z2009-05-01T16:48:39ZExport all Open tickets to CSV<div><p>It looks like the query count is not currently working as
expected.</p>
<p>Thanks for the heads up, we'll investigate shortly.</p></div>Will Duncantag:help.lighthouseapp.com,2008-09-20:Comment/1502542009-05-01T16:50:10Z2012-07-20T15:36:30ZExport all Open tickets to CSV<div><p>A Lighthouse ticket was created for this discussion</p></div>Systemtag:help.lighthouseapp.com,2008-09-20:Comment/1502542009-05-01T17:25:12Z2009-05-01T17:25:16ZExport all Open tickets to CSV<div><p>Thanks for the quick reply! Is "query count" a parameter I would
specify in my search?</p></div>Justen Holtertag:help.lighthouseapp.com,2008-09-20:Comment/1502542009-05-01T22:12:50Z2009-05-01T22:12:50ZExport all Open tickets to CSV<div><p>It uses limit. I'm deploying a bugfix now.</p></div>Ricktag:help.lighthouseapp.com,2008-09-20:Comment/1502542009-09-16T20:32:02Z2009-09-16T20:32:10ZExport all Open tickets to CSV<div><p>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!</p></div>scott (at organicstartup)tag:help.lighthouseapp.com,2008-09-20:Comment/1502542009-09-17T15:59:55Z2009-09-17T15:59:55ZExport all Open tickets to CSV<div><p>Some of the ticket bodies are pretty large, I'm not sure how
that'll<br>
work out on for CSVs. It's meant to be a summary like the
ticket<br>
index page.</p></div>Ricktag:help.lighthouseapp.com,2008-09-20:Comment/1502542009-09-18T18:41:36Z2009-09-18T18:41:40ZExport all Open tickets to CSV<div><p>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 ;-)</p>
<p>I'd guess that most ticket bodies are < a few k, easily
within reason for a CSV. No?</p>
<p>Thanks!</p></div>scott (at organicstartup)tag:help.lighthouseapp.com,2008-09-20:Comment/1502542009-09-18T19:03:00Z2009-09-18T19:03:00ZExport all Open tickets to CSV<div><p>CSV isn't for backup purposes though. It's just not a good
format for<br>
nested and structured data such as a ticket stream. The API is
really<br>
your best bet. We do have plans to offer exports (which include
other<br>
data like messages, attachments, milestones, etc). We can send<br>
exports on demand right now.</p></div>Ricktag:help.lighthouseapp.com,2008-09-20:Comment/1502542009-09-18T19:42:55Z2009-09-18T19:42:57ZExport all Open tickets to CSV<div><p>Understood. Thanks</p></div>scott (at organicstartup)tag:help.lighthouseapp.com,2008-09-20:Comment/1502542009-10-25T19:57:28Z2009-10-25T19:57:30ZExport all Open tickets to CSV<div><p>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.</p>
<p>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.</p></div>David Conradtag:help.lighthouseapp.com,2008-09-20:Comment/1502542010-02-25T07:52:20Z2010-02-25T07:52:21ZExport all Open tickets to CSV<div><p>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 :)</p></div>Chris Ramakerstag:help.lighthouseapp.com,2008-09-20:Comment/1502542010-06-03T00:52:30Z2010-06-03T00:52:30ZExport all Open tickets to CSV<div><p>I need to export titles with descriptions for the same reason.
Reports to clients.</p></div>Paul Prescodtag:help.lighthouseapp.com,2008-09-20:Comment/1502542010-06-22T17:05:55Z2010-06-22T17:05:58ZExport all Open tickets to CSV<div><p>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</p></div>Brian Koehlertag:help.lighthouseapp.com,2008-09-20:Comment/1502542010-09-07T21:34:03Z2010-09-07T21:34:03ZExport all Open tickets to CSV<div><p>Is description going to be added to the export at some point?</p></div>Tomtag:help.lighthouseapp.com,2008-09-20:Comment/1502542010-09-08T00:07:14Z2010-09-08T00:07:14ZExport all Open tickets to CSV<div><p>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.</p></div>Will Duncantag:help.lighthouseapp.com,2008-09-20:Comment/1502542010-09-08T00:56:32Z2010-09-08T00:56:32ZExport all Open tickets to CSV<div><p>Thanks for getting back to me Will. No problem at all. Was just curious because it would have been useful today.</p>
<p>Cheers!</p></div>Tom