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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0007920
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] F. Localizationmajoralways2009-03-03 15:212009-07-26 22:07
ReporterMbX7174View Statuspublic 
Assigned Topheenan 
PrioritynormalResolutionfixedFixed in Version2.50MP3
StatusclosedFix in branchFixed in SCM revision35d3cb4c25c1
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.50alpha-r11SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007920: Translation fails, because the ad_textinterfaces table refers to a file, using an relative path, application uses absolute path

DescriptionTextInterfacesData::selectText() creates a 3-fold SQL query (UNION).
The selects, indicated by orderSeq 3 and 1 do not function properly, because the htmlFile parameter given to the selectText-method is a fully qualified file name (absolute path), while the filename-field in the ad_textinterfaces table refers to the files, using a relative path (/org/...).
Steps To Reproduce1) Introduce Spanish into Openbravo
2) Switch OB to Spanish
3) Print a Sales Invoice

Result:

The invoice notes do not get translated because of the bug.
Proposed SolutionThe filename is used for 2 purposes:
1) To locate the JRXML file on the local file system (absolute path is needed)
2) To compose the query in the ad_textinterfaces table

Separate both concerns, or inject a prefix that can crop the fully qualified file name.
Tags250MP3releasecandidate, commsup_sprint7, leo
Attached Filespdf file icon InvoiceReport.20090303-143117.pdf [^] (40,634 bytes) 2009-03-03 15:21

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0014403)
hgbot (developer)
2009-03-04 19:54

Repository: erp/devel/pi
Changeset: 548a51c5302da5a20f6092ca0814baeae4828595
Author: Phil Heenan <phillip.heenan <at> openbravo.com>
Date: Wed Mar 04 19:54:01 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/548a51c5302da5a20f6092ca0814baeae4828595 [^]

Fixed 7920. Modified query input to use a shortened version of the file path. Updated translation handling for manual forms to ensure translations are returned. Implemented translation for sub reports passed through the PrintController.

---
M src-core/src/org/openbravo/uiTranslation/TranslationHandler.java
M src-core/src/org/openbravo/xmlEngine/XmlDocument.java
M src/org/openbravo/base/secureApp/HttpSecureAppServlet.java
M src/org/openbravo/erpCommon/ad_process/JasperProcess.java
M src/org/openbravo/erpCommon/utility/Utility.java
M src/org/openbravo/erpCommon/utility/reporting/ReportManager.java
---
(0017799)
hgbot (developer)
2009-07-03 13:11

Repository: erp/devel/pi
Changeset: 35d3cb4c25c13a090714bddcf3e1521fe8efb827
Author: Phil Heenan <phillip.heenan <at> openbravo.com>
Date: Wed Mar 04 19:54:01 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/35d3cb4c25c13a090714bddcf3e1521fe8efb827 [^]

Fixed 7920. Modified query input to use a shortened version of the file path. Updated translation handling for manual forms to ensure translations are returned. Implemented translation for sub reports passed through the PrintController.

---
M src-core/src/org/openbravo/uiTranslation/TranslationHandler.java
M src-core/src/org/openbravo/xmlEngine/XmlDocument.java
M src/org/openbravo/base/secureApp/HttpSecureAppServlet.java
M src/org/openbravo/erpCommon/ad_process/JasperProcess.java
M src/org/openbravo/erpCommon/utility/Utility.java
M src/org/openbravo/erpCommon/utility/reporting/ReportManager.java
---

- Issue History
Date Modified Username Field Change
2009-03-03 15:21 MbX7174 New Issue
2009-03-03 15:21 MbX7174 Assigned To => rafaroda
2009-03-03 15:21 MbX7174 File Added: InvoiceReport.20090303-143117.pdf
2009-03-03 15:49 rafaroda OBNetwork customer => No
2009-03-03 15:49 rafaroda Assigned To rafaroda => pheenan
2009-03-04 19:54 hgbot Checkin
2009-03-04 19:54 hgbot Note Added: 0014403
2009-03-04 19:54 hgbot Status new => resolved
2009-03-04 19:54 hgbot Resolution open => fixed
2009-03-04 19:54 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/548a51c5302da5a20f6092ca0814baeae4828595 [^]
2009-03-06 09:30 pheenan Tag Attached: commsup_sprint7
2009-04-21 10:53 psarobe Status resolved => closed
2009-04-22 00:01 anonymous sf_bug_id 0 => 2778042
2009-07-03 13:11 hgbot Checkin
2009-07-03 13:11 hgbot Note Added: 0017799
2009-07-03 13:11 hgbot Status closed => resolved
2009-07-03 13:11 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/548a51c5302da5a20f6092ca0814baeae4828595 [^] => http://code.openbravo.com/erp/devel/pi/rev/35d3cb4c25c13a090714bddcf3e1521fe8efb827 [^]
2009-07-21 16:24 psarobe Fixed in Version 2.50 => 2.50MP3
2009-07-21 16:26 psarobe Tag Attached: 250MP3releasecandidate
2009-07-21 18:43 psarobe Tag Attached: leo
2009-07-26 22:07 psarobe Status resolved => closed


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker