Thread: the postcode files in the downloads section

In Dolphin 7, it gets imported into the sys_zip_codes table.... the tables are rather large, so you may need to use the mySQL command line to import them if PhpMyAdmin times out on you.

Also, you need to check the format, as the table in downloads was for previous version of Dolphin, perhaps Dolphin 7 has some new fields now:

`ZIPCode` varchar( default NULL,
`ZIPCodeType` char(1) default NULL,
`City` varchar(2 default NULL,
`CityType` char(1) default NULL,
`County` varchar(25) default NULL,
`CountyFIPS` varchar(5) default NULL,
`State` varchar(30) default NULL,
`StateCode` varchar(2) default NULL,
`StateFIPS` varchar(2) default NULL,
`MSA` varchar(4) default NULL,
`AreaCode` varchar(3) default NULL,
`TimeZone` varchar(10) default NULL,
`GMTOffset` int(11) default NULL,
`DST` char(1) default NULL,
`Latitude` double default NULL,
`Longitude` double default NULL,

As for using it - Dolphin 7 has a setting:

('enable_zip_loc', 'on', 15, 'Enable search by ZIP codes', 'checkbox', '', '', 3, '');

in the admin panel / glparams

But so you know - we don't really use ZipCodes much anymore - as they only really work well for the USA... we prefer to use WorldCities.

Smoge

Just a note. This did work for me and Im on 7.0.3.however I had to change 'ZIPCodes' to `sys_zip_codes` in the INSERT statements. Same fields though and made my zip radius work as a short term fix until I decide how I'm going to handle it permanently.

Smoge, can you PM me the cost of World cities implementation.... thanks

maknoiz