Sysadmin Guide

Spiceworks Importer


Spiceworks importer script

Download: https://github.com/deskpro/deskpro-importer-tools/tree/master/importers/spiceworks

This tool will connect to your Spiceworks database and export your data in the standard Deskpro Import Format.

After this tool completes, you will run the standard Deskpro import process to save the data to your live helpdesk.

What does it import?

  • Agents (Staff)
  • Users
  • Tickets
  • Ticket Messages
  • Ticket (Agent) Notes
  • Ticket Message Attachments

Setup

Import Data

Run the import process to fetch all of your data from Spiceworks:

$ cd /path/to/deskpro
$ php bin/console dp:import spiceworks

You can now optionally verify the integrity of your data:

$ php bin/console dp:import:verify

When you're ready, go ahead and apply the import to your live database:

$ php bin/console dp:import:apply

And finally, you can clean up the temporary data files from the filesystem:

$ php bin/console dp:import:clean

Note

If your main admin account existed in both Spiceworks and Deskpro, you may have inadvertently removed your own admin permissions by running this import. You can restore your permissions here: https://support.deskpro.com/en/kb/articles/i-ve-lost-admin-permissions-and-i-m-locked-out-of-deskpro-on-premise - or you can preventatively add a unique admin account in Deskpro which does not get overwritten by the new data.

Comments (0)

Add a comment

Add a comment

You need to log in before you can submit a comment.

Need a password reminder?