c2c-oerpscenario team mailing list archive

["Ferdinand @ Camptocamp" <789019@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

IMHO many tables should have uniquenes enforced using a column which is
"visible" for the user, because in production envirenment the user has
to identify and choose the correct resource "reading" the name or
similar.

Caveat: trailing blanks names with trailing "look" identical, but are not identical for check of uniqueness
IMHO it does not make sense to store trailing blanks. (in general)
(ASCII-Code 32, UnicodeU+0020.)

I recognize that there might be resources like partners having the same
"official" name and might be distinguish only by address or similar. In
this case name + reference/code must be used.

res.company - name
res.currency - symbol
res.partner - name (+ reference)
res.partner.bank - account or iban
account.period - name
account.tax - name
product_template - name (+code)
....

** Affects: openobject-addons
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.
https://bugs.launchpad.net/bugs/789019

Title:
  unique keys missing

Status in OpenERP Modules (addons):
  New

Bug description:
  IMHO many tables should have uniquenes enforced using a column which
  is "visible" for the user, because in production envirenment the user
  has to identify and choose the correct resource "reading" the name or
  similar.

  Caveat: trailing blanks names with trailing "look" identical, but are not identical for check of uniqueness
  IMHO it does not make sense to store trailing blanks. (in general)
  (ASCII-Code 32, UnicodeU+0020.)

  I recognize that there might be resources like partners having the
  same "official" name and might be distinguish only by address or
  similar. In this case name + reference/code must be used.

  res.company - name
  res.currency - symbol
  res.partner - name (+ reference)
  res.partner.bank - account or iban
  account.period - name
  account.tax - name
  product_template - name (+code)
  ....