Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017755Openbravo ERP00. Application dictionarypublic2011-05-25 13:272011-07-13 09:49
Reportermaite 
Assigned Toegoitz 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP29 
Target Version2.50MP32Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017755: synchronize terminology is not translating some purchase window's field without specific translation for purchase
Descriptionsynchronize terminology is not translating some purchase window's field without specific translation for purchase
Steps To Reproduce0. install Spanish language translation
1. Modify element translation of "Account_ID" columnname.
2. Set core as in development
3. Run Synchronize terminology procedure and realize field translation is not properly updated
Proposed Solution* Function ad_synchronize is filtering by

AND (e.PO_Name IS NOT NULL AND e.PO_Name <> '')

when po_name field is empty is not properly updating AD_FIELD_TRL table with name field. This clause needs to be removed in lines 671 and 715

* Also AD_FIELD_TRL update of line 629 and 635 needs to be corrected to properly set value of Name, Description and Help fields.

It is necessary to replace blocks like:
SET NAME=
      (SELECT e.PO_Name
      FROM AD_ELEMENT_TRL e, AD_COLUMN c, AD_FIELD f
      WHERE e.AD_LANGUAGE=AD_FIELD_TRL.AD_LANGUAGE AND e.AD_Element_ID=c.AD_Element_ID
      AND c.AD_Column_ID=f.AD_Column_ID AND f.AD_Field_ID=AD_FIELD_TRL.AD_Field_ID
      )

by this other code:

SET NAME=
      (SELECT (CASE WHEN e.PO_Name='' THEN e.Name
           ELSE COALESCE(e.PO_Name, e.Name)
       END)
      FROM AD_ELEMENT_TRL e, AD_COLUMN c, AD_FIELD f
      WHERE e.AD_LANGUAGE=AD_FIELD_TRL.AD_LANGUAGE AND e.AD_Element_ID=c.AD_Element_ID
      AND c.AD_Column_ID=f.AD_Column_ID AND f.AD_Field_ID=AD_FIELD_TRL.AD_Field_ID
      )

[same for description and help fields]
Additional Information
TagsNo tags attached.
Relationships
blocks defect 00173532.50MP31 closed egoitz synchronize terminology is not translating some purchase window's field without specific translation for purchase 
Attached Filesdiff 17755.diff (3,702) 2011-06-21 18:02
https://issues.openbravo.com/file_download.php?file_id=4210&type=bug
Issue History
Date ModifiedUsernameFieldChange
2011-06-21 10:59egoitzTypedefect => backport
2011-06-21 10:59egoitzfix_in_branch => 2.50
2011-06-21 18:02egoitzFile Added: 17755.diff
2011-06-21 18:02egoitzNote Added: 0038420
2011-06-21 18:09egoitzStatusscheduled => resolved
2011-06-21 18:09egoitzFixed in SCM revision =>
2011-06-24 12:11jonalegriaesarteNote Added: 0038522
2011-06-24 12:11jonalegriaesarteStatusresolved => new
2011-06-24 12:11jonalegriaesarteTarget Version2.50MP31 => 2.50MP32
2011-06-24 12:11jonalegriaesarteStatusnew => scheduled
2011-07-04 08:54hgbotCheckin
2011-07-04 08:54hgbotNote Added: 0038726
2011-07-04 08:54hgbotStatusscheduled => resolved
2011-07-04 08:54hgbotResolutionopen => fixed
2011-07-04 08:54hgbotFixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/9b8312fc93b5dad18e8ff7673ab9a7a4fbaab5fd [^]
2011-07-13 09:49maiteNote Added: 0039026
2011-07-13 09:49maiteStatusresolved => closed

Notes
(0038420)
egoitz   
2011-06-21 18:02   
file attached with the solution
(0038522)
jonalegriaesarte   
2011-06-24 12:11   
Changed the target version to MP32
(0038726)
hgbot   
2011-07-04 08:54   
Repository: erp/stable/2.50
Changeset: 9b8312fc93b5dad18e8ff7673ab9a7a4fbaab5fd
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Tue Jun 21 17:39:16 2011 +0200
URL: http://code.openbravo.com/erp/stable/2.50/rev/9b8312fc93b5dad18e8ff7673ab9a7a4fbaab5fd [^]

Fixed Issue 17755. Syncronize terminology on purchase elements

---
M src-db/database/model/functions/AD_SYNCHRONIZE.xml
---
(0039026)
maite   
2011-07-13 09:49   
verified