Import GPX
Using API? You'll have to write a script.
Ok, do you have any documentation for the "area": "string"?
It's in WKT format:
https://en.wikipedia.org/wiki/Well-known_text_representation_of_geometry
Hi Anton,
I am importing data using WKT file of my city but, it is giving this error.
Data truncation: Data too long for column 'area' at row 1 - MysqlDataTruncation (... < QueryBuilder: 446 < DataManager: 425 < BaseObjectManager: 123 < ...)Dont hijack this thread.
In PhpMyAdmin go to Database: traccar »Tabell: tc_geofences change area, change type from varchar to longtext
You are discourteous.
It is not a matter of hijacking a post, Noob one is just asking a question with some hope.
I just need to confirm the impact during migration of the server if I will change the datatype in the database.
Any way, Thanks for the help
Yes you hare hijacking, just create your own thread.
Is API script still the only method to date ? (No option for polygon import directly via UI)
It doesn't seem like your question is related to the topic. You can upload a GPX geofence via UI, but we don't support bulk upload and we only support polylines.
Can the DB entry be edited from polyline to polygon ?
Probably. Never tried.
Removing geofences directly in the DB still has those removed geofences alerting.
Is there a cache to be flushed ?
Yes. That's why you should use the API instead of modifying the database directly.
Simple mariadb update seems to work fine converting polyline to polygon.
How involved would it be to now only query "line" or "poly" upon uploading via the UI ?
Hello!
Have a file with about 100 geofences in one GPX file. If i import that using the UI i only get one geofence, how can i import all of them?