How can I migrate only specific tickets from 3.x to 4.0?

There isn't a simple option for selective importing in the migration tool, but here's an easy workaround:

1. Backup your original database and copy it somewhere safe.

2. Upgrade to 3.6 if you haven't already:
http://www.cerberusweb.com/download/archives

3. You can delete any tickets you don't want imported using the GUI.

4. To not import any closed tickets, you can Issue the following SQL statement against your 3.6 database:
UPDATE ticket SET is_deleted = 1 WHERE is_closed = 1;

5. Follow the normal migration instructions using this new database:
http://wiki.cerberusdemo.com/index.php/Migrating_from_Cerberus_Helpdesk_3.x_to_4.0

Search
»

Article Tools
Print