April 25, 200817 yr Hi, Is there any way to pull in 3rd party data from the web during a FileMaker script triggered from a browser (via FX.php or even IWP)? I need to pull in some data on-the-fly from Google Maps, depending on a user's address. Unfortunately it seems: A. I can't use Web Viewers (possibly because they are only rendered client-side and a browser client cannot process the results) B. I can't use cURL since the AppleScript script step is not web-compatible. Am I wrong on either of these points? Is there any other/better way to pull in data from a 3rd party website during a script triggered from a browser? Thanks for any advice. ft. DESCRIPTION OF PROCESS I have a database of 3500 stores. Store locations were geocoded using Google maps. The long/lat coordinates of each store are kept in indexed fields. I have a scripted proximity search which works great in FileMaker as follows: 1. A user enters their own address details and a search radius (distance in miles) and hits 'search' button. 2. A webviewer queries Google Maps and returns the lat/long for the user's address. 3. Distances from user-to-stores are calculated for the stores. 4. A search is done on the distance field for stores within the distance entered in step 1. 5. The resulting stores are returned to the user. I need to get this to work via the web.
Create an account or sign in to comment