CSV Export of Issues

MNDCreative's Avatar

MNDCreative

02 Feb, 2009 04:46 PM

A great feature would be to have an exportable list of all open tickets, so I can view them all easier from Numbers or Excel. Then, be able to reimport those back to Lighthouse as a bulk update.

I did this with an inventory system once, and it worked great.

  1. 1 Posted by Will Duncan on 02 Feb, 2009 04:56 PM

    Will Duncan's Avatar

    Thanks for the suggestion, this is actually a feature we have in the works.

  2. 2 Posted by Rick on 02 Feb, 2009 06:00 PM

    Rick's Avatar

    We might add csv exporting, but probably not importing.

  3. Rick closed this discussion on 02 Feb, 2009 06:00 PM.

  4. MNDCreative re-opened this discussion on 02 Feb, 2009 07:26 PM

  5. 3 Posted by MNDCreative on 02 Feb, 2009 07:26 PM

    MNDCreative's Avatar

    Importing would be great, and really easy, no? I wrote a PHP script that separated out each line, then each tab separated field, and then mapped each field to a database field, and updated accordingly.

    This would be super helpful as I currently have 24 open tickets, and would be much easier to go through each one in Numbers then have to open a ticket, update the status, click back, and then open the next. If you take on average 30 seconds per ticket to open, update and move to the next, times 24 tickets, that's 12 minutes wasted essentially per day. With my hourly rate, that's $17 lost to the UI.

  6. 4 Posted by Rick on 02 Feb, 2009 10:57 PM

    Rick's Avatar

    Sure, it'd also be easy to write your own csv importer and exporter using the actual API. This isn't a very common feature request.

  7. 5 Posted by MNDCreative on 02 Feb, 2009 10:59 PM

    MNDCreative's Avatar

    Alright then... That'll be the last suggestion I make...

  8. 6 Posted by Rick on 02 Feb, 2009 11:05 PM

    Rick's Avatar

    I appreciate the suggestion, but we get a lot of them. They just have to get weighed against everything else. Adding something to clutter the interface that's only in use by a small portion of the audience doesn't make a lot of sense. We have some ideas on using miniapps to experiment with little improvements. Maybe a little csv importer/exporter could be written so we can gauge interest in it.

  9. Rick closed this discussion on 02 Feb, 2009 11:05 PM.

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