Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0035037
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Retail Modules] StoreServermajorhave not tried2017-01-23 18:052017-04-06 11:08
ReportermtaalView Statuspublic 
Assigned Tomtaal 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToAugustoMauch
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0035037: 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0035079RR17Q2 closedmtaal Use getColumnValue instead of datamap for performance reasons 

-  Notes
(0093785)
mtaal (manager)
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 (developer)
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 (manager)
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 (manager)
2017-01-30 10:57

Code reviewed
(0094273)
mtaal (manager)
2017-02-13 16:54

Move code to the but template and the but specific module
(0094315)
hgbot (developer)
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 (manager)
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 (developer)
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 (manager)
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 (developer)
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 (manager)
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 (manager)
2017-03-09 09:37

Code reviewed and verified
(0095862)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2017-01-23 18:05 mtaal New Issue
2017-01-23 18:05 mtaal Assigned To => mtaal
2017-01-23 18:05 mtaal Triggers an Emergency Pack => No
2017-01-23 18:07 mtaal Status new => scheduled
2017-01-23 18:07 mtaal Note Added: 0093785
2017-01-23 18:07 mtaal Status scheduled => resolved
2017-01-23 18:07 mtaal Resolution open => fixed
2017-01-23 18:07 mtaal Review Assigned To => AugustoMauch
2017-01-30 10:34 hgbot Checkin
2017-01-30 10:34 hgbot Note Added: 0093918
2017-01-30 10:35 mtaal Note Added: 0093919
2017-01-30 10:44 mtaal Relationship added related to 0035079
2017-01-30 10:57 AugustoMauch Note Added: 0093922
2017-01-30 10:57 AugustoMauch Status resolved => closed
2017-02-13 16:54 mtaal Note Added: 0094273
2017-02-13 16:54 mtaal Status closed => new
2017-02-13 16:54 mtaal Resolution fixed => open
2017-02-14 13:49 hgbot Checkin
2017-02-14 13:49 hgbot Note Added: 0094315
2017-02-14 14:19 mtaal Status new => scheduled
2017-02-14 14:19 mtaal Note Added: 0094317
2017-02-14 14:19 mtaal Status scheduled => resolved
2017-02-14 14:19 mtaal Resolution open => fixed
2017-02-16 16:14 hgbot Checkin
2017-02-16 16:14 hgbot Note Added: 0094394
2017-02-27 11:08 AugustoMauch Note Added: 0094633
2017-02-27 11:08 AugustoMauch Status resolved => new
2017-02-27 11:08 AugustoMauch Resolution fixed => open
2017-03-07 17:17 hgbot Checkin
2017-03-07 17:17 hgbot Note Added: 0094804
2017-03-07 17:19 mtaal Status new => scheduled
2017-03-07 17:19 mtaal Note Added: 0094805
2017-03-07 17:19 mtaal Status scheduled => resolved
2017-03-07 17:19 mtaal Resolution open => fixed
2017-03-09 09:37 AugustoMauch Note Added: 0094851
2017-03-09 09:37 AugustoMauch Status resolved => closed
2017-04-06 11:08 hgbot Checkin
2017-04-06 11:08 hgbot Note Added: 0095862


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker