EU country list to import?

[marksu]

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

[marksu]

Never mind I will reimport the original country list.

marksu

[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

[clydejones]

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());

[marksu]

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());