Home → Tips / Tricks →

How can I upload a batch of tickets into Lighthouse (e.g. from Excel)?

• Edit

Wires for Blue Thread

05 Apr, 2013 05:39 PM

I am looking to use LightHouse to track issues/tickets, but I get batches of tickets created inside an existing system somewhere else. I want to pull down batches of new tickets from that system, format them, and upload into Lighthouse.

Is there a way to do that?

1. 1 Posted by Nicole on 05 Apr, 2013 06:31 PM

   

   Depending on the system it could be there is code out there to import from that system into Lighthouse. In any case, if you have experience writing code, you can write something that imports those tickets using our API - http://help.lighthouseapp.com/kb/api.

   Let us know if you have any questions.

   Thanks,
   Nicole

   • Edit

2. 2 Posted by David Stiebel on 05 Apr, 2013 06:36 PM

   

   Thanks Nicole.
   I found this:
   https://github.com/edmz/csv2lighthouse/tree

   Can you help explain to me how to "install" LighthouseAPI in order to use this code?

   Thanks

   • Edit

3. 3 Posted by Nicole on 05 Apr, 2013 07:13 PM

   

   David -

   Are you familiar with Ruby language? If you aren't we strongly suggest hiring someone who is to help you import. We aren't able to give the level of support required for 3rd party import tools/libraries.

   Thanks,
   Nicole

   • Edit

4. Nicole closed this discussion on 05 Apr, 2013 07:13 PM.

5. Tiger Team re-opened this discussion on 05 Apr, 2013 07:24 PM

6. Support Staff 4 Posted by Tiger Team on 05 Apr, 2013 07:24 PM

   

   Hey David,

   What Nicole said, but, I might actually be able to help you. Can you give me a sample of the sort of data you'd want to import?

   • Edit

7. Support Staff 5 Posted by brandi on 08 Apr, 2013 09:53 PM

   

   Hi David,

   Just following up....if you were able to provide us with a sample of the sort of data you're looking to import, we may be able to help out.

   Thanks!
   Brandi

   • Edit

8. Support Staff 6 Posted by brandi on 16 Apr, 2013 12:08 AM

   

   Hi David,

   If there's anything else we can do for you, let us know. Closing this discussion out for now.

   Thanks,
   Brandi

   • Edit

9. brandi closed this discussion on 16 Apr, 2013 12:08 AM.