openerp-india team mailing list archive
-
openerp-india team
-
Mailing list archive
-
Message #17764
[Bug 1078648] [NEW] Inconsistencies in product names with translation and duplicate function
Public bug reported:
As we only use french language, the english olanguage has been disabled.
1) Create a product "Product1"
2) Duplicate "Product1" to make "SubproductA"
3) Duplicate "SubproductA" to make "SubproductB"
4) Create a new BOM for "Product1" with "SubproductA" and "SubproductB"
as components
---> Expected : In "Bill of Materials Structure", we should have a BOM
with "SubproductA" and "SubproductB" (in name and product column)
---> Reality : In "Bill of Materials Structure", we have a BOM with
"Product1 (copy)" and "Product1 (copy)(copy)" in the name column, and
the rights names "SubproductA" and "SubproductB" in the product column
(see screenshot attached).
---> Solution found : 2 SQL queries, to update first the product
template name, and then the Bom components names :
UPDATE product_template
SET name=product_product.name_template
FROM product_product
WHERE product_template.id=product_product.product_tmpl_id
UPDATE mrp_bom
SET name=product_product.name_template
FROM product_product
WHERE mrp_bom.product_id=product_product.id
---> System information :
openerp@openerp:~$ uname -a
Linux openerp 3.2.0-30-generic #48-Ubuntu SMP Fri Aug 24 16:54:40 UTC 2012 i686 i686 i386 GNU/Linux
---> OpenErp version (installed from deb http://nightly.openerp.com/6.1/nightly/deb/ ./ ) and updated this morning :
openerp@openerp:~$ dpkg -p openerp
Package: openerp
Priority: optional
Section: net
Installed-Size: 240875
Maintainer: OpenERP SA <al@xxxxxxxxxxx>
Architecture: all
Version: 6.1-20121114-003227-1
Feel free to ask for further information,
Fontenay Ronan
** Affects: openobject-addons
Importance: Undecided
Status: New
** Attachment added: "Bug illustration"
https://bugs.launchpad.net/bugs/1078648/+attachment/3433067/+files/openerp-bug2.PNG
--
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/1078648
Title:
Inconsistencies in product names with translation and duplicate
function
Status in OpenERP Addons (modules):
New
Bug description:
As we only use french language, the english olanguage has been
disabled.
1) Create a product "Product1"
2) Duplicate "Product1" to make "SubproductA"
3) Duplicate "SubproductA" to make "SubproductB"
4) Create a new BOM for "Product1" with "SubproductA" and
"SubproductB" as components
---> Expected : In "Bill of Materials Structure", we should have a BOM
with "SubproductA" and "SubproductB" (in name and product column)
---> Reality : In "Bill of Materials Structure", we have a BOM with
"Product1 (copy)" and "Product1 (copy)(copy)" in the name column, and
the rights names "SubproductA" and "SubproductB" in the product column
(see screenshot attached).
---> Solution found : 2 SQL queries, to update first the product
template name, and then the Bom components names :
UPDATE product_template
SET name=product_product.name_template
FROM product_product
WHERE product_template.id=product_product.product_tmpl_id
UPDATE mrp_bom
SET name=product_product.name_template
FROM product_product
WHERE mrp_bom.product_id=product_product.id
---> System information :
openerp@openerp:~$ uname -a
Linux openerp 3.2.0-30-generic #48-Ubuntu SMP Fri Aug 24 16:54:40 UTC 2012 i686 i686 i386 GNU/Linux
---> OpenErp version (installed from deb http://nightly.openerp.com/6.1/nightly/deb/ ./ ) and updated this morning :
openerp@openerp:~$ dpkg -p openerp
Package: openerp
Priority: optional
Section: net
Installed-Size: 240875
Maintainer: OpenERP SA <al@xxxxxxxxxxx>
Architecture: all
Version: 6.1-20121114-003227-1
Feel free to ask for further information,
Fontenay Ronan
To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/1078648/+subscriptions
Follow ups
References