Forums / General Questions / EU country list to import?

EU country list to import?

Locked

Started by marksu on 19 Jan 2008, 7:29 PM · Views: 2,486

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
19 Jan 2008, 7:29 PM
#1
marksu avatar

marksu

Zen Follower

Join Date:
Nov 2007
Posts:
260
Plugin Contributions:
0

EU country list to import?

Anyone have the country list for EU only that can be imported to database?

Maybe somebody could export it from their database?

I know there are list on Internet but I need a file that can be used to import then all in once though import feature and not insert then one by one.

marksu

19 Jan 2008, 8:29 PM
#4
clydejones avatar

clydejones

Deceased

Join Date:
Nov 2005
Location:
Colorado Springs, CO USA
Posts:
7,017
Plugin Contributions:
12

Re: EU country list to import?

marksu:

On the otherhand:

It would be nice if I would not have to insert each single EU country under the one EU efinition one by one.

Anyone that can provide file to import to database?

marksu

copy and paste the following sql statement into:

admin -> tools -> install sql patches and click the send button

Note you may have to add newer EU members manually.

INSERT INTO `geo_zones` VALUES ('', 'Shp: European Union: All', 'Entire European Union', NULL, now());
INSERT INTO `zones_to_geo_zones` VALUES ('', 14, 0, last_insert_id(), NULL, now()),
                                        ('', 21, 0, last_insert_id(), NULL, now()),
                                        ('', 55, 0, last_insert_id(), NULL, now()),
                                        ('', 56, 0, last_insert_id(), NULL, now()),
                                        ('', 57, 0, last_insert_id(), NULL, now()),
                                        ('', 67, 0, last_insert_id(), NULL, now()),
                                        ('', 72, 0, last_insert_id(), NULL, now()),
                                        ('', 73, 0, last_insert_id(), NULL, now()),
                                        ('', 81, 0, last_insert_id(), NULL, now()),
                                        ('', 84, 0, last_insert_id(), NULL, now()),
                                        ('', 97, 0, last_insert_id(), NULL, now()),
                                        ('', 103, 0, last_insert_id(), NULL, now()),
                                        ('', 105, 0, last_insert_id(), NULL, now()),
                                        ('', 117, 0, last_insert_id(), NULL, now()),
                                        ('', 123, 0, last_insert_id(), NULL, now()),
                                        ('', 124, 0, last_insert_id(), NULL, now()),
                                        ('', 132, 0, last_insert_id(), NULL, now()),
                                        ('', 170, 0, last_insert_id(), NULL, now()),
                                        ('', 171, 0, last_insert_id(), NULL, now()),
                                        ('', 189, 0, last_insert_id(), NULL, now()),
                                        ('', 190, 0, last_insert_id(), NULL, now()),
                                        ('', 195, 0, last_insert_id(), NULL, now()),
                                        ('', 203, 0, last_insert_id(), NULL, now()),
                                        ('', 150, 0, last_insert_id(), NULL, now()),
                                        ('', 222, 0, last_insert_id(), NULL, now());

NOTE: We are sorry that Clyde is no longer with us.
We are grateful for all his contributions to the Zen Cart community.

19 Jan 2008, 10:07 PM
#5
marksu avatar

marksu

Zen Follower

Join Date:
Nov 2007
Posts:
260
Plugin Contributions:
0

Re: EU country list to import?

Thank you for nice sql code and fast reply.
It was missing Bulgaria (33) and Romania (175) which I added to the list.

I used following urls to check EU country list status
http://europa.eu/abc/european_countries/index_en.htm
http://www.userfocus.co.uk/us/eu.html

INSERT INTO zones_to_geo_zones VALUES ('', 14, 0, last_insert_id(), NULL, now()),
('', 21, 0, last_insert_id(), NULL, now()),
('', 33, 0, last_insert_id(), NULL, now()),
('', 55, 0, last_insert_id(), NULL, now()),
('', 56, 0, last_insert_id(), NULL, now()),
('', 57, 0, last_insert_id(), NULL, now()),
('', 67, 0, last_insert_id(), NULL, now()),
('', 72, 0, last_insert_id(), NULL, now()),
('', 73, 0, last_insert_id(), NULL, now()),
('', 81, 0, last_insert_id(), NULL, now()),
('', 84, 0, last_insert_id(), NULL, now()),
('', 97, 0, last_insert_id(), NULL, now()),
('', 103, 0, last_insert_id(), NULL, now()),
('', 105, 0, last_insert_id(), NULL, now()),
('', 117, 0, last_insert_id(), NULL, now()),
('', 123, 0, last_insert_id(), NULL, now()),
('', 124, 0, last_insert_id(), NULL, now()),
('', 132, 0, last_insert_id(), NULL, now()),
('', 170, 0, last_insert_id(), NULL, now()),
('', 171, 0, last_insert_id(), NULL, now()),
('', 175, 0, last_insert_id(), NULL, now()),
('', 189, 0, last_insert_id(), NULL, now()),
('', 190, 0, last_insert_id(), NULL, now()),
('', 195, 0, last_insert_id(), NULL, now()),
('', 203, 0, last_insert_id(), NULL, now()),
('', 150, 0, last_insert_id(), NULL, now()),
('', 222, 0, last_insert_id(), NULL, now());