Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0017755
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 00. Application dictionarymajoralways2011-05-25 13:272011-07-13 09:49
ReportermaiteView Statuspublic 
Assigned Toegoitz 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branch2.50Fixed in SCM revision9b8312fc93b5
ProjectionnoneETAnoneTarget Version2.50MP32
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP29SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0017755: 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]
TagsNo tags attached.
Attached Filesdiff file icon 17755.diff [^] (3,702 bytes) 2011-06-21 18:02 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 00173532.50MP31 closedegoitz synchronize terminology is not translating some purchase window's field without specific translation for purchase 

-  Notes
(0038420)
egoitz (developer)
2011-06-21 18:02

file attached with the solution
(0038522)
jonalegriaesarte (reporter)
2011-06-24 12:11

Changed the target version to MP32
(0038726)
hgbot (developer)
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 (developer)
2011-07-13 09:49

verified

- Issue History
Date Modified Username Field Change
2011-06-21 10:59 egoitz Type defect => backport
2011-06-21 10:59 egoitz fix_in_branch => 2.50
2011-06-21 18:02 egoitz File Added: 17755.diff
2011-06-21 18:02 egoitz Note Added: 0038420
2011-06-21 18:09 egoitz Status scheduled => resolved
2011-06-21 18:09 egoitz Fixed in SCM revision =>
2011-06-24 12:11 jonalegriaesarte Note Added: 0038522
2011-06-24 12:11 jonalegriaesarte Status resolved => new
2011-06-24 12:11 jonalegriaesarte Target Version 2.50MP31 => 2.50MP32
2011-06-24 12:11 jonalegriaesarte Status new => scheduled
2011-07-04 08:54 hgbot Checkin
2011-07-04 08:54 hgbot Note Added: 0038726
2011-07-04 08:54 hgbot Status scheduled => resolved
2011-07-04 08:54 hgbot Resolution open => fixed
2011-07-04 08:54 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/stable/2.50/rev/9b8312fc93b5dad18e8ff7673ab9a7a4fbaab5fd [^]
2011-07-13 09:49 maite Note Added: 0039026
2011-07-13 09:49 maite Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker