Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0032600 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | major | always | 2016-04-05 13:07 | 2016-06-17 19:36 | |||
| Reporter | JONHM | View Status | public | |||||
| Assigned To | NaroaIriarte | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 3.0PR16Q3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | e3137a29c326 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | alostale | |||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | 41214 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0032600: Wrong data in csv file exported on different timezone on the client side | |||||||
| Description | Having the server in different time zone than the client creates data inconsistency at export csv file on the client side filtering by creation date range or some other date range. | |||||||
| Steps To Reproduce | *WATCH THE VIDEO ATTACHED BELOW* (Server Side from 0:00 to 0:07 and Client side from 0:08 to 1:01) 1) Create some Sales Orders and change its creation data by SQL with different hours of the same day 2) Change to a different timezone on the Client side 3) Filter by date range (Creation Date for example) 4) Export CSV -The result is a csv with different files than the grid view | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  wrong_csv.mp4 [^] (2,971,074 bytes) 2016-04-05 13:09 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0085618) hgbot (developer) 2016-04-13 15:25 |
Repository: erp/devel/pi Changeset: e3137a29c326ac8a4c4b5c3a0a5ad68e9e43bd3a Author: Naroa Iriarte <naroa.iriarte <at> openbravo.com> Date: Wed Apr 13 11:24:18 2016 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/e3137a29c326ac8a4c4b5c3a0a5ad68e9e43bd3a [^] Fixed issue 32600: Export csv was not working fine The csv files where not correctly exported from the client if the client was in a different timezone. The problem was that in the AdvancedQueryBuilder class, the way of setting the date time was not correct. The Calendar.HOUR constant was being used instead of Calendar.HOUR_OF_DAY. The first, is to set or get the hour indicating the morning or the afternoon, for example the 11:00:00 PM, the hour is 11. The second one, the one that is used now, is used for the 24 hours clock, so, if the time isn 11:00:00 the HOUR_OF_DAY is 23. --- M modules/org.openbravo.service.json/src/org/openbravo/service/json/AdvancedQueryBuilder.java --- |
|
(0085693) alostale (viewer) 2016-04-18 11:14 |
Code reviewed. Tested, exported lines to csv now match the ones seen in grid in case local time zone property matches with actual client's time zone. |
|
(0087445) hudsonbot (viewer) 2016-06-17 19:36 |
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/0dc7be081b1c [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2016-04-05 13:07 | JONHM | New Issue | |
| 2016-04-05 13:07 | JONHM | Assigned To | => platform |
| 2016-04-05 13:07 | JONHM | OBNetwork customer | => Yes |
| 2016-04-05 13:07 | JONHM | Modules | => Core |
| 2016-04-05 13:07 | JONHM | Support ticket | => 41214 |
| 2016-04-05 13:07 | JONHM | Resolution time | => 1462312800 |
| 2016-04-05 13:07 | JONHM | Triggers an Emergency Pack | => No |
| 2016-04-05 13:09 | JONHM | File Added: wrong_csv.mp4 | |
| 2016-04-05 13:11 | JONHM | Description Updated | View Revisions |
| 2016-04-05 13:11 | JONHM | Steps to Reproduce Updated | View Revisions |
| 2016-04-06 10:34 | alostale | Status | new => scheduled |
| 2016-04-06 10:34 | alostale | Assigned To | platform => NaroaIriarte |
| 2016-04-06 10:34 | alostale | Target Version | 3.0PR16Q2 => |
| 2016-04-13 15:25 | hgbot | Checkin | |
| 2016-04-13 15:25 | hgbot | Note Added: 0085618 | |
| 2016-04-13 15:25 | hgbot | Status | scheduled => resolved |
| 2016-04-13 15:25 | hgbot | Resolution | open => fixed |
| 2016-04-13 15:25 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/e3137a29c326ac8a4c4b5c3a0a5ad68e9e43bd3a [^] |
| 2016-04-13 15:26 | NaroaIriarte | Review Assigned To | => alostale |
| 2016-04-13 15:26 | NaroaIriarte | Status | resolved => scheduled |
| 2016-04-13 15:26 | NaroaIriarte | Resolution | fixed => open |
| 2016-04-13 15:26 | NaroaIriarte | Fixed in SCM revision | http://code.openbravo.com/erp/devel/pi/rev/e3137a29c326ac8a4c4b5c3a0a5ad68e9e43bd3a [^] => |
| 2016-04-18 10:03 | NaroaIriarte | Status | scheduled => resolved |
| 2016-04-18 10:03 | NaroaIriarte | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/e3137a29c326ac8a4c4b5c3a0a5ad68e9e43bd3a [^] |
| 2016-04-18 10:03 | NaroaIriarte | Resolution | open => fixed |
| 2016-04-18 11:14 | alostale | Note Added: 0085693 | |
| 2016-04-18 11:14 | alostale | Status | resolved => closed |
| 2016-04-18 11:14 | alostale | Fixed in Version | => 3.0PR16Q3 |
| 2016-06-17 19:36 | hudsonbot | Checkin | |
| 2016-06-17 19:36 | hudsonbot | Note Added: 0087445 | |
| 2017-11-28 11:02 | caristu | Relationship added | related to 0037079 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |