France, Metropolitan listed as Country in Geo table

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
8 messages Options
Reply | Threaded
Open this post in threaded view
|

France, Metropolitan listed as Country in Geo table

Scott Gray-2
Can anyone who knows anything about France explain why the following is listed as a Country in our Geo table:
geoId: FXX
geoTypeId: COUNTRY
geoName: France, Metropolitan
geoCode: FX
geoSecCode: 249
abbreviation: FXX

Is this a typo and it should actually be using the COUNTY geoTypeId?  I don't see this listed in the ISO table: http://www.iso.org/iso/english_country_names_and_code_elements

Thanks
Scott

HotWax Media
http://www.hotwaxmedia.com


smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: France, Metropolitan listed as Country in Geo table

Jacques Le Roux
Administrator
http://en.wikipedia.org/wiki/ISO_3166-1_alpha-3#Exceptional_reservations

Jacques

From: "Scott Gray" <[hidden email]>
Can anyone who knows anything about France explain why the following is listed as a Country in our Geo table:
geoId: FXX
geoTypeId: COUNTRY
geoName: France, Metropolitan
geoCode: FX
geoSecCode: 249
abbreviation: FXX

Is this a typo and it should actually be using the COUNTY geoTypeId?  I don't see this listed in the ISO table:
http://www.iso.org/iso/english_country_names_and_code_elements

Thanks
Scott

HotWax Media
http://www.hotwaxmedia.com



Reply | Threaded
Open this post in threaded view
|

Re: France, Metropolitan listed as Country in Geo table

Scott Gray-2
That means it's a reserved code, not that it is in active use.  Specifically I've had shipping APIs reject it as an invalid country code meaning I have to either remove it or change the codes to match France.  Does it really serve any useful purpose in any real world situation?

Thanks
Scott

On 5/06/2010, at 4:59 PM, Jacques Le Roux wrote:

> http://en.wikipedia.org/wiki/ISO_3166-1_alpha-3#Exceptional_reservations
>
> Jacques
>
> From: "Scott Gray" <[hidden email]>
> Can anyone who knows anything about France explain why the following is listed as a Country in our Geo table:
> geoId: FXX
> geoTypeId: COUNTRY
> geoName: France, Metropolitan
> geoCode: FX
> geoSecCode: 249
> abbreviation: FXX
>
> Is this a typo and it should actually be using the COUNTY geoTypeId?  I don't see this listed in the ISO table: http://www.iso.org/iso/english_country_names_and_code_elements
>
> Thanks
> Scott
>
> HotWax Media
> http://www.hotwaxmedia.com
>
>
>


smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: France, Metropolitan listed as Country in Geo table

Jacques Le Roux
Administrator
It was there since I began to work with OFBiz. It might be useful for shipping. When you want to distinguish some external
territories (called DOM in French). DOM are parts of France, but not metropolitan.
http://en.wikipedia.org/wiki/Overseas_department. It's a moving target...

Jacques

Scott Gray wrote:

> That means it's a reserved code, not that it is in active use.  Specifically I've had shipping APIs reject it as an invalid
> country code meaning I have to either remove it or change the codes to match France.  Does it really serve any useful purpose in
> any real world situation?
>
> Thanks
> Scott
>
> On 5/06/2010, at 4:59 PM, Jacques Le Roux wrote:
>
>> http://en.wikipedia.org/wiki/ISO_3166-1_alpha-3#Exceptional_reservations
>>
>> Jacques
>>
>> From: "Scott Gray" <[hidden email]>
>> Can anyone who knows anything about France explain why the following is listed as a Country in our Geo table:
>> geoId: FXX
>> geoTypeId: COUNTRY
>> geoName: France, Metropolitan
>> geoCode: FX
>> geoSecCode: 249
>> abbreviation: FXX
>>
>> Is this a typo and it should actually be using the COUNTY geoTypeId?  I don't see this listed in the ISO table:
>> http://www.iso.org/iso/english_country_names_and_code_elements
>>
>> Thanks
>> Scott
>>
>> HotWax Media
>> http://www.hotwaxmedia.com 


Reply | Threaded
Open this post in threaded view
|

Re: France, Metropolitan listed as Country in Geo table

Scott Gray-2
Like I mentioned it made shipping more difficult for me.  I don't think there is really any issue in regards to confusing one of the overseas departments with Continental France because each of the overseas departments have their own country codes:
France (FR)
Martinique (MQ)
Guadeloupe (GP)
Réunion (RE)
French Guiana (GF)

With the above list there is really no room for confusion.  The confusion comes in when we start using FX when it isn't on the official ISO 3166 list.  FX is the only 'country' we have in OFBiz that isn't on that list.

Regards
Scott

On 5/06/2010, at 8:09 PM, Jacques Le Roux wrote:

> It was there since I began to work with OFBiz. It might be useful for shipping. When you want to distinguish some external territories (called DOM in French). DOM are parts of France, but not metropolitan.
> http://en.wikipedia.org/wiki/Overseas_department. It's a moving target...
>
> Jacques
>
> Scott Gray wrote:
>> That means it's a reserved code, not that it is in active use.  Specifically I've had shipping APIs reject it as an invalid
>> country code meaning I have to either remove it or change the codes to match France.  Does it really serve any useful purpose in
>> any real world situation?
>>
>> Thanks
>> Scott
>>
>> On 5/06/2010, at 4:59 PM, Jacques Le Roux wrote:
>>
>>> http://en.wikipedia.org/wiki/ISO_3166-1_alpha-3#Exceptional_reservations
>>>
>>> Jacques
>>>
>>> From: "Scott Gray" <[hidden email]>
>>> Can anyone who knows anything about France explain why the following is listed as a Country in our Geo table:
>>> geoId: FXX
>>> geoTypeId: COUNTRY
>>> geoName: France, Metropolitan
>>> geoCode: FX
>>> geoSecCode: 249
>>> abbreviation: FXX
>>>
>>> Is this a typo and it should actually be using the COUNTY geoTypeId?  I don't see this listed in the ISO table:
>>> http://www.iso.org/iso/english_country_names_and_code_elements
>>>
>>> Thanks
>>> Scott
>>>
>>> HotWax Media
>>> http://www.hotwaxmedia.com 
>
>


smime.p7s (3K) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: France, Metropolitan listed as Country in Geo table

Jacques Le Roux
Administrator
Then we can remove it, at least it's my opinion.
Neogia team?

Jacques

Scott Gray wrote:

> Like I mentioned it made shipping more difficult for me.  I don't think there is really any issue in regards to confusing one of
> the overseas departments with Continental France because each of the overseas departments have their own country codes:
> France (FR)
> Martinique (MQ)
> Guadeloupe (GP)
> Réunion (RE)
> French Guiana (GF)
>
> With the above list there is really no room for confusion.  The confusion comes in when we start using FX when it isn't on the
> official ISO 3166 list.  FX is the only 'country' we have in OFBiz that isn't on that list.
>
> Regards
> Scott
>
> On 5/06/2010, at 8:09 PM, Jacques Le Roux wrote:
>
>> It was there since I began to work with OFBiz. It might be useful for shipping. When you want to distinguish some external
>> territories (called DOM in French). DOM are parts of France, but not metropolitan.
>> http://en.wikipedia.org/wiki/Overseas_department. It's a moving target...
>>
>> Jacques
>>
>> Scott Gray wrote:
>>> That means it's a reserved code, not that it is in active use.  Specifically I've had shipping APIs reject it as an invalid
>>> country code meaning I have to either remove it or change the codes to match France.  Does it really serve any useful purpose in
>>> any real world situation?
>>>
>>> Thanks
>>> Scott
>>>
>>> On 5/06/2010, at 4:59 PM, Jacques Le Roux wrote:
>>>
>>>> http://en.wikipedia.org/wiki/ISO_3166-1_alpha-3#Exceptional_reservations
>>>>
>>>> Jacques
>>>>
>>>> From: "Scott Gray" <[hidden email]>
>>>> Can anyone who knows anything about France explain why the following is listed as a Country in our Geo table:
>>>> geoId: FXX
>>>> geoTypeId: COUNTRY
>>>> geoName: France, Metropolitan
>>>> geoCode: FX
>>>> geoSecCode: 249
>>>> abbreviation: FXX
>>>>
>>>> Is this a typo and it should actually be using the COUNTY geoTypeId?  I don't see this listed in the ISO table:
>>>> http://www.iso.org/iso/english_country_names_and_code_elements
>>>>
>>>> Thanks
>>>> Scott
>>>>
>>>> HotWax Media
>>>> http://www.hotwaxmedia.com 


Reply | Threaded
Open this post in threaded view
|

Re: France, Metropolitan listed as Country in Geo table

Erwan de FERRIERES
Le 05/06/2010 11:16, Jacques Le Roux a écrit :
> Then we can remove it, at least it's my opinion.
> Neogia team?
>
Please do as you want ! and Scott, while you're at it, have some updates
for lucene ?

> Jacques


--
Erwan de FERRIERES
www.nereide.biz
Reply | Threaded
Open this post in threaded view
|

Re: France, Metropolitan listed as Country in Geo table

Scott Gray-2
Thanks Erwan and Jacques for your opinions.

Erwan, no I'm sorry but I haven't had any time to work on Lucene since we discussed it last.  Ultimately I would like to see an OFBiz version of Hibernate Search but I'm afraid I just don't have any time to work on it at the moment.

Regards
Scott

HotWax Media
http://www.hotwaxmedia.com

On 6/06/2010, at 9:08 AM, Erwan de FERRIERES wrote:

> Le 05/06/2010 11:16, Jacques Le Roux a écrit :
>> Then we can remove it, at least it's my opinion.
>> Neogia team?
>>
> Please do as you want ! and Scott, while you're at it, have some updates for lucene ?
>
>> Jacques
>
>
> --
> Erwan de FERRIERES
> www.nereide.biz


smime.p7s (3K) Download Attachment