vfp9 get data from google maps 1

[stardemos]

hello, i'm new to vfp,and i'm loving it.
Anyway, i have a questin, i nedd to get the distance from gogle maps, it´s that possible? how?
for better undestanding of the question, this is part of my code.

Do ydeclare

Local m.yfrom,m.yto
m.yfrom=Inputbox("Origem","",lcTextO)
m.yto=Inputbox("Destino","",m.lctext)

If Empty(m.yfrom) Or Empty(m.yto)
    Return .F.
Else
	m.yfrom=Allt(Strtran(m.yfrom," ","-"))
	m.yto=Allt(Strtran(m.yto," ","-"))
Endi
Local m.url
m.url="[URL unfurl="true"]https://www.google.pt/maps/dir/"+m.yfrom+"/"+m.yto[/URL]
_Cliptext=m.url  &&url in clipboard
Local apie
apie= Createobject("wscript.shell")
apie.Run(m.Url)
Procedure ydeclare
Declare Integer BringWindowToTop In user32 Integer
Declare Integer SetWindowText In user32 Integer,String
Declare Integer Sleep In kernel32 Integer
Endproc

this give me the best ways to get to my clients, now i nedd to get the distance from the google maps. and insert it in my db.

 

[Mike Lewis]

Welcome to the forum, and to VFP.

The best way to solve your problem is probably to use the Google Maps API. Calculating distances between two points is one of the things it was invented for.

For general information about the API, see

https://developers.google.com/maps/.

For specific details about getting distances between locations:

https://developers.google.com/maps/documentation/distance-matrix/intro

I suggest you start with that, then come back if you have any questions about how to do it in VFP.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Olaf Doschke]

You could start with this:

https://maps.googleapis.com/maps/ap...nations=Seattle+WA&language=en&units=imperial

Overall, if you intend to do more than just displaying a map and directions by running a URL, you should use official APIs, get an API key and start at

https://developers.google.com/maps/documentation/

Bye, Olaf.

 

[stardemos]

thanks, if that's the way, i will take it.

 

[Mike Lewis]

Let us know how you get on. What you learn could be useful for others.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Mike Gagnon]

Stardemos
If you need help I have develloped a full version of multiple waypoints with distance between waypoints and a feature that optimizes the route. Post back here if you want help.




Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[stardemos]

hello, i have been trying to read the xml, without any success, the xml opens in the browser with the data that i need, i just dont know how to get the data.... any help will be apreciated.

 

[Olaf Doschke]

URLDownloadToFile would work, for example. Winsock, XMLHTTPRequest aka Microsoft.XMLHTTP -

http://fox.wikis.com/wc.dll?Wiki~XMLHTTP

Just put in your URL(s).

Also helpful:

http://www.sweetpotatosoftware.com/...ction-update-http-post-ftp-commands-and-more/

Bye, Olaf.

 

[Jockey4]

Hi,
Distance from address1 to address2.
Which distance? a) straight line (air distance) or b) road distance ?
For each Google has a solution to be implented into VFP
Regards,
Jockey(2)

 

[Olaf Doschke]

Yes, the documentation we pointed to covers that topic, too. Default distance is computed for a car, so taking roads into account, and resulting in no result, if you pass in locations parted by an ocean. You can change the travel modus parameter from pedestrian up to airplane, I think. Well, it's all in the google developer documentation. Somehow there surely is a danger of computing a route with one API and a distance with another, when the two systems don't share the same route.

Perhaps take Mike Gagnons offer? He seems to have already delved deeper into these APIs.

Bye, Olaf.

 

[Mike Lewis]

Distance from address1 to address2.
Which distance? a) straight line (air distance) or b) road distance ?
For each Google has a solution to be implented into VFP

You are right, but doesn't the API takes care of all that?

Of course, if it was simply a straight-line distance, you might not need Google maps or any other on-line tool; it could be a simple bit of trigonomotry (depending on the country).

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Mike Gagnon]

Try building this line and you will get driving distance between Montreal and Toronto in a JSON format

http://maps.googleapis.com/maps/api/directions/json?origin=Toronto&destination=Montreal&sensor

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[Mike Gagnon]

You might want to try Bing Maps, which is a more complete API with less restrictions, which depending what you want to do, may give you a result like this.

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[stardemos]

maybe its a good idea to try it, can you show some samples of your code?


maybe its better to explain myself even better about this project of a program, it must be integrated insid another software develope in foxpro, so i can´t depend on .dll or .fll because i cant access them. by the way, all of other ideas seem to work fine in pure vfp.

 

[Olaf Doschke]

What do you mean, you can't access a dll or fll? FLL are foxpro link libraries, DLLs specifically aimed for being used in Foxpro via SET LIBRARY TO some.fll
DLLs can be used by DECLAREs, typically. Or if it's assemblies by wwDotNetBridge.

But who pointed you to a DLL, yet?

Bye, Olaf.

 

[stardemos]

while trying this option,

http://fox.wikis.com/wc.dll?Wiki~XMLHTTP,

the software gave me the error tha msxml3.dll was missing.
its possible that i've read it wrong...but im prety sure thats what it says.

 

[Olaf Doschke]

On which Windows version are you? CreateObject("Microsoft.XMLHTTP") should work from Windows 98 to 10 - all the way.
Besides that, the VFPConnection.FLL has a nice and easy interface to do both HTTP get and post requests, too including FTP/FTPS, when you may need it later, too.

Bye, Olaf.

 

[Mike Gagnon]

Here is how to get GPS coordinates from a physical address.

http://www.atoutfox.org/articles.asp?ACTION=FCONSULTER&ID=0000000715

Here is how to get the address from GPS coordinates

http://www.atoutfox.org/articles.asp?ACTION=FCONSULTER&ID=0000000719

Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[stardemos]

im on win 10, but this code is running under another software, PHC management software. thats the reason why i can use dll files, until now. i believe thats possible.

 

[Olaf Doschke]

Microsoft.XMLHTTP is a COM Server, you only use the MSXML DLL indirectly. You can only use CreateObject() in VFP. If this software is allowing you to execute VFP macros/scripts but only supports a partial set of commands and functions, that might be a reason, but as you get a concrete message about msxml3.dll missing, your system seems somewhat broken in respect of system components, not about VFP or PHC. MSXML is deep in the system. I have Microsoft.XMLHTTP available on Windows 10, not only in VFP, also from powershell, for example:

If that errors, too, you know you have a problem on the system, neither in VFP, nor PHC, but in your Windows.

Bye, Olaf.