Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.

For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email community@magento.com.

Magento Forum

Provincies België & Nederland
 
Dieter21
Member
 
Avatar
Total Posts:  51
Joined:  2008-03-29
Belgium
 

Hieronder de SQL Queries die ik gebruikt heb om de provincies voor België en Nederland in te voeren in de database:

INSERT INTO `magento`.`directory_country_regionVALUES 
(NULL 'BE''ANTW''Antwerpen'),
(
NULL 'BE''OVLA''Oost-Vlaanderen'),
(
NULL 'BE''VLAB''Vlaams-Brabant'),
(
NULL 'BE''WVLA''West-Vlaanderen'),
(
NULL 'BE''WAAB''Waals-Brabant'),
(
NULL 'BE''HENE''Henegouwen'),
(
NULL 'BE''LUIK''Luik'),
(
NULL 'BE''LUXB''Luxemburg'),
(
NULL 'BE''NAMN''Namen'),
(
NULL 'BE''LIMB''Limburg');

INSERT INTO `magento`.`directory_country_region_name` (`locale` ,`region_id` ,`name` ) SELECT 'nl_NL'tmp.region_idtmp.default_name FROM `magento`.`directory_country_region` AS tmp WHERE tmp.country_id='BE';

INSERT INTO `magento`.`directory_country_regionVALUES 
(NULL 'NL''GRON''Groningen'),
(
NULL 'NL''FRIE''Friesland'),
(
NULL 'NL''DREN''Drenthe'),
(
NULL 'NL''OVER''Overijssel'),
(
NULL 'NL''FLEV''Flevoland'),
(
NULL 'NL''GELD''Gelderland'),
(
NULL 'NL''UTRE''Utrecht'),
(
NULL 'NL''NHOL''Noord-Holland'),
(
NULL 'NL''ZHOL''Zuid-Holland'),
(
NULL 'NL''ZEEL''Zeeland'),
(
NULL 'NL''NBRA''Noord-Brabant'),
(
NULL 'NL''LIMB''Limburg');

INSERT INTO `magento`.`directory_country_region_name` (`locale` ,`region_id` ,`name` ) SELECT 'nl_NL'tmp.region_idtmp.default_name FROM `magento`.`directory_country_region` AS tmp WHERE tmp.country_id='NL';
 
Magento Community Magento Community
Magento Community
Magento Community
 
Patsjoelie
Jr. Member
 
Total Posts:  5
Joined:  2008-08-07
 

Bedankt voor de info!
Werkt perfect! smile

 
Magento Community Magento Community
Magento Community
Magento Community
Magento Community
Magento Community
Back to top