tag:help.lighthouseapp.com,2008-09-20:/discussions/api-developers/124-exporting-lighthouse-dataLighthouse: Discussion 2013-08-12T18:26:52Ztag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-10-27T03:20:36Z2009-10-27T03:20:36ZExporting lighthouse data<div><p>We have some ideas for some full export dump options due up on
the roadmap shortly, but right now the standard API is your best
option. Rick may have a suggestion for a faster resource though,
I'll tap him on the shoulder tomorrow and see if he has an
idea.</p></div>Will Duncantag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-10-28T02:11:57Z2009-10-28T02:12:00ZExporting lighthouse data<div><p>We actually are wanting to do the same thing - export tickets
from lighthouse so we can keep a copy offline as back up and to run
reports on. So we too would like to know how and when we can do
this.</p>
<p>Thanks Kaz</p></div>Carolyntag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-11-13T18:26:58Z2012-07-20T15:36:20ZExporting lighthouse data<div><p>This discussion was assigned to Courtenay Gasking, on ticket
12.</p></div>Systemtag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-11-13T18:29:15Z2009-11-13T18:29:15ZExporting lighthouse data<div><p>Thanks for the suggestions. This is on the roadmap. We currently
do have an export format, it's just a matter of adding a form for
users to request them by email. The current hangup is the fact that
they can be fairly intensive to build on the server for larger
projects.</p>
<p>If you'd like, I can send you guys a dump of your accounts so
you can at least get started running reports.</p></div>Ricktag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-11-17T14:17:06Z2009-11-17T14:17:11ZExporting lighthouse data<div><p>I would love to get such a dump. What information do you need
from us in order to create such an export?</p>
<p>Regards,</p>
<p>pieter</p></div>Pieter Claerhouttag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-11-25T05:58:32Z2009-11-25T05:58:32ZExporting lighthouse data<div><p>Pieter: All I need is the account name of an account you're a
member of. I see you have a lot of projects under an account
though, so I can just export only those projects that you use. Do
you want a dump for all of it?</p></div>Ricktag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-11-25T09:20:58Z2009-11-25T09:20:59ZExporting lighthouse data<div><p>Hi Rick,</p>
<p>my account is shpartners.lighthouseapp.com. It would be great if
you could create an export of all projects of this account.</p>
<p>pieter</p></div>Pieter Claerhouttag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-11-25T22:21:51Z2009-11-25T22:21:51ZExporting lighthouse data<div><p>I'm sending you a 100MB backup of all the data for the 35
projects in that account that you have access to. It's sending
right now through Dropsend to your email address. Let me know if
you have any problems.</p></div>Ricktag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-11-26T08:49:16Z2009-11-26T08:49:16ZExporting lighthouse data<div><p>Hi Rick,</p>
<p>the export looks great, except for two things.</p>
<p>Would it be possible to get an export with the file attachments?
For the reporting we will be doing, we don't need the files and it
would make the export file a lot more manageable...</p>
<p>I'm also missing the ticket history. In the ticket.json files, I
can only find the original and latest bodies, but none of the other
versions.</p>
<p>Regards,</p>
<p>pieter</p></div>Pieter Claerhouttag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-11-26T21:35:44Z2009-11-26T21:35:44ZExporting lighthouse data<div><p>Hmm, I definitely saw some attachments in there. You should
be<br>
getting the full data for everything. Maybe there's a bug in
the<br>
exporter then. I'll have a look.</p></div>Ricktag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-11-27T08:16:10Z2009-11-27T08:16:10ZExporting lighthouse data<div><p>Rick,</p>
<p>I made a small typo in my previous reply. What I want is an
export <strong>without</strong> the file attachments.</p>
<p>The current export does include all the file attachments, but
this makes the export too big to be manageable for me.</p>
<p>Regards,</p>
<p>pieter</p></div>Pieter Claerhouttag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-12-17T20:36:31Z2009-12-17T20:36:31ZExporting lighthouse data<div><p>Hi Pieter -</p>
<p>Sorry for the delay. Do you still need the export without
attachments?</p>
<p>Thanks,<br>
Nicole</p></div>Nicoletag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-12-18T12:45:55Z2009-12-18T12:45:55ZExporting lighthouse data<div><p>Yes, I still need the export without the attachments but with
the ticket history.</p>
<p>Regards,</p>
<p>pieter</p></div>Pieter Claerhouttag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-12-18T20:28:28Z2009-12-18T20:28:28ZExporting lighthouse data<div><p>Ok, just sent you the export.</p></div>Ricktag:help.lighthouseapp.com,2008-09-20:Comment/4994822009-12-18T20:29:05Z2009-12-18T20:29:05ZExporting lighthouse data<div><p>Hallo,</p>
<p>ik ben op vakantie. Vanaf maandag 4 januari 2010 ben ik weer
bereikbaar.</p>
<p>Indien je dringende vragen of problemen hebt, gelieve contact op
te nemen met SHpartners op het nummer +32 497 55 00 00.</p>
<p>Met vriendelijke groeten,</p>
<p>pieter</p>
<p>____________________________ Pieter Claerhout<br>
Web, iPhone & FileMaker 9 & 10 Certified Developer<br>
SHpartners<br>
<a href=
"mailto:pieter.claerhout@shpartners.com">pieter.claerhout@shpartners.com</a><br>
<a href="http://www.shpartners.com">www.shpartners.com</a><br>
[mob] +32 497 44 04 81 [office] +32 497 55 00 00 [fax] +32 9 270 01
82</p></div>Pieter Claerhouttag:help.lighthouseapp.com,2008-09-20:Comment/4994822010-01-04T09:25:23Z2010-01-04T09:25:23ZExporting lighthouse data<div><p>Excellent, it looks exactly like what I need. Is there any way
the user can initiate the creation of this export?</p></div>Pieter Claerhouttag:help.lighthouseapp.com,2008-09-20:Comment/4994822010-01-04T19:43:57Z2010-01-04T19:43:57ZExporting lighthouse data<div><p>That's on the roadmap, but at the moment we're doing it on a
case by case basis because we need to have some other things in
place before hand. It can be a pretty heavy hit on the DB.</p></div>Justin Palmertag:help.lighthouseapp.com,2008-09-20:Comment/4994822010-02-26T22:19:28Z2010-02-26T22:19:30ZExporting lighthouse data<div><p>Hi all,</p>
<p>I'm also interested in an export of full ticket history. Is
there any development with this option?</p>
<p>Regards,<br>
Nick</p></div>nstasinotag:help.lighthouseapp.com,2008-09-20:Comment/4994822010-03-01T18:39:30Z2010-03-01T18:39:30ZExporting lighthouse data<div><p>There is, but it's not ready. File a private issue with details
about your account and I'll send you an export. Thanks!</p></div>Rick