Google Maps API
-
@TeleFox said in Google Maps API:
@TeleFox It says I am a vendor here... but I do lot's of things. Almost wish it didn't say that... I am not trying to charge to assist you with that.
You can change the visibility of the tag in your profile.
-
@TeleFox said in Google Maps API:
@TeleFox It says I am a vendor here... but I do lot's of things. Almost wish it didn't say that... I am not trying to charge to assist you with that.
I prefer that vendor accounts are marked as such. That way, someone seeking technical help for your product can find you more easily, and the rest of us can temper what you post with the fact that you do indeed have something to sell. It's only fair to the community that your vendor status is visible, because you could likely sway purchasing decisions with what you post.
-
@RojoLoco too bad, because @Minion-Queen has said that voluntary self identification is the rule here.
Also he is more of a Service Provider than a vendor. The tag categories are honestly not great. Also a user cannot add themselves to a group. It has to be assigned by the mods. After that, the user can select what shows based on what is available.
-
And it looks like we can self join groups now. Wonder when that feature was added to NodeBB. I admit I do not read the release notes too much.
https://mangolassi.it/groups -
@JaredBusch said in Google Maps API:
@RojoLoco too bad, because @Minion-Queen has said that voluntary self identification is the rule here.
I said prefer.
-
Thought I may as well hijack this thread rather than starting a new one.
I have a Google Map showing customer locations. This is currently updated entirely manually. When we get a new customer, we update a Google sheet with the new details, then in the map we delete the existing layer entirely and re-create it by importing data from the Google sheet. This is obviously a rubbish and time-consuming way of doing it.
Firstly, I can't seem to find a way to dynamically link a Google sheet to the map data. When the Google sheet is modified, it doesn't update the map. You have to delete the layer and re-import the data. Is there a way to dynamically link it? I could just update the map data directly, but it looks very limited compared with a normal Google sheet.
What I really want is a single script that will extract the customer data from our SQL Server database into a .csv file (or Google sheet if possible), and then automatically update the map. I then schedule this script to run once a day.
I've attempted using the Google API in the past but failed miserably (granted I didn't spend long on it, and it was a few years ago). Is this something that is going to be easy to do, and where should I start?
-
@Carnival-Boy Hi Carnival.. is it something that is easy to do? It may seem daunting at first but it is pretty easy. I would start here.. with this tutorial..
https://developers.google.com/maps/documentation/javascript/store-locator
The trick is building the MYSQL table getting it to spit out XML from a .PHP which is all outlined how to do that. Then it is just a matter of importing the .csv or creating a page that can interact with your MySQL database to update it. This is actually how I have created several of these types of maps for different companies and my own.. I actually don't even know what you mean by importing the map and a Google Sheet.. I have not done it that way before. Are you referring to Fusion tables? Sort of lost on how you set yours up originally. Sounds time consuming and difficult.
-
@TeleFox said in Google Maps API:
@Carnival-Boy Hi Carnival.. is it something that is easy to do? It may seem daunting at first but it is pretty easy. I would start here.. with this tutorial..
https://developers.google.com/maps/documentation/javascript/store-locator
Thanks. I'll take a look. It's not what I'd call easy.
I actually don't even know what you mean by importing the map and a Google Sheet.. I have not done it that way before. Are you referring to Fusion tables? Sort of lost on how you set yours up originally. Sounds time consuming and difficult.
My way is dead easy, but time consuming. It doesn't use Fusion tables. I just open up my Google map, delete the existing layer and add a new layer:
http://i.imgur.com/jHH7mNu.png
which prompts me to select a Google Sheet:
-
@Carnival-Boy I see so it is not on a website.. it is the maps in your google account and you are just loading a sheet. So is this for internal use only? Not for your customers to get to? Or do you send them this or something / share?
-
@Carnival-Boy Nevermind I just reread it.. it shows your customer locations.. so assuming this is an internal tool.. well yes I agree it did take me a small Google Map API degree to figure all this stuff out.. glad to help out and make it more streamlined if you guys need though. Just let me know what you need I love working with the maps API.
-
Yes, it's internal. Sorry, I should have made that clearer in my OP. Although it's actually a list of merchants that sell our products, so I can see that ultimately we may want to make it public and put it on our website. That's at least a year away though.
