Tickets bulk move to other category.

[farrukh]

Script URL:
Version of script: 2.7.1
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below:

I wonder, if there is a way to bulk move tickets (with all kind of status) from one category to other? We did some internal analysis and want to merged few categories but we dont want to lose ticket data inside each category.

Any suggestions/workarounds also welcome.

Farrukh.

[Klemen]

There is no built-in way of doing that.

However, you could do it directly in the database (over SSH or using a tool such as phpMyAdmin, most hosting companies provide it):

1. BACKUP existing database
2. find out OLD category ID
3. find out NEW category ID
4. run this SQL code on the Hesk database:

Code: Select all

UPDATE `hesk_tickets` SET `category` = 'NEW CATEGORY ID' WHERE `category` = 'OLD CATEGORY ID'

So, to move all tickets from category ID 2 to category ID 10, you would run:

Code: Select all

UPDATE `hesk_tickets` SET `category` = '10' WHERE `category` = '2'