The pay for this gig is So Small - that it would not be worth it to pay
for any SW to assist with this task.
As is, I found simple code to allow me to open a URL within a Browser
window/tab from within VFP. And, I did Google Mapping between locations
for directions - and figured I could just pass this as a URL. So - I
made this little app that allows me to plug in up to 4 locations (as the
woman would make multiple stops) - with the start & end of her trip
being her home location. So, although its rather simple - it works for
my purposes.
Thank you everyone for your input on this!
-K-
On 2/4/2019 6:39 AM, Chris Davis wrote:
Not sure if this will help as only glancing at these emails but in vfp I do
visit the following URL
http://maps.googleapis.com/maps/api/geocode/json?address=##ADDRESS##
using either vfpconnection or the Microsoft html thing ( I can be more specific
if required)
the ##ADDRESS## is replaced with a postcode for instance
http://maps.googleapis.com/maps/api/geocode/json?address=WS98ER
You used to be able to do this all day long (there was a throttle that kicked
in at some point based on your IP address but the limit was something like 5000
calls a day)
These days I believe you need an API key which you would need to pass in with
the query to get your JSON back with the lat and lng in.
I believe you need a paid for account now but you get $200 dollars usage credit
each month for the API which I think for modest usage is plenty.
-----Original Message-----
From: ProfoxTech <[email protected]> On Behalf Of M Jarvis
Sent: Monday, 28 January 2019 19:27
To: [email protected]
Subject: Re: Google API for Geocoding ... Again
On Mon, Jan 28, 2019 at 10:25 AM Kurt @ Gmail <[email protected]> wrote:
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.
I did something like this back in 2008 or so and I'm pretty darn sure I posted
it here but I'll be darned if I can find it. Maybe your Search-Fu is better
than mine so you might be able to dig it up.
I used MS Access to do the work but it did the exact thing you are trying to do.
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[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.
