Zip Code Searching

Return to Index

If you live in any of the countries for which zip code geocoordinate data exists (presently Australia, Austria, Belgium, Canada, France, Germany, India, Italy, Mexico, Netherlands, Portugal, Russia, Switzerland, UK, USA), then you'll defintely want to enable the zip code proximity feature.

This allows your users to search within X miles or kilometers of a particular zip code. When the user selects one of the supported countries, a new "Search within" option will appear, as shown below.

In osDate 1.x, and option existed during installation to enable this feature. Unfortunately, it was causing a lot of PHP time-outs since some zip code files are massive, like Canada's. Thus, in osDate 2.x, zip code loading is an option that can be accessed in the admin panel "Process Zip Codes File" link.

Simply choose the country, the zip codes .csv file, and the "Load into DB" as the action, as shown.

If this process causing a PHP time-out or Internal Server error, you may instead manually insert the zip codes by creating an SQL script. This will save a raw .sql file in osDate's "temp" folder, after which a system admin should be able to manually insert the SQL data into MySQL (there are various MySQL command line options for insertion of large SQL data quickly).