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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0027117
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Initial data loadmajoralways2014-07-17 18:172014-10-29 17:48
ReporterjecharriView Statuspublic 
Assigned Tofsoto82 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revision7531ceb97694
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned ToSandrahuguet
Regression introduced in release
Summary

0027117: Create Variants method is not setting the correct organization in table m_product_ch_value importing product with "IDL Variants"

DescriptionCreate Variants method is not setting the correct organization in table m_product_ch_value importing product with "IDL Variants" module
http://centralrepository.openbravo.com/heartbeat-server/org.openbravo.forge.ui/ForgeModuleDetail/IDL-For-Variants [^]
Steps To Reproduce-Install module "IDL for Variants"
-Configure the csv products to import with "*"
-Change the user organization to "Vall blanca User"
-Do the import

You will see that created product has "Vall blanca User" organization in table "m_product_ch_value" instead of "*"

You can use the following query to check
select chv.ad_org_id,p.ad_org_id,c.ad_org_id,v.ad_org_id
from m_product_ch_value chv
  join m_product p on p.m_product_id = chv.m_product_id
  join m_characteristic c on c.m_characteristic_id = chv.m_characteristic_id
  join m_ch_value v on v.m_ch_value_id = chv.m_ch_value_id

It will be necessary to create a module script
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00271023.0PR15Q1 closedfsoto82 Openbravo ERP Create Variants method is not setting the correct organization in table m_product_ch_value 

-  Notes
(0070790)
fsoto82 (developer)
2014-10-08 05:28

-Install module "IDL for Variants"
-Configure the csv products to import with "*"
-Do the import

Now the m_product_ch_value orgsnization is the same as the product organization.
(0071253)
hgbot (developer)
2014-10-29 17:45

Repository: erp/pmods/org.openbravo.idl.variants
Changeset: 7531ceb9769413a9470be3835711a85a782288b3
Author: Fernando Soto <fernando.soto <at> peoplewalking.com>
Date: Wed Oct 29 09:31:20 2014 -0500
URL: http://code.openbravo.com/erp/pmods/org.openbravo.idl.variants/rev/7531ceb9769413a9470be3835711a85a782288b3 [^]

Fixed bug 27117: Create Variants method is not setting the correct organization

Changed ImportProduct class to set to the product organization to the created product chacteristic value.

Also created a Modulescript to fix the data previously imported.
The modulescript is based upon UpdateProductChValueOrg, and recreated here in case the core is not updated.

---
M src/org/openbravo/idl/variants/ImportProduct.java
A build/classes/org/openbravo/idl/variants/modulescript/IDLVariantsModulesScript.class
A build/classes/org/openbravo/idl/variants/modulescript/IDLVariantsModulesScriptData.class
A src-util/modulescript/src/org/openbravo/idl/variants/modulescript/IDLVariantsModulesScript.java
A src-util/modulescript/src/org/openbravo/idl/variants/modulescript/IDLVariantsModulesScript_data.xsql
A src-util/modulescript/src/src/org/openbravo/idl/variants/modulescript/IDLVariantsModulesScriptData.java
---
(0071254)
Sandrahuguet (developer)
2014-10-29 17:48

Code review + testing OK

- Issue History
Date Modified Username Field Change
2014-07-17 18:17 jecharri New Issue
2014-07-17 18:17 jecharri Assigned To => jonalegriaesarte
2014-07-17 18:17 jecharri Resolution time => 1408485600
2014-07-17 18:17 jecharri Relationship added related to 0027102
2014-07-24 13:46 jonalegriaesarte Assigned To jonalegriaesarte => AtulOpenbravo
2014-10-08 05:25 fsoto82 Status new => scheduled
2014-10-08 05:25 fsoto82 Assigned To AtulOpenbravo => fsoto82
2014-10-08 05:25 fsoto82 fix_in_branch => pi
2014-10-08 05:28 fsoto82 Note Added: 0070790
2014-10-29 17:45 hgbot Checkin
2014-10-29 17:45 hgbot Note Added: 0071253
2014-10-29 17:45 hgbot Status scheduled => resolved
2014-10-29 17:45 hgbot Resolution open => fixed
2014-10-29 17:45 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.idl.variants/rev/7531ceb9769413a9470be3835711a85a782288b3 [^]
2014-10-29 17:48 Sandrahuguet Review Assigned To => Sandrahuguet
2014-10-29 17:48 Sandrahuguet Note Added: 0071254
2014-10-29 17:48 Sandrahuguet Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker