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 <[email protected]> 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]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
