View Full Version : Zip Code Installation
July 17th, 2010, 12:14 PM
Hi I just want to verify what is needed for Zip Code searching. Many of the threads I am reading are a few years old. I have a third party database that i purchased from zip-codes.com. Are there instructions on how and where to load the data for the zip codes? Details are really appreciated.
July 17th, 2010, 01:26 PM
well we use a table in our database called zipData and you can find the fields there in the classifieds database.
CREATE TABLE zipData (zipcode varchar(10) NOT NULL default '', ZipCodeType char(3) NOT NULL default '', City varchar(128) NOT NULL default '', CityType char(3) NOT NULL default '', State varchar(64) NOT NULL default '', StateCode varchar(5) NOT NULL default '', AreaCode int(5) NOT NULL default '0', lat varchar(8) NOT NULL default '', lon varchar(8) NOT NULL default '') ENGINE=MyISAM DEFAULT CHARSET=utf8;
I am posting the structure here as a courtesy. You would need to create an importable sql or txt file with the necessary fields in the correct order in order to use any new entries.
our included zipdata is a free us zipcode entries.
July 25th, 2010, 03:51 PM
Thanks for the information... Do you provide services to import data like this or can you recommend who might do so. I have the database I purchased but do not know programming.
July 26th, 2010, 07:33 AM
well the problem is that its not programming.
You would need to edit the cvs or txt file you recieved and match the columns up to the format of the zipData table.
Using a spreadsheet application on your home computer is the best way to create a new csv or txt file to import into phpmyadmin database viewer.
vBulletin® v3.8.1, Copyright ©2000-2014, Jelsoft Enterprises Ltd.