Although the usa_zipcodes.txt file that you are given has the correct values inside, the import tool is somehow replacing it will all 9s.
Like this:
ZipCode___Latitude___Longitude
90210___99.9999999___-999.999999
When it should be:
ZipCode___Latitude___Longitude
90210___34.086771___-118.411853
At this time, we are not positive what is the actual cause of this issue, but we suspect it has to do with mysql versions higher than 4.0.1.
There is an easy fix if you have a mysql database manager tool available, such as phpMyAdmin.
If you have phpMyAdmin (or similar) tool availabe, here are instructions for increasing the field size to allow for correct importing of lat/long coordinates during a zip code or postal code import.
CODE
You can use phpMyAdmin to make a change in the size of the latitude and longitude fields. These fields were built during install as a double(7,7). We need to change them to a double(10,7).
In phpMyAdmin, find the database that you use with your locator system. Click the database name to see all the tables that are available. Find and click on the "zipcode" table name.
When you see all the fields listed, with their attributes, you will see this:
latitude double(7,7) NOT NULL default '0.0000000',
longitude double(7,7) NOT NULL default '0.0000000',
or something very similar.
You need to change the [B]7,7 [/B]to a higher number.
You can click the "edit" icon for each on of these fields and edit the way that field is built.
Click the edit for the latitude field, then enter [B]10,7[/B] for the size.
click save.
do the same thing to the longitude field.
Then, login to your Admin Control Panel and do a "Import Zip Code" tool to reimport your USA zip codes.
Make sure you select 'overwrite' option and browse your computer and look for the usa_zipcodes.txt file that came with your download.
In phpMyAdmin, find the database that you use with your locator system. Click the database name to see all the tables that are available. Find and click on the "zipcode" table name.
When you see all the fields listed, with their attributes, you will see this:
latitude double(7,7) NOT NULL default '0.0000000',
longitude double(7,7) NOT NULL default '0.0000000',
or something very similar.
You need to change the [B]7,7 [/B]to a higher number.
You can click the "edit" icon for each on of these fields and edit the way that field is built.
Click the edit for the latitude field, then enter [B]10,7[/B] for the size.
click save.
do the same thing to the longitude field.
Then, login to your Admin Control Panel and do a "Import Zip Code" tool to reimport your USA zip codes.
Make sure you select 'overwrite' option and browse your computer and look for the usa_zipcodes.txt file that came with your download.
So far, by expanding the field size, this has eleminated this problem. If you experience further issues or need more help with this issue, please contact support.