← Back to team overview

openerp-india team mailing list archive

[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