You can import exsisting Spiceworks data into Deskpro as long as you have the database file and the attachments. The steps outlined below will allow you to import the data into your Deskpro instance.

On the target server will need a copy of the SpiceWorks SQLite database file and a copy of the SpiceWorks attachment directory.

place both attachments and the .SQL file in the following directory

/opt/deskpro/data/instances/<instance_name>/attachments/
 copy

To create config file need to enter shell for the instance:

opc inst shell
 copy

If you have more than one helpdesk instance you will need to specify the one you want to edit the importer config with the inst -i <instance_name> flag

opc inst -i <instance_name> shell
 copy

cd to the spiceworks importer directory

cd /srv/deskpro/dpv5/app/BUILD/modules/importer-tools/importers/spiceworks/
 copy

Copy the example config file

cp config.dist.php config.php
 copy

Edit the config file, providing the paths for the database and attachments

nano config.php
 copy

The config needs to be set to:

<?php

$CONFIG = [];

/**
 * Enter the full path to your SpiceWorks SQLite database file.
 */
$CONFIG['db_path'] = '/deskpro/attachments/<database_name>.db';

/**
 * Enter the full path to your SpiceWorks ticket attachments directory.
 * The data directory should be: <path to SpiceWorks>/data/uploads/Ticket
 *
 * This directory should contain many sub-directories. Each directory is
 * a ticket ID, and inside each directory will be the file attachments
 * on the ticket.
 */
$CONFIG['ticket_attachments_path'] = '/deskpro/attachments/Ticket';
 copy

This is because /opt/deskpro/data/instances/spiceworks/attachments is mapped to /deskpro/attachments inside the instance.

Once done, you can save the file and exit the shell with

exit
 copy

Then run the import tool with

opc inst php -- dpv5/bin/console dp:import spiceworks
 copy

If you have more than one helpdesk instance you will need to specify the one you want to import the data with the inst -i <instance_name> flag

opc inst -i <instance_name> php -- dpv5/bin/console dp:import spiceworks
 copy

Once the importer runs you can run the verify command to make sure the data that is going to be imported is valid

opc inst php -- dpv5/bin/console dp:import:verify
 copy

To apply the imported data to your Deskpro instance, you need to run the following

opc inst php -- dpv5/bin/console dp:import:apply
 copy