mediatribe.net -- Drupal and Web Development

Notice: this post was last updated 3 years 33 weeks ago so it might be outdated. Please be cautious before implementing any of suggestions herein.

Adding postal codes for Canada to Drupal location module

The Drupal location module does not ship with Canadian postal codes. I've recently had to fix this on two Drupal 6 sites, here is how:

wget http://www.freeformsolutions.ca/en/sites/mediatribe.net/files/downloads/zipcodes.ca.mysql.zip
unzip zipcodes.ca.mysql.zip 
drush sqlc < zipcodes.ca.mysql #### takes 10 minutes!!!
rm zipcodes.ca.*