Ok - yes, I'm dredging up a VERY Old thread here!
So, here's the deal. A woman I worked with for this Jewish Holiday Pop-up shop here in SF this past late Nov./early Dec. - she wants me to do a kind of Admin task for her. She's going to give me a spreadsheet of locations - and wants me to use Google Maps to find the distances traveled. She then has to note the distances back into the spreadsheet. It may have to do with reimbursement based upon mileage.
As such, was hoping I could potentially whip up something Simple to help me automate the process - so, I was looking at this particular discussion thread.
So - Ted - I was curious about your hack. I actually HAVE a LONG Time ago done something similar - to launch IE. But, for the life of me - I no longer remember what the VFP code was to do exactly that. Can you maybe throw me a bone here on how to launch IE from inside VFP? I suspect it DOES have something to do with the Run command in VFP...
TIA,
-K-
On 9/13/2016 6:46 AM, Ted Roche wrote:
A hideously-ugly hack that might do the trick would be to automate an IE browser session, feed it the URL, and parse the source result searching first for "location" then for the nearest "lat" and "long" in the resultant source.
On Tue, Sep 13, 2016 at 6:44 AM, Dave Crozier DaveC@flexipol.co.uk wrote:
Fellow Gentlemen, I posted a request about doing geocoding requests to receive back a Lat/Long dataset for various addresses a few weeks ago and now find that Google do in fact provide a Geocoding service:
https://developers.google.com/maps/documentation/geocoding/start
The responses back from the requests are all JSON from a Java Script API run by Google. I have looked over Rick's Westwind site to try and get a start on using this method to get back a JSON response but seem to be getting nowhere fast. Anyone got any ideas on a simple & neat way of retrieving this data back using VFP programmatically? Either that or anyone know a free Geocoding site that would handle up to 100 name and address calls per day ideally by sending a text file and receiving one back which could be automated from the VFP end.
Never even looked at Web services in anger before so it all seems a little baffling and terribly long winded at the moment unless I am missing something obvious.
Note I don't want to have to drop into an intermediate program/language to accomplish this, if possible.
Dave
[excessive quoting removed by server]