Zip / Post code - UK not working

jammy_basturd · March 16th, 2009, 09:05 AM

I appreciate that the zip code feature has been designed for use with US and Canadian zip codes, but I've managed to import a table of UK post codes in to the zipcode DB but it still isn't working.

Everytime I enter a zip code, the cookie is created fine, but the input box in which you enter the zip code just reappears.

Anyone know what mods are needed to get the system working with UK post codes? I found a few posts/topics by BenFF, but his code was moved to another site that is now defunct.

Pleasseeeeeee.

Chuck S · March 16th, 2009, 09:30 AM

Not sure what you mean really

The UK post database would need to be entered into our zipData table in the same proper format so it is readable by the program but aside from this the program should be totally able to read alphanumeric zipcodes.

Chuck S · March 16th, 2009, 09:33 AM

The only issue we ever had in the past was typecasting the zipcode as an INT (interger) whereas along time ago we made sure it was a STRING so alphanumeric zipcodes could be used. In fact Canada uses alphanumeric zipcodes if I am not mistaken. Only the US uses numeric zipcodes I think.

jammy_basturd · March 16th, 2009, 09:41 AM

Hmmm, not sure exactly what the problem is then! :S

This is a sample from the CSV I uploaded in phpyMyAdmin:

Code:

Content visible to verified customers only.

The product is storing the post code fine, and the cookie with my post code is there too.

Would you like me to send you a link and server login details?

Chuck S · March 16th, 2009, 09:48 AM

well what do you think is wrong you can post a url and test user login here

Chuck S · March 16th, 2009, 09:49 AM

Also based on that CVS nothing should get imported into our table. There are nine fields not 8 so your missing one.

,,AB10,,,,Aberdeen,,'57.13','-2.11'

jammy_basturd · March 16th, 2009, 10:10 AM

Haha, there was more than that wrong with it. Can't believe I didn't spot that the longitude field wasn't there when I browsed the table in phpMyAdmin! Technically there were 9 fields there, because of the comma at the end, but the long and lat fields weren't in the right place.

Also, found that the ' either side of the long and lat fields were messing it all up. With those there it wasn't working. Now I've removed them its calculating the mileage fine!

I read in another topic that a user can't change their post code unless they delete their cookies?! Like the other user that posted about this I think its incredibly undesirable. Surely it wouldn't be too hard to have a page in the My Profile section that allowed you to change the post code? You could just nick the input box and code that you already have to overwrite what is already written in the cookie?

Chuck S · March 16th, 2009, 10:20 AM

well why not make the cookies only viable to the browser session and then deleted

IN showcat.php

Code:

Content visible to verified customers only.

change to say this

Code:

Content visible to verified customers only.

jammy_basturd · March 16th, 2009, 10:26 AM

Thanks Chuck.

Chuck S · March 16th, 2009, 10:37 AM

have a good day

nasko · June 17th, 2009, 04:52 PM

Where i can find UK zip code data to import into the classified?

Chuck S · June 17th, 2009, 06:57 PM

I cant say you would need to search for a database that contains the specific information like city lat lon zipcode etc and no doubt you would probally need to rework the rows to be compatible with the zipcode table format in our table.

hIBEES · June 18th, 2009, 02:11 PM

what is this for?

Is this for when users buy products?

I'm UK so would prob need to do this? if so!

Chuck S · June 18th, 2009, 02:16 PM

It is to show distance from say a perspective buyer.

hIBEES · June 18th, 2009, 02:38 PM

Quote:

Originally Posted by Chuck S

It is to show distance from say a perspective buyer.

ah for possible postage costs, think i'll let users decide there p & p price,

thanks

Chuck S · June 18th, 2009, 04:16 PM

Distance just for distance sake.