Traccar with TicketsCAD

[Darren Deakin (UKDeek)]

Hi all.

I know there is always interest in getting a good tracking solution working with Tickets, and a really good solution is Traccar, but it is a nightmare to get running.

However, after much hair pulling I have managed to get this working, using the php scripts and info originally provided by Roberto Sanglay, with a very small moditification (original post here: https://groups.google.com/g/open-source-cad/c/hxbca1hr2tg)

Here is a step-by-step guide on how I achieved this, which may help others in the future.

Firstly, I installed Traccar onto a DigitalOcean dropplet, as per the instructions found on Traccer - https://www.traccar.org/install-digitalocean/

Next, I pointed a domain to the Traccr install and activated HTTPS, following these instructions - https://www.traccar.org/secure-connection/

Add a device to Traccar and ensure it is tracking correctly.

You must ensure that any resources that you want tracking within Traccar are added under the same log-in email, as Tickets will access the REST API via this email / password combo to pull across data. Any resources registered within Traccar using a different email address will not be reported to Tickets.

I installed Tickets onto my shared hosting using the standard installation instructions.

The next step is the crucial one to getting the REST API to connect, following the instructions from Roberto:

Edit the Tickets database using phpMyAdmin

 Create a new setting by applying the following sql in PHPmyAdmin  (assuming you're not using db_prefix.)
    "INSERT INTO `settings` (name,value) VALUES('Traccar_URL','')";
    "INSERT INTO `settings` (name,value) VALUES('Traccar_userid','')";

    "INSERT INTO `settings` (name,value) VALUES('Traccar_password','')";

These values are editable in Tickets, found within Config / Edit Settings.

Open up the attached "Replacement remotes.inc.php" file, and before you do anything edit the URL at around line 22 and replace www.yoururl.com with the URL of your Traccar installation.

Next, open up incs/remotes.inc.php on the Tickets server and replace the "function do_traccar" section with the contents of the now editted "Replacement remotes.inc.php" file. This is altered ever so slightly from the original uploaded by Roberto to include the call to https:// as it wasn't connecting to the normal http://

Once that is all uploaded you can log in to Tickets and within Config / Edit Settings you should now see three new entries: Traccar password, Traccar URL and Traccar userid.

Traccar URL: The basic URL to your Traccar install. Do not include any https:// info or any port info

Traccar userid: The email address you used to create the resources in Traccar

Traccar password: The password used to login with the email address above

The final step is to create a Unit within Tickets, ensuring that Tracking is set to Traccar, Mobile is ticked, and that followign the "?" you enter the unique ID for the unti to be tracked (listed as Identifier within Traccar).

And that should be it. 

Sorry if this has come across as overly simple, but this is also to serve as a permanent reminder to myself on how to do this, as I always figure it out and then promptly forget what I have done.

Also, I am not technical in any way, shape, or form, and I have mearly collated information from here and elsewhere and made a very small edit to a file.

Thanks

[Arnie Shore]

Darren, I can't begin to thank you  enough for sharing that.  I'm sure some folks here have been trying to get that working, and failing.

it's a much-needed capability, and your  efforts plus sharing the how-to are so much appreciated.

AS