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 
Review Assigned To
Web browser
ModulesCore
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 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