Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0023209Openbravo ERPJ. Demo datapublic2013-03-01 14:312013-05-10 11:54
jonalegriaesarte 
jecharri 
normalminorhave not tried
closedfixed 
5
pi 
3.0MP233.0MP23 
jonalegriaesarte
Core
No
0023209: Incorrect State Name loaded in the Region table plus Canada should also include abbreviation values
1) The default data provided for Country=US has an incorrect Region Description.
Region AK currently says Arkansas (which is also AR) but should be Alaska

2) The default data provided for Country=Canada should use the standard abbreviations
for the Region Name.
Currently the region name and description are full length values, though the
descriptions are in french (should be handled via translation)
The standard two character provinces for canada are available at
http://www.canadapost.ca/tools/pg/manual/PGaddress-e.asp#1382088 [^]

3) To be consistent with other master data in openbravo, we believe the search key
which is currently blank should contain the standard abbreviation value and the name
should contain the standard name. description would then be optional.
- Access to Openbravo
- Region and country window
No tags attached.
Issue History
2013-03-01 14:31jonalegriaesarteNew Issue
2013-03-01 14:31jonalegriaesarteAssigned To => jonalegriaesarte
2013-03-01 14:31jonalegriaesarteModules => Core
2013-03-01 14:31jonalegriaesarteTriggers an Emergency Pack => No
2013-03-04 11:05jonalegriaesarteTarget Version3.0MP21 => 3.0MP23
2013-04-18 10:13jonalegriaesarteAssigned Tojonalegriaesarte => jecharri
2013-04-30 12:00hgbotCheckin
2013-04-30 12:00hgbotNote Added: 0058339
2013-04-30 12:00hgbotStatusnew => resolved
2013-04-30 12:00hgbotResolutionopen => fixed
2013-04-30 12:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/235fc11e60abd9d8dc5077440d044ff7711aabcc [^]
2013-04-30 12:03jecharriNote Added: 0058340
2013-04-30 21:05hudsonbotCheckin
2013-04-30 21:05hudsonbotNote Added: 0058392
2013-05-10 11:54jonalegriaesarteReview Assigned To => jonalegriaesarte
2013-05-10 11:54jonalegriaesarteNote Added: 0058542
2013-05-10 11:54jonalegriaesarteStatusresolved => closed
2013-05-10 11:54jonalegriaesarteFixed in Version => 3.0MP23

Notes
(0058339)
hgbot   
2013-04-30 12:00   
Repository: erp/devel/pi
Changeset: 235fc11e60abd9d8dc5077440d044ff7711aabcc
Author: Javier Etxarri <javier.echarri <at> openbravo.com>
Date: Tue Apr 30 11:59:49 2013 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/235fc11e60abd9d8dc5077440d044ff7711aabcc [^]

Fixes issue 23209: Incorrect State Name loaded in the Region
table plus Canada should also include abbreviation values

---
M src-db/database/sourcedata/referencedData/C_REGION.xml
---
(0058340)
jecharri   
2013-04-30 12:03   
It will be necessary to execute command "ant install.source" to apply the solution or start working in MP23
(0058392)
hudsonbot   
2013-04-30 21:05   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/3ea22ca7a348 [^]

Maturity status: Test
(0058542)
jonalegriaesarte   
2013-05-10 11:54   
Verified