Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0045763Openbravo ERP02. Master data managementpublic2021-01-20 11:152021-02-12 09:31
Reporterpsanjuan 
Assigned Tomarkmm82 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS VersionOpenbravo Appliance 14.04
Product Version 
Target VersionFixed in VersionPR21Q2 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0045763: New countries required "San Martín" and "Curaçao"
DescriptionNew countries required "San Martín" and "Curaçao"
Steps To Reproducen/a
Proposed SolutionTwo new countries are required

Country - Sint Maarten (parte meridional; antes Antillas Neerlandesas)
ISO Code - SX

original name = Sint Maarten (do not need to be translated into English)

Country - Curaçao (antes en Antillas Neerlandesas)
ISO Code - CW

original name = Curaçao

See https://es.wikipedia.org/wiki/Antillas_Neerlandesas [^]

Finally Antillas Neerlandesas country can be set to Active = NO
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0045815PR21Q1.1 closed markmm82 New countries required "San Martín" and "Curaçao"  
depends on backport 0045816PR20Q4.2 closed markmm82 New countries required "San Martín" and "Curaçao"  
depends on backport 0045817PR20Q3.4 closed markmm82 New countries required "San Martín" and "Curaçao"  
Attached Filespdf Codigo_paises.pdf (27,718) 2021-01-20 11:20
https://issues.openbravo.com/file_download.php?file_id=15268&type=bug
Issue History
Date ModifiedUsernameFieldChange
2021-01-20 11:15psanjuanNew Issue
2021-01-20 11:15psanjuanAssigned To => Triage Finance
2021-01-20 11:15psanjuanModules => Core
2021-01-20 11:15psanjuanTriggers an Emergency Pack => No
2021-01-20 11:20psanjuanFile Added: Codigo_paises.pdf
2021-01-20 11:28psanjuanProposed Solution updated
2021-01-20 11:29psanjuanSummaryNew country required "San Martín" - ISO Code : SX => New countries required "San Martín" and "Curaçao"
2021-01-20 11:29psanjuanDescription Updatedbug_revision_view_page.php?rev_id=22045#r22045
2021-01-20 11:35psanjuanProposed Solution updated
2021-01-21 16:45vmromanosAssigned ToTriage Finance => markmm82
2021-01-25 12:49markmm82Statusnew => scheduled
2021-01-26 12:35hgbotNote Added: 0125790
2021-01-27 09:36psanjuanNote Added: 0125795
2021-01-27 09:47psanjuanProposed Solution updated
2021-01-27 10:55psanjuanProposed Solution updated
2021-01-27 13:23hgbotNote Added: 0125802
2021-01-27 13:23hgbotNote Added: 0125803
2021-01-27 13:34markmm82Note Deleted: 0125802
2021-01-27 13:34markmm82Note Deleted: 0125790
2021-01-28 14:11hgbotNote Added: 0125833
2021-01-28 14:12markmm82Note Deleted: 0125803
2021-01-28 14:12markmm82Note Deleted: 0125833
2021-01-28 14:33hgbotNote Added: 0125835
2021-01-29 08:47vmromanosStatusscheduled => acknowledged
2021-01-29 13:04hgbotNote Added: 0125853
2021-01-29 13:21markmm82Statusacknowledged => scheduled
2021-01-29 23:17hgbotNote Added: 0125867
2021-01-29 23:24markmm82Note Deleted: 0125853
2021-01-29 23:24markmm82Note Deleted: 0125835
2021-02-09 17:08markmm82Note Added: 0126059
2021-02-12 09:31hgbotResolutionopen => fixed
2021-02-12 09:31hgbotStatusscheduled => closed
2021-02-12 09:31hgbotNote Added: 0126087
2021-02-12 09:31hgbotFixed in Version => PR21Q2
2021-02-12 09:31hgbotNote Added: 0126088

Notes
(0125795)
psanjuan   
2021-01-27 09:36   
Original name is Sint Maarten.
(0125867)
hgbot   
2021-01-29 23:17   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/294 [^]
(0126059)
markmm82   
2021-02-09 17:08   
Test Plan 1:
  Execute an install source on PI with the fix applied.
  Login and go to Country and Regions window.
  Notice that Netherland Antilles country is deactivated.
  Notice there are two new countries: Sint Maarten and Curaçao.

Test Plan 2:
  Go to any version previous than PI and without having the fix applied, for instance 20Q3.
  Apply the fix.
  Upgrade code to a major version (for instance 20Q4, 21Q1 or pi)
  Execute ant smartbuild -Dlocal=no command
  Notice that Netherland Antilles country is deactivated.
  Notice there are two new countries: Sint Maarten and Curaçao.
(0126087)
hgbot   
2021-02-12 09:31   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/294 [^]
(0126088)
hgbot   
2021-02-12 09:31   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 65ab02d805c8f1f7b8da69ee580bb47b50203cee
Author: Mark Orlando Molina <markmm82@gmail.com>
Date: 2021-02-12T08:31:40+00:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/65ab02d805c8f1f7b8da69ee580bb47b50203cee [^]

Fixed BUG-45763: Added "Sint Maarten" and "Curaçao" new countries

Also "Netherlands Antilles" was deactivated

---
A src-util/modulescript/build/classes/org/openbravo/modulescript/AddSintMaartenAndCuracao.class
A src-util/modulescript/build/classes/org/openbravo/modulescript/AddSintMaartenAndCuracaoData.class
A src-util/modulescript/src/org/openbravo/modulescript/AddSintMaartenAndCuracao.java
A src-util/modulescript/src/org/openbravo/modulescript/AddSintMaartenAndCuracao_data.xsql
M src-db/database/sourcedata/referencedData/C_COUNTRY.xml
---