Spiceworks importer script
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)
- Ticket Messages
- Ticket (Agent) Notes
- Ticket Message Attachments
- Create a new directory titled
- Download https://github.com/deskpro/deskpro-importer-tools/blob/master/importers/spiceworks/config.dist.php to this folder
- Rename the config file from
- Edit the config values in the
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
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.