Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0019156Openbravo ERPZ. Otherspublic2011-11-23 17:052011-11-30 12:37
Reporterjonalegriaesarte 
Assigned Toalostale 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP6Fixed 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
Summary0019156: Translation in Query Widget Columns is not exportable
DescriptionTranslation in Query Widget Columns is not exportable and, therefore, not possible to package in a translation module.
Steps To Reproduce- Create a Query Widget with at list one column
- Translate the column name into a different language in "Column Translation" tab
- Export the language
- Notice that no xml has been created for "OBCQL_Query_Column_Trl" table

To reproduce it faster you can translate one of the out-of-the-box existing Query
Widgets (e.g. Invoices pending to collect).
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to design defect 0019197 acknowledged Triage Platform Base Design defects in export translation process 
related to defect 0019195 closed alostale Widget menu entries translations are not exported 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-11-23 17:05jonalegriaesarteNew Issue
2011-11-23 17:05jonalegriaesarteAssigned To => alostale
2011-11-23 17:05jonalegriaesarteModules => Core
2011-11-25 17:08jmonIssue Monitored: jmon
2011-11-28 15:18alostaleRelationship addedrelated to 0019195
2011-11-28 16:24alostaleRelationship addedrelated to 0019197
2011-11-28 16:26alostaleNote Added: 0043409
2011-11-28 16:28alostaleNote Added: 0043410
2011-11-28 16:36hgbotCheckin
2011-11-28 16:36hgbotNote Added: 0043413
2011-11-28 16:36hgbotStatusnew => resolved
2011-11-28 16:36hgbotResolutionopen => fixed
2011-11-28 16:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/323950c8eb3166f362410156df8d99d3ff1f1f4b [^]
2011-11-30 12:29marvintmNote Added: 0043429
2011-11-30 12:29marvintmStatusresolved => closed
2011-11-30 12:37hudsonbotCheckin
2011-11-30 12:37hudsonbotNote Added: 0043569

Notes
(0043409)
alostale   
2011-11-28 16:26   
The root cause for this problem is in the export translation process design itself (see issue 1 in 0019197).

Currently trl tables are exported in case its parent or grand parent table has an ad_module_id column. To fix the issue we are adding an additional level to look for ad_module_id (up to grand-grand parent).
(0043410)
alostale   
2011-11-28 16:28   
Test and regression plan

Same as https://issues.openbravo.com/view.php?id=19195#c43408 [^]

Checking OBCQL_Query_Column translations are exported and imported.
(0043413)
hgbot   
2011-11-28 16:36   
Repository: erp/devel/pi
Changeset: 323950c8eb3166f362410156df8d99d3ff1f1f4b
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Mon Nov 28 16:34:20 2011 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/323950c8eb3166f362410156df8d99d3ff1f1f4b [^]

fixed bug 19156: Translation in Query Widget Columns is not exportable

  Adding an additional level when looking for ad_module_id column in *trl
  tables

---
M src/org/openbravo/erpCommon/ad_forms/TranslationManager.java
M src/org/openbravo/erpCommon/ad_forms/Translation_data.xsql
---
(0043429)
marvintm   
2011-11-30 12:29   
Reviewed the diff to look for regressions, and tested that the table contents are exported, and that when the resulting XML exists in a translation module, its contents are correctly imported.
(0043569)
hudsonbot   
2011-11-30 12:37   
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/01809c7b3135 [^]

Maturity status: Test