Full Country list

12 replies [Last post]

Mon, 08/13/2007 - 09:06

arbel

Offline

Joined: 08/12/2007

Juice: 331

Hello,

I've been looking around and I can't find a full country list for the shopping cart.

Is there something like this? I just need to user to be able to input his address, out of all the available countries.

I'm sure i'm just missing something...

Thanks.

Idan

Mon, 08/13/2007 - 09:50

#1 View page

Ryan

Offline

Joined: 08/07/2007

Juice: 15438

Re: Full Country list

Not missing anything... it was actually lost in the crash we had recently. I had planned to work through this with daniel I believe, but I haven't seen him since we've come back online. I found his thread and will repost it, but we'll need him to come supply us with the download again.

In the meantime, here's another thread that you might find interesting... You'll want to read the whole thing b/c it includes some fixes. I've attached the download from boogiebug at the bottom:

---------------

SQL for all Country Code / Zone Code
Submitted by boogiebug on Sun, 03/25/2007 - 22:54
boogiebug
Posts: 1
Joined: 03/25/2007

This is the SQL code for (hopefully) all zones and countries. It was converted from OSCommerce contribution to match the Ubercart's table structure. However, I've not yet run any extensive testing on this. Please use it as your own risk.

---------------

Mon, 03/26/2007 - 08:31
zmove
Posts: 31
Joined: 03/23/2007

Yeah, this is a very good thing.

I hope It will be integrated in the next version of ubercart !

I verify your sql for the country that I know (france for me) and it's correct. I already work with oscommerce and all table seems good.

thanks !

---------------

Tue, 05/29/2007 - 18:42
Boletus
Posts: 14
Joined: 05/29/2007

Perhaps nobody care, but this is a correct list (without umlauts)

#Sweden
INSERT INTO uc_zones VALUES ('',203,'BL','Blekinge');
INSERT INTO uc_zones VALUES ('',203,'DA','Dalarna');
INSERT INTO uc_zones VALUES ('',203,'GA','Gavleborg');
INSERT INTO uc_zones VALUES ('',203,'GO','Gotland');
INSERT INTO uc_zones VALUES ('',203,'HA','Halland');
INSERT INTO uc_zones VALUES ('',203,'JA','Jamtland');
INSERT INTO uc_zones VALUES ('',203,'JO','Jonkoping');
INSERT INTO uc_zones VALUES ('',203,'KA','Kalmar');
INSERT INTO uc_zones VALUES ('',203,'KR','Kronoberg');
INSERT INTO uc_zones VALUES ('',203,'NO','Norrbotten');
INSERT INTO uc_zones VALUES ('',203,'OR','Orebro');
INSERT INTO uc_zones VALUES ('',203,'OG','Ostergotland');
INSERT INTO uc_zones VALUES ('',203,'SK','Skane');
INSERT INTO uc_zones VALUES ('',203,'SO','Sodermanland');
INSERT INTO uc_zones VALUES ('',203,'ST','Stockholm');
INSERT INTO uc_zones VALUES ('',203,'UP','Uppsala');
INSERT INTO uc_zones VALUES ('',203,'VL','Varmland');
INSERT INTO uc_zones VALUES ('',203,'VB','Vasterbotten');
INSERT INTO uc_zones VALUES ('',203,'VN','Vasternorrland');
INSERT INTO uc_zones VALUES ('',203,'VM','Vastmanland');
INSERT INTO uc_zones VALUES ('',203,'VG','Vastra Gotaland');

---------------

Tue, 05/29/2007 - 18:54
druru
Posts: 220
Joined: 03/21/2007

sort of an outside question/curiosity:

anybody have a city db that can be linked back to the zones for each US state?

thanks

---------------

Thu, 05/31/2007 - 13:09
keesje76
Posts: 22
Joined: 04/21/2007

Thanks a lot for your SQL code.

I used it for my project.

I had to change two things:

I had to rename in table 'uc_countries' column 'address_format_id' to 'version', or else you will get error messages like:
user warning: Unknown column 'version' in 'where clause' query: SELECT * FROM uc_countries WHERE version > 0 ORDER BY country_name in /location/www/www.domain.com/includes/database.mysql.inc on line 172.
I changed the value of the renamed column 'version' to 1 to enable all countries. This might be optional.

Regards,

Kees

Web enabled applications and e-commerce

---------------

Mon, 06/11/2007 - 09:36
diegohermes
Posts: 8
Joined: 05/18/2007

I just check the brazilian codes and they are all correct.

Mon, 08/13/2007 - 11:28

#2 View page

arbel

Offline

Joined: 08/12/2007

Juice: 331

Re: Re: Full Country list

Thanks for the post...hmm...is there anything I can do to help with this and get it up asap...i'm a very novice coder...

Didn't quite understand the world_zones.txt...

Idan

Mon, 08/13/2007 - 11:33

#3 View page

arbel

Offline

Joined: 08/12/2007

Juice: 331

Re: Re: Re: Full Country list

Ok...I found that thread on google....and tried to download the cached file...and got what you got which is the error message and not the file...need to track it down, or find a website that has a full country list and export the sql...

Mon, 08/13/2007 - 11:59

#4 View page

Ryan

Offline

Joined: 08/07/2007

Juice: 15438

Re: Re: Re: Re: Full Country list

lol Apparently our world zones file got overwritten into an e-mail... sorry. I guess I'll have to take that down.

Mon, 08/13/2007 - 13:07

#5 View page

arbel

Offline

Joined: 08/12/2007

Juice: 331

Re: Re: Re: Re: Re: Full Country list

any idea where we can locate another copy?

Fri, 08/17/2007 - 05:22

#6 View page

arbel

Offline

Joined: 08/12/2007

Juice: 331

Hello, If anyone has or

Hello,

If anyone has or knows anyone that might have the country list, I would really appreciate it.

I'm in urgent need of that list.

Idan

Sat, 08/18/2007 - 02:39

#7 View page

qrios

Offline

Joined: 08/13/2007

Juice: 554

Look closer or search...

I guess I make some people happy,

Here it is: http://www.ubercart.org/forum/internationalization/347/country_and_zone_...

Regards

Website Nijkerk, Webshop, Ideal

Sat, 08/18/2007 - 04:17

#8 View page

arbel

Offline

Joined: 08/12/2007

Juice: 331

Re: Look closer or search...

Thank You!

Sat, 08/18/2007 - 05:53

#9 View page

megg

Offline

Joined: 08/08/2007

Juice: 248

Re: Re: Look closer or search...

i think you can make me happy, too! can anyone make me even happier by telling me what i should do with world_zones.txt once i have downloaded it?

Sat, 08/18/2007 - 08:40

#10 View page

michels

Offline

Joined: 08/12/2007

Juice: 205

It's a SQL-File.. Truncate

It's a SQL-File..

Truncate the MYSQL tables: uc_zones and uc_countries
Then import the attached file (run as SQL code in f.e. phpMyadmin)

Legal aspects pane for european shops
AGB und Widerrufsrecht im Bestellprozess einblenden

Sat, 08/18/2007 - 12:51

#11 View page

megg

Offline

Joined: 08/08/2007

Juice: 248

Re: It's a SQL-File.. Truncate

sweet, thanks! learned something new today _and_ can cross another thing off my list.

Mon, 02/07/2011 - 10:06

#12 View page

chrisM79

Offline

Joined: 02/07/2011

Juice: 3

Wrong data

Thanks for the file, just a little commnet on the date in the file:

Bulgaria zone_codes are empty and
Republic of Congo and Congo are having same country code where actually they should be different.

COD Congo, the Democratic Republic of the
COG Congo

And Bulgaria should be:

479 33 BL Blagoevgrad
480 33 BS Burgas
481 33 TX Dobrich

As in:http://www.ubercart.org/forum/internationalization/17986/bulgarian_zones (google translated for non utf8
482 33 GA Gabrovo
483 33 HA Haskovo
484 33 KI Kardjali
485 33 KD Kyustendil
486 33 LV Lovech
487 33 MO Montana
488 33 PA Pazardjik
489 33 PK Pernik
490 33 PE Pleven
491 33 PV Plovdiv
492 33 RR Razgrad
493 33 SH Shumen
494 33 SS Silistra
495 33 SN Sliven
496 33 SM Smolyan
497 33 SO Sofia
498 33 SA Sofia - town
499 33 ST Stara Zagora
500 33 TA Targovishte
501 33 VN Varna
502 33 VT Veliko Tarnovo
503 33 VD Vidin
504 33 VA Vratza
505 33 YA Yambol

	User login
	Log in using OpenID: What is OpenID? Username or e-mail: * Password: * Remember me Log in using OpenID Cancel OpenID login Create new account Request new password

Ubercart

Navigation

User login