Insert Data from another Database

Zack8 years ago

I have a tracking solution running in the same SQL server instance in another database. I have inserted the devices, positions, users etc...The issue I am experiencing is the database reflects the last update and position correctly, but the web interface is not refreshing and all devices show as offline. My log files are clean. I am only using the web interface and database. It would seem the only way I can get the data to refresh is by restarting the service. Log out and log in, gives me the same result, no fresh of the data for the devices. Can you point me in the direction to resolve this and what do i need to update in the database to show device online if I have current positions? Thanks! Log time user, love the product!

Anton Tananaev8 years ago

Traccar has in-memory cache. You would need to change a lot of back-end logic if you want to always query database.

Zack8 years ago

Is there anyway to accomplish this task easily? I only need to refresh the interface...Is there a way to use the API to insert positions from the other database? Will that work for what I am trying to accomplish? I just do have any ability right now to install traccar client on the devices. I just want to use the data we already have from another system if possible. Thank you.

Anton Tananaev8 years ago

You can use OsmAnd protocol:

https://www.traccar.org/osmand/

Zack8 years ago

Thank you. I will do that. What is "hdop={3}" ? I don't understand what that parameter is... is that the attributes?

Anton Tananaev8 years ago

It is HDOP, but it's not required.