At 04:09 AM 5/27/2011, Adrian Hüssy wrote:
For an application I should read and interpret the result of an html-site.
If I call a specific URL with parameter, the URL displays a string in html.
This value is needed in a RBASE for Windows application.
I would be able to present the URL within an internet browser object in
a form and ask the user to copy and paste to variable/database fields by
himself, but I would prefer to run this process automatically in the
background.
Has anybody an idea or a tool to pass or receive a html page to RBASE for
Windows without user interaction? The URL has not to be displayed.
Example (copy till end of line for testing, the
spaces are part of the parameters):
http://tinygeocoder.com/create-api.php?q=3935
Old William Penn Highway,%20Murrysville,%20USA
Returns geo-coordinates for RBase Technologies Inc.: 40.42754,-79.69132
In another case, other URL, I receive a
formatted html table, where I should extract
some needed values.
Adrian,
Here's how:
01. Start R:BASE eXtreme 9.1 (32/64)
02. Create a new command file/Custom EEP with the following code:
-- Start here ...
SET VAR vAddress TEXT = '3935 Old William
Penn Highway, Murrysville, PA 15668 USA'
SET VAR vCommand TEXT = ('PLUGIN RGeoCoder vResult|'&.vAddress)
&vCommand
RETURN
-- End here ...
Resulting vResult variable will include both
coordinates (Latitude,Longitude),
separated by comma, which you can use to achieve your goal.
Note:
You may also define "vAddress" variable dynamically, if you wish.
Note:
Among many productivity tools and surprises, a live demo is also scheduled for
14th Annual R:BASE Conference (October 8 - 9,
2011). http://www.rbase.com/events/
Very Best R:egards,
Razzak.
