Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0044683Openbravo ERP01. General setuppublic2020-07-20 14:362020-07-27 10:26
Reportera_singh 
Assigned Tocberner 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version3.0PR19Q4.4 
Target VersionPR20Q1.3Fixed in VersionPR20Q1.3 
Merge Request Status
Review Assigned Toalostale
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression levelProduction - Confirmed Stable
Regression date2019-09-23
Regression introduced in release3.0PR19Q4
Regression introduced by commithttps://gitlab.com/openbravo/product/openbravo/-/commit/4ec715bfa9c6bc0ab7b3e6f644ec05ef4998c721 [^]
Triggers an Emergency PackNo
Summary0044683: Exported grid csv with enabled creation date column value does not match in the application
DescriptionIn 19Q4.4, despite the preference Local Timezone ID defined, when the user tries to export any of the window grid with enabled Creation Date column.The creation date value exported in the csv file does not matches in the grid.
Steps To ReproduceFollowing steps to be followed:

1. Log in the backoffice as Openbravo/openbravo

2. Go to the Preference window
   a.Preference Property: Local Timezone ID
   b.Property List: Yes
   c.Selected: No
   d.Value: America/New_York

3. From any window grid, enable the Creation Date column and click on the Export to csv toolbar button.

4. The expected value is Creation Date value should be in US Eastern Time Zone but the value is in UTC timezone.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
blocks defect 0044640 closed cberner Exported grid csv with enabled creation date column value does not match in the application 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2020-07-24 11:19cbernerTypedefect => backport
2020-07-24 11:19cbernerTarget Version => PR20Q1.4
2020-07-27 10:11cbernerWeb browserGoogle Chrome => Google Chrome
2020-07-27 10:11cbernerTarget VersionPR20Q1.4 => PR20Q1.3
2020-07-27 10:14hgbotNote Added: 0121614
2020-07-27 10:25cbernerReview Assigned To => alostale
2020-07-27 10:25cbernerWeb browserGoogle Chrome => Google Chrome
2020-07-27 10:26hgbotResolutionopen => fixed
2020-07-27 10:26hgbotStatusscheduled => closed
2020-07-27 10:26hgbotFixed in Version => PR20Q1.3
2020-07-27 10:26hgbotNote Added: 0121617
2020-07-27 10:26hgbotNote Added: 0121618

Notes
(0121614)
hgbot   
2020-07-27 10:14   
Merge Request created: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/109 [^]
(0121617)
hgbot   
2020-07-27 10:26   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/openbravo [^]
Changeset: 94c8bcdca89607f2bcb9fcd402a4a7ff2fea18be
Author: Cristian Berner <cristian.berner@openbravo.com>
Date: 2020-07-27T10:22:07+02:00
URL: https://gitlab.com/openbravo/product/openbravo/-/commit/94c8bcdca89607f2bcb9fcd402a4a7ff2fea18be [^]

Fixes ISSUE-44683: Sets correct DateTime in window grid exported CSV file

DateTime in export to CSV was wrong, applying local time zone several times instead of once.

It has been fixed by using a function that doesn't try to transform to
UTC in DateTimeUIDefinition, convertToClassicStringInLocalTime. This
function formats the date as is, using the timezone received without
prior conversion to UTC.

Fixes regression introduced in commit
4ec715bfa9c6bc0ab7b3e6f644ec05ef4998c721

---
M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/reference/DateTimeUIDefinition.java
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DataSourceServlet.java
---
(0121618)
hgbot   
2020-07-27 10:26   
Merge request merged: https://gitlab.com/openbravo/product/openbravo/-/merge_requests/109 [^]