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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0023260
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2013-03-07 17:442013-03-13 14:44
ReporteregoitzView Statuspublic 
Assigned ToAugustoMauch 
PriorityimmediateResolutionfixedFixed in Version3.0MP22
StatusclosedFix in branchFixed in SCM revision141b8d2ba8dc
ProjectionnoneETAnoneTarget Version3.0MP22
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0MP20SCM revision 
Review Assigned Toshankarb
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0023260: The time fields are not correctly exported to csv

DescriptionWhen exporting a grid to csv with a column defined as time, the time is exported incorrectly.
Steps To Reproduce-Go to process request window
-Add the start time on the grd
-Export the grid
*See that starttime columns is exported with incorrect time.
In my case with 1 hours difference. It could be related with the timezone of the client.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00218103.0MP19 closedAugustoMauch The times are incorrectly exported when exporting the grid to csv 

-  Notes
(0057151)
hgbot (developer)
2013-03-07 18:16

 Repository: erp/devel/pi
Changeset: 141b8d2ba8dca36f64a783d88aab7489b775b29e
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Thu Mar 07 18:14:20 2013 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/141b8d2ba8dca36f64a783d88aab7489b775b29e [^]

Fixes issue 23260: Time fields are exported properly to CSV

In the fix of the issue 21810 [1] a change was done to export the DateTime columns properly to CSV. This fix did not apply to Time fields, so when a time column was exported to CSV it could belong to the wrong timezone.

This fix applies the fix of the DateTime columns to the Time columns.

[1] https://issues.openbravo.com/view.php?id=21810 [^]

---
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DataSourceServlet.java
M src/org/openbravo/base/model/Property.java
---
(0057152)
AugustoMauch (manager)
2013-03-07 18:19

 Test plan:

As System Administrator
- Open the Preferences window
- Add a preference to the property "Local Timezone ID", choose the proper timezone from this list [1].
- Log out and log in again to load the new preference.
- Open the Process Definition window.
- Make visible the Start Time and the Creation Date columns
- Export the grid to CSV
- Check that the values of the Creation Date and Start Time columns are the same in the CSV and in the grid

[1] http://www.java2s.com/Tutorial/Java/0120__Development/GettingallthetimezonesIDs.htm [^]
(0057228)
shankarb (reporter)
2013-03-13 14:44

 Code reviewed and verified in pi changeset 4b43f5a6429b

- Issue History
Date Modified Username Field Change
2013-03-07 17:44 egoitz New Issue
2013-03-07 17:44 egoitz Assigned To => AugustoMauch
2013-03-07 17:44 egoitz Modules => Core
2013-03-07 17:44 egoitz Triggers an Emergency Pack => No
2013-03-07 17:44 egoitz Relationship added related to 0021810
2013-03-07 18:10 AugustoMauch Issue Monitored: shankarb
2013-03-07 18:10 AugustoMauch Review Assigned To => shankarb
2013-03-07 18:16 hgbot Checkin
2013-03-07 18:16 hgbot Note Added: 0057151
2013-03-07 18:16 hgbot Status new => resolved
2013-03-07 18:16 hgbot Resolution open => fixed
2013-03-07 18:16 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/141b8d2ba8dca36f64a783d88aab7489b775b29e [^]
2013-03-07 18:19 AugustoMauch Note Added: 0057152
2013-03-13 14:44 shankarb Note Added: 0057228
2013-03-13 14:44 shankarb Status resolved => closed
2013-03-13 14:44 shankarb Fixed in Version => 3.0MP22

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker