I searched this forum and only found one thread with 3 posts from 7 years ago.

We started using OneOrZero around 2005. We now have almost 14,000 tickets. I'd be interested in upgrading to something more current, like osTicket, for security reasons. OneOrZero is still kicking strong and working great with some mods over the years. I've moved our webserver from our 2008 R2 server to a Raspberry PI 4 (it's just a very small website with a few static pages), and I'm thinking about moving our ticket software there too. The goal is to decommission our out-of-support and underutilized server.

We'd use it for project management, so I'm not even sure if osTicket would be a fit for our purpose.

I'm a noob when it comes to SQL databases. Would there be some way to import those 14K tickets into osTicket? Has anyone had success? Any pointers in how this could be done?

So first off I'm not sure that a Raspberry Pi 4 could handle the webserver + php + mysql/MariaDB of a ticket site with 14k tickets... but it worse case it might be really slow... but putting that aside for a moment.

You would need to look at the DB structure for osTicket, figure out how the tables all relate to each other.
Then you would do an export from your current system SQL.
Then you would need to write a custom import script to put the data into a format and inject it into the osTicket Database. (This is not for the feint of heart!)

Your best bet might be to reach out to the folks at Professional Support.
https://osticket.com/services/professional-support/
They offer migration services but I have no idea how busy they might be (since I am just a Forum Admin).

Write a Reply...