1 - driver I think should by in lower case
2 - I'm sorry, visualization works only for lines, ie I build polyline, ie in your case if all will be correct you should get one line (you set one object for all rows).
Visualization to create placemarks from external databases is only on development stage.
you mean i can't get a list of latlong from database and put as markers on map?
database is internal (the same of Joomla!)
for workaround, can i put paths with only1 coordinate using "one objet for each row" so i show only 1 markers for each path?
i explain better what i have to do
i have a list of gps device that trasmit position (every x time) and send in a database (this joomla database):
type of device
type of message
I need to show markers for:
type of device
type of alarms
a specific device
are device that trasmit only positions and i want to show markers of last position of all devices(FLEET type) and/or the last X position of a choosen device (could be lines for each device showing last 10 position...START END )
a clock should stay in interface and every X seconds search in database if there are alarm (not yet MANAGED)
(clock should be clickable to say "verify now")
if there is an alarm (not yet MANAGED):
it should show a popup (or in a list on the left...or better show markers on map with color based on type of alarm EMERGENCY/ASSISTANCE) that show alarm with buttons "MANAGE ALARM" that put that alarm in state "MANAGED" and show on map.
Alarm position on map should show:
details of alarm (device, ship associated to device, name of captain of ship, phone ecc.)
and 2 buttons (in marker popup)
that should show markers from other 2 tables and show markers of every record (centering map on alarm obviously)
- Alarm myust be showed immediately (after database reading)
- I must give the possibility to show the last X alarms and/or LAST/LAST 10...20...30 alarms of a specific device (or FROM DATE...TO dATE)
is this possible with your plugin?
if no, are you able to help me (with paying support obviously)
i add some progress
now i can show a line for all devices but i can't show a line for each device (see images)
i need a line for each device (id is "esn" field)
how can i group every line for each esn device so i can show path history of each device separately?
"each row" doesn't show anything
Lets step by step.
By visualization you can show line from other table than mine.
As I understand right you have attribute, which tell what device is.
tabl1 (lat, lng, device_name, date_in)
And in this case you set where by device_name - and get line for your device.
One device -> one line -> one visualization->one path