0017353: synchronize terminology is not translating some purchase window's field without specific translation for purchase

Openbravo Issue Tracking System - Openbravo ERP

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0017353

Openbravo ERP

00. Application dictionary

public

2011-05-25 13:27

2011-07-13 09:49

Reporter

maite

Assigned To

egoitz

Priority

urgent

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

2.50MP29

Target Version

2.50MP31

Fixed in Version

Merge Request Status

Review Assigned To

OBNetwork customer

Web browser

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0017353: synchronize terminology is not translating some purchase window's field without specific translation for purchase

Description

synchronize terminology is not translating some purchase window's field without specific translation for purchase

Steps To Reproduce

0. 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