Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0001109Openbravo ERPZ. Otherspublic2007-04-03 21:142008-12-08 18:11
plujan 
rafaroda 
highminoralways
closedfixed 
5
 
2.50pi 
Core
No
0001109: Data Quality issue on Country Lists
This is a common issue about Data Quality. It is not a bug, but it should be considered for fixing anyway.

Steps to reproduce the behavior:
1. Go "General Rules" -> "Data" -> "Utility"
2. Click on "Location"
3. Look at the Country field contents.
3.1. In Spanish translation almost all countries has English names. "Croatia" instead of "Croacia", "Greece" instead of "Grecia", and so on. "España" and "Francia" are correct.
3.2. In English translation the list is the same, so almost all countries are correct, but "Spain" is "España" and "France" is "Francia".
3.3. Trivia question: what is a country? I meant, that list is a correct country list? May be Antarctica should not be considered as a country. And there are some missings, like Serbia and Montenegro (formerly "Serbia and Montenegro", now "Serbia" and "Montenegro", two separate coutries)
No tags attached.
related to defect 0032956 new Triage Omni OMS Include Kosovo as country in the dataset 
related to defect 0037141 closed markmm82 Missed country: Isle of Man 
Issue History
2008-06-13 19:31cromeroAssigned Topsarobe => dalsasua
2008-06-13 19:31cromeroPrioritynormal => high
2008-06-13 19:31cromeroStatusnew => scheduled
2008-06-13 19:31cromeroTarget Version => 2.50
2008-06-13 19:31cromeroDescription Updated
2008-06-25 10:15pjuvaraAssigned Todalsasua => rafaroda
2008-07-15 12:06rafarodaNote Added: 0008293
2008-07-15 17:09rafarodaNote Added: 0008299
2008-07-15 17:19svnbotCheckin
2008-07-15 17:19svnbotNote Added: 0008300
2008-07-15 17:19svnbotStatusscheduled => resolved
2008-07-15 17:19svnbotResolutionopen => fixed
2008-07-15 17:19svnbotsvn_revision => 5857
2008-12-08 18:11psarobeRegression testing => No
2008-12-08 18:11psarobeStatusresolved => closed
2016-05-13 14:27plujanRelationship addedrelated to 0032956
2017-10-31 14:43plujanRelationship addedrelated to 0037141

Notes
(0004698)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1693846 [^]
(0000955)
cromero   
2007-04-12 13:27   
(edited on: 2008-06-12 09:18)
Logged In: YES
user_id=1500614
Originator: NO

This bug should be fixed.
I assign this bug to our QA department.
Thank you for your feedback.
Carlos Romero
Openbravo Team
(0000956)
user71   
2007-06-19 14:41   
(edited on: 2008-06-12 09:18)
Logged In: YES
user_id=1493353
Originator: NO

You can find an official ISO_3166 list of countries at:
In English: http://www.iso.org/iso/en/prods-services/iso3166ma/02iso-3166-code-lists/list-en1.html [^]
In Spanish: http://es.wikipedia.org/wiki/ISO_3166-1 [^]
(0008293)
rafaroda   
2008-07-15 12:06   
3.1. In Spanish translation almost all countries has English names. "Croatia" instead of "Croacia", "Greece" instead of "Grecia", and so on. "España" and "Francia" are correct.

This has been fixed in https://dev.openbravo.com/websvn/localization/translations/es_ES/trunk/?rev=116&sc=1 [^]
(0008299)
rafaroda   
2008-07-15 17:09   
3.3. And there are some missings, like Serbia and Montenegro (formerly "Serbia and Montenegro", now "Serbia" and "Montenegro", two separate coutries)

This has been fixed in https://issues.openbravo.com/view.php?id=2236 [^]
(0008300)
svnbot   
2008-07-15 17:19   
Repository: openbravo
Revision: 5857
Author: rafaroda
Date: 2008-07-15 17:19:25 +0200 (Tue, 15 Jul 2008)

Fixes bug 0001109 Translated some countries from Spanish to English and added descriptions to some others.

---
U trunk/src-db/database/masterdata/C_COUNTRY.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=5857&sc=1 [^]