Hi is there a way/script to delete all tickets? Background: to test the update from V3 to V4 I have imported my V3-database, changed some settings and templates, ... Now I would like colleagues to test their standard operations in the StaffCP (in my test system), but of course I would like to avoid that any of their actions accidently triggers emails to our customers. I already did change the domain for the queues, to avoid to import emails from production. I could go to mysql and delete all rows from swtickets, but I guess there are more tables involved (swticketposts, swticketemails, ...) regards Armin Horst
Hi there Armin, I would recommend you simply create a new blank mysql database and use that, then you know 100% that your staff wont accidentally send stuff to your live customers. gary
Hi thanks. creating a new database forces me to all configurations again and many of them can only be done manually in the AdminCP (?). As far as I can see there is only an export/import process for templates, for things like staff, departments, ticket status, queues, ... I either import them from V3 or do them all manually starting with the Resolve defaults At the end, being able to keep/transport the AdminCP-Settings without any tickets is what I'm looking for thanks for your help Armin
Any luck with the right SQL statements to delete existing tickets? I'd like to get rid of mine but keep config for a dev instance. Thanks!
You can look at this thread; http://forums.kayako.com/threads/purging-old-data-tickets.30896/#post-146834 and you might also want to consider looking at ticket history (swticketauditlogs) otherwise you may have mixed results in reports etc.
Hi there, As Drew posted, you can use the script I wrote in that thread, it will clear out all tickets ( if you use an appropriate date ) Just an FYI also, it also clears all ticket tables, including audit logs etc.. Gary
