I wish to create an attribute for a device and also to update the "model" and "phone" fields, taken from values in another database. When I create the attribute or set the model using a SQL statement it works OK but when I log in to the Traccar web interface it is not picked up. I have tried setting the lastupdate timestamp at the same time but still not picked up.
How should I go about updating the devices table using MySQL?
There is internal cache in the server. It won't read the database, unless something changes.
But I have changed something! Can I let the server know a value has changed or can I only use the web interface to set attributes?
You have to use API to make modifications.
I wish to create an attribute for a device and also to update the "model" and "phone" fields, taken from values in another database. When I create the attribute or set the model using a SQL statement it works OK but when I log in to the Traccar web interface it is not picked up. I have tried setting the lastupdate timestamp at the same time but still not picked up.
How should I go about updating the devices table using MySQL?