Postcode/Zip Codes

[stuart]

Hello

Does anyone have a "formatted for PhotoPost Classifieds" UK Postcode database file that I can use.

I am desperate to get this feature working on my new site and would welcome some help.

Best regards
Stuart

[Chuck S]

You can import any type of CVS file you create into the zipcode database.

There are discussions here where I have said what I am going to say below. Basically you would need to look at the zipcode fields in the zipData table and then any UK zipcode database you get using excel or any type of cvs file you have you need to create a new cvs moving around the columns of data in your uk file to the format of the zipData table. You can add in blank columns where your uk field might not have data like CityName etc and ditch any columns of extra data that the table does not use. As long as you create a zipcode database in the format of our table. I do not know how different the formats are there in the UK.

[stuart]

Originally Posted by Chuck S

You can import any type of CVS file you create into the zipcode database.

There are discussions here where I have said what I am going to say below. Basically you would need to look at the zipcode fields in the zipData table and then any UK zipcode database you get using excel or any type of cvs file you have you need to create a new cvs moving around the columns of data in your uk file to the format of the zipData table. You can add in blank columns where your uk field might not have data like CityName etc and ditch any columns of extra data that the table does not use. As long as you create a zipcode database in the format of our table. I do not know how different the formats are there in the UK.

Hi

I am in the MYPHP ADMIN - having trouble finding the zipcode database?

I have created a zipcode file for the uk in CSV format - how and where do I use it?

Thanks for any help.

stuart

[Chuck S]

Stuart what I am saying is you will need to do is created a csv file in the format of the zipData table. You should be able to see the fields and in what order they are in in that table.

zipcode, ZipCodeType, City, CityType, State, StateCode, AreaCode, lat, lon

You would use empty columns in the cvs for any fields your uk database does not have.

The important columns that need to exist are zipcode lat and lon. Those are the ones our program uses. We grab the latitude and longitude based on the zipcode.

You would arrange your final result in the order of the column structure above and I beleive phpmyadmin has an import option to import a cvs file but of course you probally can not do more than 2mb at a time so you may need to break your cvs into multiple files.

[stuart]

Originally Posted by stuart

Hi

I am in the MYPHP ADMIN - having trouble finding the zipcode database?

I have created a zipcode file for the uk in CSV format - how and where do I use it?

Thanks for any help.

stuart

Okay got it - and now implemented, and it works - many tanks.

Regards
Stuart

[Chuck S]

Yep its all about having the cvs in the proper format for the mysql table

[Chuck S]

If you wish you can post any zipcode stuff you made here if you want to share.

http://www.photopost.com/forum/classified-mods/