Fill Map Via DB Feed
Permalink Browser Info Environment
Hi There,
Just installed your add-on, looks very good, thx. for that good work.
As we are a company that develop/sell IoT solutions to measure Air Quality, humidity etc... we would like to populate the map with our sensor locations which are stored in a database.
So any information/coding example, hints or how-to you could pass to us so that we can program/add this feature ?
The fixed manual grouping & location does not work for us, we would like to populate this based on the logged-in user ID which is connected to a contract so that the user can only see his sensors.
Many thanks,
Walter Verhoeven
Just installed your add-on, looks very good, thx. for that good work.
As we are a company that develop/sell IoT solutions to measure Air Quality, humidity etc... we would like to populate the map with our sensor locations which are stored in a database.
So any information/coding example, hints or how-to you could pass to us so that we can program/add this feature ?
The fixed manual grouping & location does not work for us, we would like to populate this based on the logged-in user ID which is connected to a contract so that the user can only see his sensors.
Many thanks,
Walter Verhoeven
| Type: | Discussion |
|---|---|
| Status: | Resolved |
Dear Ryan,
Thanks for your swift reply. In fact I already wrote a PHP page that shows my sensors in Google Maps but I had issues running it via the HTML block as that does not execute PHP code. So that's why I was looking at your great add-on. In the mean time I found out that we can add my page via the Single Page feature of Concrete5. So bottom_line I found my solution.
So for the moment I will not use your add-on but thanks for the hint on the table content, I can populate that with my data, that will be no problem. The user on the other hand would need some extra coding so if you can share me your thoughts on how to achieve that, would be great !
I am a also a programmer so that would work for me.
BIG thanks,
Walter Verhoeven
Thanks for your swift reply. In fact I already wrote a PHP page that shows my sensors in Google Maps but I had issues running it via the HTML block as that does not execute PHP code. So that's why I was looking at your great add-on. In the mean time I found out that we can add my page via the Single Page feature of Concrete5. So bottom_line I found my solution.
So for the moment I will not use your add-on but thanks for the hint on the table content, I can populate that with my data, that will be no problem. The user on the other hand would need some extra coding so if you can share me your thoughts on how to achieve that, would be great !
I am a also a programmer so that would work for me.
BIG thanks,
Walter Verhoeven
the database table that is used to store the map locations is really quite simple, it's called MsvLocationMapLocation. My suggestion would be to simply write some sort of script that fetches the data from your sensor locations database and populates this table. This could potentially be done with an Automated job.
For the filtering to the logged in user, this would require some direct changes to the block, as well as a new field to store the user_id. But I don't believe these would be difficult to make.
What I don't know is your technical background - whether you'd be happy to tackle these things, are if you are needing assistance.
(I'm travelling over the next few days, so my replies may be delayed)
Cheers
-Ryan