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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0017857
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2011-06-30 19:222012-04-26 11:23
ReportershuehnerView Statuspublic 
Assigned Tomigueldejuana 
PrioritynormalResolutionfixedFixed in Version3.0MP11
StatusclosedFix in branchpiFixed in SCM revisiona3138b899536
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0017857: CSV export of Query List widget uses wrong labels for columns headers

DescriptionThe CSV export of the QueryListWidget is using internal column/property names when exporting the widget instead of the names shown i.e. in the querylistwidget grid itself..

Example internal names used in the csv file
organizationName
documentNo
businessPartnerName

User-visible normal names:
Document Number
Business Partner
Date

Also the order of the seems doesn't correntpond to the order shown in the query list grid.

Probably (not tested) no translation of the column headers is done
Steps To Reproducesee description. Export data of i.e. 'Invoices to collect' query list widget as a csv-file and compare first line of this csv-file with grid shown (on screen) for the widget.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00167473.0MP1 closedmarvintm csv export of querylist widget uses wrong quoting for header fields 

-  Notes
(0047482)
alostale (manager)
2012-04-11 12:46

Note that translations should also be taken into account to translate labels.
(0047532)
hgbot (developer)
2012-04-12 16:09

Repository: erp/devel/pi
Changeset: a3138b899536313ec220b47b39549ed5943d3bba
Author: Miguel de Juana <miguel.dejuana <at> openbravo.com>
Date: Thu Apr 12 16:07:37 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/a3138b899536313ec220b47b39549ed5943d3bba [^]

Fixed issue 17857: Exporting QueryListWidget, headers are labels instead of ids
The CSV export of the QueryListWidget was using internal column/property names when exporting the widget. Now is showing the names showed in the querylistwidget grid itself.
The order of the columns in the exported file is ok. It's exporting the whole grid (as same as maximized window).

---
M modules/org.openbravo.client.querylist/src/org/openbravo/client/querylist/QueryListDataSource.java
M modules/org.openbravo.client.querylist/src/org/openbravo/client/querylist/QueryListUtils.java
---
(0047533)
migueldejuana (developer)
2012-04-12 16:15

Widget exports the whole grid as same as maximized window. If we want to change this, exporting only the columns showed in the grid of the widget, we have to change QueryListDataSource.java:

Put:

if (queryAliases[i].equals(column.getDisplayExpression())
                && (viewMode.equals("maximized") || viewMode.equals("widget")
                    && column.getIncludeIn().equals("W"))
                || (!isExport && queryAliases[i].equals(column.getLinkExpression())))

Instead of:

if (queryAliases[i].equals(column.getDisplayExpression())
                || (!isExport && queryAliases[i].equals(column.getLinkExpression())))
(0047642)
hudsonbot (developer)
2012-04-17 05:31

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/cedf57621434 [^]

Maturity status: Test
(0048001)
alostale (manager)
2012-04-26 11:23

Code reviewed and verified on pi@d02dd5df46fe

Tested with base module language as well as with translation.

- Issue History
Date Modified Username Field Change
2011-06-30 19:22 shuehner New Issue
2011-06-30 19:22 shuehner Assigned To => alostale
2011-06-30 19:22 shuehner Modules => Core
2011-06-30 19:22 shuehner Relationship added related to 0016747
2011-08-05 13:02 alostale Status new => scheduled
2011-08-05 13:02 alostale fix_in_branch => pi
2012-04-11 12:46 alostale Note Added: 0047482
2012-04-11 12:46 alostale Assigned To alostale => migueldejuana
2012-04-12 16:09 hgbot Checkin
2012-04-12 16:09 hgbot Note Added: 0047532
2012-04-12 16:09 hgbot Status scheduled => resolved
2012-04-12 16:09 hgbot Resolution open => fixed
2012-04-12 16:09 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/a3138b899536313ec220b47b39549ed5943d3bba [^]
2012-04-12 16:15 migueldejuana Note Added: 0047533
2012-04-17 05:31 hudsonbot Checkin
2012-04-17 05:31 hudsonbot Note Added: 0047642
2012-04-26 11:23 alostale Note Added: 0048001
2012-04-26 11:23 alostale Status resolved => closed
2012-04-26 11:23 alostale Fixed in Version => 3.0MP11


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker