Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035037Retail ModulesStoreServerpublic2017-01-23 18:052017-04-06 11:08
Reportermtaal 
Assigned Tomtaal 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035037: Override synchronized table and export dataset to consider nosica store id
DescriptionFor but specific code, the initial data load will initially create master data in the * org with a special field set to denote the store id. This data (and is related data) should not be replicated to other BUT stores, eventhough it is defined on * level.

The documentation [1] describes the overall idea of initial master data load. The spreadsheet [2] describes for what tables the export dataset and the synchronized table definition has been changed.

For tables already defined at client level no changes are needed.

[1]
https://docs.google.com/document/d/1hfWaAr08vsZKnB4VFRcbb3mLWtlbjXEJdJjchBeWAeo/edit [^]

[2]
https://docs.google.com/spreadsheets/d/1-dtymjoo4zliXzn3JT6lia0whUo-uKwLJXRkeZ6YAxY/edit#gid=0 [^]
Steps To ReproduceSee documentation
Proposed SolutionAdapt the synchronized table and export definition in a BUT specific repo.
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0035079RR17Q2 closed mtaal Use getColumnValue instead of datamap for performance reasons 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-01-23 18:05mtaalNew Issue
2017-01-23 18:05mtaalAssigned To => mtaal
2017-01-23 18:05mtaalTriggers an Emergency Pack => No
2017-01-23 18:07mtaalStatusnew => scheduled
2017-01-23 18:07mtaalNote Added: 0093785
2017-01-23 18:07mtaalStatusscheduled => resolved
2017-01-23 18:07mtaalResolutionopen => fixed
2017-01-23 18:07mtaalReview Assigned To => AugustoMauch
2017-01-30 10:34hgbotCheckin
2017-01-30 10:34hgbotNote Added: 0093918
2017-01-30 10:35mtaalNote Added: 0093919
2017-01-30 10:44mtaalRelationship addedrelated to 0035079
2017-01-30 10:57AugustoMauchNote Added: 0093922
2017-01-30 10:57AugustoMauchStatusresolved => closed
2017-02-13 16:54mtaalNote Added: 0094273
2017-02-13 16:54mtaalStatusclosed => new
2017-02-13 16:54mtaalResolutionfixed => open
2017-02-14 13:49hgbotCheckin
2017-02-14 13:49hgbotNote Added: 0094315
2017-02-14 14:19mtaalStatusnew => scheduled
2017-02-14 14:19mtaalNote Added: 0094317
2017-02-14 14:19mtaalStatusscheduled => resolved
2017-02-14 14:19mtaalResolutionopen => fixed
2017-02-16 16:14hgbotCheckin
2017-02-16 16:14hgbotNote Added: 0094394
2017-02-27 11:08AugustoMauchNote Added: 0094633
2017-02-27 11:08AugustoMauchStatusresolved => new
2017-02-27 11:08AugustoMauchResolutionfixed => open
2017-03-07 17:17hgbotCheckin
2017-03-07 17:17hgbotNote Added: 0094804
2017-03-07 17:19mtaalStatusnew => scheduled
2017-03-07 17:19mtaalNote Added: 0094805
2017-03-07 17:19mtaalStatusscheduled => resolved
2017-03-07 17:19mtaalResolutionopen => fixed
2017-03-09 09:37AugustoMauchNote Added: 0094851
2017-03-09 09:37AugustoMauchStatusresolved => closed
2017-04-06 11:08hgbotCheckin
2017-04-06 11:08hgbotNote Added: 0095862

Notes
(0093785)
mtaal   
2017-01-23 18:07   
Resolved by commit:

https://code.openbravo.com/erp/pmods-branches/org.openbravo.retail.storeserver.synchronization-but/rev/6c3ca8c0adec [^]
(0093918)
hgbot   
2017-01-30 10:34   
Repository: erp/pmods/org.openbravo.retail.orderpreparation.synchronization
Changeset: 25d0dc4136c292af20778692a332ecb5e27f3a6d
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Mon Jan 30 10:34:33 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.orderpreparation.synchronization/rev/25d0dc4136c292af20778692a332ecb5e27f3a6d [^]

Related to issue 35037: Override synchronized table and export dataset to consider nosica store id
Use a specific router for the OBORPRE_printer table, change the dataset table so that only specific
data is exported

---
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
M src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml
---
(0093919)
mtaal   
2017-01-30 10:35   
This commit is also part of the solution set:
https://code.openbravo.com/erp/pmods/org.openbravo.retail.orderpreparation.synchronization/rev/25d0dc4136c2 [^]
(0093922)
AugustoMauch   
2017-01-30 10:57   
Code reviewed
(0094273)
mtaal   
2017-02-13 16:54   
Move code to the but template and the but specific module
(0094315)
hgbot   
2017-02-14 13:49   
Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization.but
Changeset: a92ff43457f2207411c6eaf02e554fbb5ff9f6b6
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Tue Feb 14 13:49:33 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization.but/rev/a92ff43457f2207411c6eaf02e554fbb5ff9f6b6 [^]

Related to issue 35037: move code from retail.storeserver.synchronization to BUT specific repo
This changes contain the new routers used for routing nosica specific products.

---
A src-db/database/sourcedata/STRSYNC_CUSTOM_ROUTER.xml
A src/org/openbravo/retail/storeserver/synchronization/but/ProductChildNosicaRouter.java
A src/org/openbravo/retail/storeserver/synchronization/but/ProductNosicaStoreRouter.java
A src/org/openbravo/retail/storeserver/synchronization/but/WHChildNosicaRouter.java
---
(0094317)
mtaal   
2017-02-14 14:19   
https://code.openbravo.com/erp/pmods-branches/org.openbravo.retail.storeserver.synchronization-but/rev/cc9ea25578e9 [^]

https://code.openbravo.com/erp/pmods-branches/org.openbravo.retail.storeserver.synchronization-but/rev/cc9ea25578e9 [^]

https://bitbucket.org/gpscode/but_com.openbravo.but.template-but-dev/commits/aef1fc8589b3bed4f06a2223ebb9e123a2bcc742 [^]
(0094394)
hgbot   
2017-02-16 16:14   
Repository: erp/pmods/org.openbravo.retail.storeserver.synchronization.but
Changeset: 89431f1acbf21e93bc72ede3582a49fcc8e49356
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Thu Feb 16 16:14:21 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization.but/rev/89431f1acbf21e93bc72ede3582a49fcc8e49356 [^]

Related to issue 35037: backing out source changes to solve compile error

---
R src/org/openbravo/retail/storeserver/synchronization/but/ProductChildNosicaRouter.java
R src/org/openbravo/retail/storeserver/synchronization/but/ProductNosicaStoreRouter.java
R src/org/openbravo/retail/storeserver/synchronization/but/WHChildNosicaRouter.java
---
(0094633)
AugustoMauch   
2017-02-27 11:08   
In this module [1] the Nosica routers have been deleted [2], but there are still entries in STRSYNC_CUSTOM_ROUTER referencing them [3]

[1] https://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization.but [^]
[2] http://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization.but/rev/89431f1acbf21e93bc72ede3582a49fcc8e49356 [^]
[3] https://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization.but/file/89431f1acbf2/src-db/database/sourcedata/STRSYNC_CUSTOM_ROUTER.xml [^]
(0094804)
hgbot   
2017-03-07 17:17   
Repository: erp/pmods/org.openbravo.retail.orderpreparation.synchronization
Changeset: c78b12b8130f95144a52cb2aee77c3a6861cb96d
Author: Martin Taal <martin.taal <at> openbravo.com>
Date: Tue Mar 07 17:17:36 2017 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.orderpreparation.synchronization/rev/c78b12b8130f95144a52cb2aee77c3a6861cb96d [^]

Related to issue 35037: Override synchronized table and export dataset to consider nosica store id
Move nosica store filtering to template module, remove from this module

---
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
M src-db/database/sourcedata/STRSYNC_SYNCHRONIZEDTABLE.xml
---
(0094805)
mtaal   
2017-03-07 17:19   
Other related commits:
https://code.openbravo.com/erp/pmods/org.openbravo.retail.storeserver.synchronization.but/rev/708c55f5f722 [^]

https://bitbucket.org/gpscode/150355_com.openbravo.but.integration.copystores.template/commits/888525b14f21e26a16b9f4e129a04a2a9499de1f [^]

https://bitbucket.org/gpscode/150355_com.openbravo.but.integration.copystores.template/commits/06a942eaa02211cf1b9ee2912c71b369ef85942f [^]
(0094851)
AugustoMauch   
2017-03-09 09:37   
Code reviewed and verified
(0095862)
hgbot   
2017-04-06 11:08   
Repository: erp/pmods/org.openbravo.retail.orderpreparation.synchronization
Changeset: f8e54d4c735cfefe43c76ab1a27cefef8f3c6532
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Thu Apr 06 11:06:31 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.orderpreparation.synchronization/rev/f8e54d4c735cfefe43c76ab1a27cefef8f3c6532 [^]

Related with issue 35037: Adds placeholder to dataset table where clause

---
M src-db/database/sourcedata/AD_DATASET_TABLE.xml
---