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 profoxtech-bounces@leafe.com On Behalf Of M Jarvis Sent: Monday, 28 January 2019 19:27 To: profoxtech@leafe.com Subject: Re: Google API for Geocoding ... Again
On Mon, Jan 28, 2019 at 10:25 AM Kurt @ Gmail kurthwendt@gmail.com 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]