Hi Thomas,
Im using Laravel to handle the sync between the Liveagent DB and Zammad DB.
Zammad is currently setup to use MySQL.
The script i have right now only handles tickets and contact forms, live chats are quite complicated.
But basically it takes the LA Conversations, and converts those into Zammad Tickets.
You will also need to take into account the tags for these tickets (if you are making use of these).
Also, you would need to retrieve the User data for the owner of these tickets, and create their equivalent Zammad Users, with its own Groups, Roles, etc.
For the ticket content, you would need to get the LA Messages for each of those Conversations, and convert those into Zammad Ticket Articles.
Ticket Content for Contact Forms differ from normal Tickets, so you would need to refer to the LA Documentation on Message types and modify your script with those details.
The complicated part in all of this is the retrieval of Agent data, because Liveagent doesn’t store this data in your DB, you would need to query the LA API for that.
With this kind of process, it will be quite slow to import, depending on how many tickets you wish to import because of how many queries you will need to run to get the related data.
One way is to use the Laravel models and define the relationships for each model. That way, it will be easier to have all the data available with fewer queries.
Another way is to handle it by batches. Where you would query, lets say, 100 records at a time, process those 100 records, and then bulk insert/update them into you Zammad DB.
Either way, you will need to really tinker around with this, as there is just no available script (as far as i’ve been searching) for LiveAgent to Zammad. Good luck!