Newbies tbnlp Posted June 16, 2006 Newbies Share Posted June 16, 2006 Does anyone know how I could set up to retrive zips from a website? I have addresses in a database, but no zip codes, I would like to be able to automate going to the usps.com site, where you can enter an address and get the zip code. I have thousands that need done and doing them by hand will take forever. Is there a way to set this up? I have seen where you can do a similar thing with maps, entering data and it will retrive the map from a web site. Any help would be appreciated. Link to comment Share on other sites More sharing options...
Lee Smith Posted June 16, 2006 Share Posted June 16, 2006 (edited) Hi tbnlp, and welcome to the Forum. Wouldn't it be easier to use a related file with the city and zips. There are several example files here on the Forum (do a search for Zip Code or Zipcode and City and you will find about 220 hits), Recently, someone also posted a current list of Zip Codes. If you do a search for zipcode, you will see a thread about Map Quest also. HTH Lee Edited June 16, 2006 by Guest Link to comment Share on other sites More sharing options...
ralph.nusser Posted June 17, 2006 Share Posted June 17, 2006 Yahoo and Google have an xml service where you get not only the zip code but longitude and latitude as well: "http://api.local.yahoo.com/MapsService/V1/geocode?appid=YahooDemo&street=356+Salem+Tpke&city=Bozrah&state=CT" Answer of yahoo: <?xml version="1.0" ?> - - 41.506255 -72.136271 356 SALEM TPKE BOZRAH CT 06334-1518 US - An example how you can put the data into FileMaker [you need the Troi URL-Plugin: URL-Plugin ] and parse it I uploaded here: Thread of German FileMaker Magazine With Google: "http://maps.google.com/maps/geo?q=356+Salem+Tpke,Bozrah+CT&output=xml&key=YOUR_API_KEY_HERE" Answer of Google: <?xml version="1.0" encoding="UTF-8" ?> - - 356 Salem Tpke,Bozrah CT - 200 geocode - 356 Salem Tpke, CT 06334, USA - - US - CT - New London - 356 Salem Tpke - 06334 - -72.139170,41.506223,0 You see you can get the zip codes as well. Happy FileMaking Ralph Nusser Link to comment Share on other sites More sharing options...
Genx Posted June 17, 2006 Share Posted June 17, 2006 THEY'RE ALWAYS LIMITED TO AMERICA!!! I get so annoyed about that some times, having access to proper google maps from aus would make my life so much easier. Oh well... Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6522 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now