This is the exact same question I have been trying to figure out this morning. I added a ticket to the ost_ticket table using SQL and, while osTicket sees that there is now one more ticket, it doesn't display it in the queue nor can it find it using search. Obviously there are multiple tables that need to be updated. I've tried some obvious ones to no avail.
I'm just looking for a way to import tickets from structured text files and thought SQL would be easiest but I'm open to suggestions.
How do "multiple queries" apply and how could that be implemented?

I've never tried to do this but it was a lot easier 3 years ago than it is now.

Now you need to worry about putting the information for the ticket in ost_ticket, ost_thread, ost_thread_entry, ost_thread_event.

If your parsing an email you would need to make an entry in ost_thread_entry_email.

If you want a collaborator I imagine that you would want to update ost_thread_collaborator

If you have a file attachment you would update ost_file and ost_file_chunk.

If you have form values that you want to fill then you would have to look at all the ost_form* tables and update those accordingly.

So it would be a lot easier to do this in one query per table. Hence multiple queries.

I'm not sure why you need to reinvent the wheel, but thats basically what you are doing by creating tickets via SQL query. I would recommend using the ticket api, or sending the ticket system an email from a form if you need to open a ticket outside of the API.

ntozier Thanks for the info. My intention wasn't to recreate anything, I'm just trying to find the easiest way to do a one-time import of old document-based tickets.
I will take a look at the ticket api and email forms to see if they will work. I'm still not familiar with everything osTicket has to offer so these are the kind of suggestions I was looking for. Thanks.
If that doesn't work then as a last resort I will take a look at all those tables you listed and see if a subset of them satisfies my requirements.

Sounds like a plan. ? And it's what I'm here for. If you need anything else let me know.

I did write a ticket api guide for an old version (all but the way attachments work should be still valid).
It's located at: http://tmib.net/using-the-osticket-1-8-1-2-api/

As a side note should I close this thread or do you think that you are going to want to update more?

ntozier Thanks for the link. I might have asked you for more info if I couldn't figure it out from the existing documentation, but this should speed me along. Go ahead and close the thread.

Feel free to start a new thread with your questions if you have any.