Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0023260 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] A. Platform | major | have not tried | 2013-03-07 17:44 | 2013-03-13 14:44 | |||
Reporter | egoitz | View Status | public | |||||
Assigned To | AugustoMauch | |||||||
Priority | immediate | Resolution | fixed | Fixed in Version | 3.0MP22 | |||
Status | closed | Fix in branch | Fixed in SCM revision | 141b8d2ba8dc | ||||
Projection | none | ETA | none | Target Version | 3.0MP22 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 3.0MP20 | SCM revision | ||||||
Merge Request Status | ||||||||
Review Assigned To | shankarb | |||||||
OBNetwork customer | OBPS | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0023260: The time fields are not correctly exported to csv | |||||||
Description | When 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. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
||||||||
|
![]() |
|
(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 (administrator) 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 (viewer) 2013-03-13 14:44 |
Code reviewed and verified in pi changeset 4b43f5a6429b |
![]() |
|||
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 | OBNetwork customer | => Yes |
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 |