More than 100 results in CSV output

Jim Fleming's Avatar

Jim Fleming

04 May, 2010 06:16 PM

How do I get more than 100 results in a CSV export? I tried taking the URL and changing limit from 100 to 500, but is still only returned 100.
changed:
https://saffrontech.lighthouseapp.com/projects/31945-smb/tickets.cs...
to:
https://saffrontech.lighthouseapp.com/projects/31945-smb/tickets.cs...

Thanks,
Jim

  1. 1 Posted by Will Duncan on 04 May, 2010 10:21 PM

    Will Duncan's Avatar

    Hey Jim. Unfortunately there isn't a way to export more than 100 items in a single CSV export. You can tweak the download URL to export pages, so you can get the second 100 items.

    If you grab the download URL from the CSV button, right click + copy link, then add &page=2 on the end of it, you can download the 2nd page of 100 items.

    We should have the functionality for large exports available soon, which Lighthouse will generate in a job process and email you a link to download them when the bundle is ready.

  2. 2 Posted by Nicole on 27 May, 2010 08:45 PM

    Nicole's Avatar

    Jim -

    We recently added the export option in "Settings & Payment". We're still ironing out somethings with exporting attachments, but ticket data is available.

    Let me know if you have any questions.

    Thanks,
    Nicole

  3. Nicole closed this discussion on 27 May, 2010 08:45 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