Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0039512Openbravo ERP02. Master data managementpublic2018-10-23 13:252018-10-26 10:38
ReporterJONHM 
Assigned Toplatform 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0039512: Some dates are exported wrong to spreadsheet
DescriptionSome dates are exported wrong to spreadsheet
Steps To ReproduceOpen [Sales Order] window
- Show 'Creation Date' column on grid view. This column has a "DD-MM-YYYY HH:MM:SS" format.
-Filter by some documentNo's which have this problem: '1000172 or 1000191 or 1000194' and press enter key
- Press the "export to spreadsheet" button on the toolbar

-- Some dates are exported with 1 more hour.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 00218103.0MP19 closed AugustoMauch The times are incorrectly exported when exporting the grid to csv 
Attached Filespng Screenshot from 2018-10-23 13-24-48.png (100,077) 2018-10-23 13:25
https://issues.openbravo.com/file_download.php?file_id=12302&type=bug
png

png Screenshot from 2018-10-23 13-25-10.png (51,806) 2018-10-23 13:26
https://issues.openbravo.com/file_download.php?file_id=12303&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2018-10-23 13:25JONHMNew Issue
2018-10-23 13:25JONHMAssigned To => Triage Finance
2018-10-23 13:25JONHMFile Added: Screenshot from 2018-10-23 13-24-48.png
2018-10-23 13:25JONHMModules => Core
2018-10-23 13:25JONHMResolution time => 1542063600
2018-10-23 13:25JONHMTriggers an Emergency Pack => No
2018-10-23 13:26JONHMFile Added: Screenshot from 2018-10-23 13-25-10.png
2018-10-25 11:24dmiguelezAssigned ToTriage Finance => platform
2018-10-26 10:37alostaleNote Added: 0107612
2018-10-26 10:37alostaleStatusnew => closed
2018-10-26 10:37alostaleResolutionopen => no change required
2018-10-26 10:38alostaleRelationship addedduplicate of 0021810

Notes
(0107612)
alostale   
2018-10-26 10:37   
Updated documentation [1]:
"By default, dates and times are exported in UTC. To set a different time zone, create a Local Timezone ID preference with a valid value from this list. This preference can be set at any visibility level from System to User, but not Window."

[1] http://wiki.openbravo.com/wiki/User_Interface_Introduction#Exporting_grid_content_to_a_spreadsheet [^]