Belgium states

mongolito404 - December 11, 2007 - 20:16
Project:CCK Address Extensions
Version:5.x-1.x-dev
Component:Belgium-Code
Category:bug report
Priority:normal
Assigned:Unassigned
Status:needs work
Description

In Belgium, the general consensus seems to use the provinces of Belgium for the state field. There is 10 provinces in Belgium: Antwerpen, Limburg, Vlaams Brabant, Oost-Vlaanderen, West-Vlaanderen, Hainaut, Brabant wallon, Namur, Liège and Luxembourg. The Brussels-Capital Region is not part of any province but not a province itself and generaly used as value for the state field (named "Brussels" or "Brussels-Capital").

This is not the what is currently done in the current version of the Belgium cck_address extension.

I attached a modified cck_address_belgium.module that use this list.

AttachmentSize
cck_address_belgium.module5.19 KB

#1

rconstantine - December 12, 2007 - 05:22

I didn't write the original Belgium module, so could you tell me how it IS organized? Also, did you write this from scratch, or did you modify the existing module?

#2

mongolito404 - December 12, 2007 - 13:58

I don't understand the rational behind the original states list in belgium.module. It has the following "states": Antwerpen, Limburg, Vlaams-Brabant/Brussel, Waals-Brabant, Oost-Vlaanderen, West-Vlaanderen, Luik, Luxemburg' and Namen. It looks like an incomplete list of provinces with a wrong aggregation of Brussel in the Vlaams Brabant and all names in Dutch.

I modified the original Belgium module and only the cck_address_belgium_installstates() function.

If needed I could provide a diff or patch file, but it's only a simple single block change.

#3

rconstantine - December 12, 2007 - 17:27

OK. I'll check out your code and do a little research on Belgium myself. Meanwhile, could you go through the issues in the parent module (cck_address) and find the guy that posted the original Belgium module and contact him to find out why he did what he did? Thanks. I hope you can understand my caution with such a change when I don't really know the country or the data. Also, any links to relevant data for me to look at would be helpful.

#4

mongolito404 - December 13, 2007 - 12:23

The more usable reference I know is the Wikipedia entry in the topic of Belgium subdivision: http://en.wikipedia.org/wiki/Communities_and_regions_of_Belgium#Country_... Off course, you could also look at it's footnote for more official (but less comprehensible) information.

#5

rconstantine - December 17, 2007 - 21:19
Status:active» needs work

OK. I went to Belgium's post office web site and found the attached file. Note that you need to make sure it has an xls extension. Each tab/page is for a 'province' that the post office recognizes. You'll have to scroll to the tops of the pages as they weren't all saved that way.

Anyway, what I'd like you to do is compare what is in this file with what you gave me. I understand that the file I've attached are the French names, so if you need to change them into the most common language, or if you'd like to provide copies in all three official languages, that's fine. Please list for me in your next post the provinces as found in the attached document followed by what your solution is for the module.

For example, (using countries instead of provinces):

Espania -> Spain
France -> France

So some might be the same, some might change, whatever you think is best. Then if I understand the changes you've made, I'll add the change (once CVS is cleaned up. See a post elsewhere in this queue about that).

If you want to do all three languages do this for me:

Province -> Lang1 version, Lang2 version, Lang3 version

for each one, then add them as separate entries to the database-filler function.

Make sense? Seem reasonable?

AttachmentSize
provinces_fr_04.xls.txt 374.5 KB

#6

mongolito404 - January 6, 2008 - 09:05

Ok, I will try to find some time to do it.

The list I submitted is in English (from Wikipedia).

#7

mongolito404 - July 19, 2008 - 13:23

Finally, here is the list with the 10 Belgian provinces and the Brussel-Capital Region in English, French, Dutch and German (the three official languages of the country).

The best is probably to use the English names.

AttachmentSize
BelgiumStates.xls 111.5 KB
 
 

Drupal is a registered trademark of Dries Buytaert.