zipcode question

dknelson · June 27th, 2010, 07:01 AM

I'm trying to add the Canadian postal codes to my installation also. I downloaded the file form the link above and I think have it about ready. Not sure about the zipcodetype field though. What would go there or can it be blank?

Chuck S · June 27th, 2010, 11:01 AM

well for the purpose of our program the zipcode lat and lon fields are the ones needed.

dknelson · June 27th, 2010, 11:11 AM

Thanks...this program is the only one I'm concerned with. It should work then.

Chuck S · June 27th, 2010, 11:12 AM

yes the other is erroneous data as far as our program is concerned

we use lon and lat and zipcode for the distance calculations.

dknelson · June 27th, 2010, 11:46 AM

Well heck...I thought for sure I had it. Import went fine and the data appears to be in the table. I then tried placing a test ad though. Seemed to work OK but then when I view the ads, it says "no zip code" beside the test ad. When I edit the ad, it shows the zip code but does not appear to be recognizing it. I'm attaching a screen shot of just a small section of the zip data table. Any suggestions?

Chuck S · June 27th, 2010, 01:27 PM

Looks fine to me

So you edit the ad the zipcode field is filled in in the products table?

I cant really respond without a url and login

You can also

dknelson · June 27th, 2010, 03:36 PM

Yes, if I edit the ad, the zipcode field is still filled in but it still shows "no zip code" in the product listing.

The URL is:
Main Index - VentureRider Classifieds

I tried to send you a login and password but you aren't accepting PMs. Let me know where to send it and I'll be happy to do so.

Chuck S · June 27th, 2010, 04:23 PM

1985 VENTURE ROYALE - VentureRider Classifieds

where is a specific ad you have put the zipcode on?

dknelson · June 27th, 2010, 04:39 PM

Sorry about that. Here it is:

http://www.venturerider.org/classifi...p?product=2927

Zip code entered is: L6K1M

Is says no zip code though.

Chuck S · June 27th, 2010, 06:29 PM

Your saying if you hit edit ad it has a zipcode there right

HMM

Has to be something with your canadian info something is not calculating correctly

dknelson · June 27th, 2010, 07:15 PM

Yes, if I hit edit the zip code is in the zip code field. You must be right. The data came from the link posted in this thread but maybe it's incorrect. I don't see anything wrong with it but heck if I know.

dknelson · June 27th, 2010, 07:19 PM

OK...I think I have found it. It appears that all the Lon and Lat values are switched.

dknelson · June 27th, 2010, 07:52 PM

Well...they were switched but it's still doing the same thing. Oh well...I'll work on it some more tomorrow.

Badger · June 28th, 2010, 06:44 AM

Quote:

Originally Posted by dknelson

I'm trying to add the Canadian postal codes to my installation also. I downloaded the file form the link above and I think have it about ready.

Hi ..

Our site is in Canada and we'd like to use the ZIP CODE field for both Canada and the U.S.

Where did you find the file you mentioned?

If you get this working, we'd appreciate any feedback on how you did that.

Thanks for any advice ..

Regards,
Doug

dknelson · June 28th, 2010, 07:28 AM

Not a problem. I will be happy to share but so far, I haven't got it working. I'm traveling today but hopefully will take another look at it tonight.

Chuck S · June 28th, 2010, 10:53 AM

yeah your lat and lon has to be correct as if the calculations are not right then there is an issue.

dknelson · June 28th, 2010, 04:06 PM

OK...here is the problem. The LON and LAT values were switched. I got that corrected but then still had the same problem.

Then I found out what is causing this. The Canadian postal codes are 6 characters. The classifieds only allows 5 characters. When I enter the 6 character code, the classifieds software truncates it and deletes the last character. I changed one of the Canadian codes to a 5 character code by simply deleting the final character and then it works correctly. Mileage was displayed in the listing. The database field IS a 6 character string.

So my question is WHERE to I change the Classifieds software so that it allows 6 characters for the postal code. I found values of 5 for zipcode length in the uploadproduct template and the editproduct templates. I changed both of those to 6 but it is still changing it to 5 characters when I submit an ad. So where do I change it?

Chuck S · June 28th, 2010, 04:10 PM

well in mysql in the zipcode field in the products table change the field to 6 characters not 5 and you should be okay.

dknelson · June 28th, 2010, 04:42 PM

I hate to keep asking dumb questions but I'm not finding a products table. The only field I've found for zipcode is classified_addresses and that field is set at 15.

I did find a zipcode string set to 5 in adproducts. Changed it to 6 but still getting truncated to 5 when I submit the ad.

Chuck S · June 28th, 2010, 08:08 PM

we dont have a table called addresses

If you change the field to varchar 10 in the cp_products table you should then be able to upload an ad and keep it save I just tried it.

http://www.reeftalk.com/classifieds/

check out the ad with the clouds