Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017353Openbravo ERP00. Application dictionarypublic2011-05-25 13:272011-07-13 09:49
Reportermaite 
Assigned Toegoitz 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP29 
Target Version2.50MP31Fixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017353: 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
depends on backport 00177552.50MP32 closed egoitz synchronize terminology is not translating some purchase window's field without specific translation for purchase 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-05-25 13:27maiteNew Issue
2011-05-25 13:27maiteAssigned To => alostale
2011-05-25 13:27maiteModules => Core
2011-05-25 13:27maiteOBNetwork customer => Yes
2011-05-25 13:27maiteAssigned Toalostale => egoitz
2011-05-25 13:28maiteIssue Monitored: networkb
2011-06-21 10:59egoitzStatusnew => scheduled
2011-06-21 10:59egoitzfix_in_branch => pi
2011-06-21 17:40hgbotCheckin
2011-06-21 17:40hgbotNote Added: 0038418
2011-06-21 17:40hgbotStatusscheduled => resolved
2011-06-21 17:40hgbotResolutionopen => fixed
2011-06-21 17:40hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/6018a448018ba443b6364cf672e6f1a3032a9a4b [^]
2011-06-22 11:44hudsonbotCheckin
2011-06-22 11:44hudsonbotNote Added: 0038475
2011-07-13 09:49maiteNote Added: 0039025
2011-07-13 09:49maiteStatusresolved => closed

Notes
(0038418)
hgbot   
2011-06-21 17:40   
Repository: erp/devel/pi
Changeset: 6018a448018ba443b6364cf672e6f1a3032a9a4b
Author: Egoitz Castillo <egoitz.castillo <at> openbravo.com>
Date: Tue Jun 21 17:38:21 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/6018a448018ba443b6364cf672e6f1a3032a9a4b [^]

Fixed Issue 17353. Syncronize terminology on purchase elements

---
M src-db/database/model/functions/AD_SYNCHRONIZE.xml
---
(0038475)
hudsonbot   
2011-06-22 11:44   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/abb438586c0e [^]

Maturity status: Test
(0039025)
maite   
2011-07-13 09:49   
verified