Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018060Openbravo ERPA. Platformpublic2011-07-22 09:442011-08-05 15:32
Reportermarvintm 
Assigned Tomarvintm 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP2Fixed 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
Summary0018060: DateTime columns do not work with the Export CSV functionality
DescriptionThe Export CSV functionality crashes when there is at least one column of reference DateTime. When activated, it fails with this exception:

Error while exporting CSV information
java.text.ParseException: Unparseable date: "2010-11-24T00:00:00+01:00"
    at java.text.DateFormat.parse(DateFormat.java:337)
    at org.openbravo.service.datasource.DataSourceServlet$QueryJSONWriterToCSV.write(DataSourceServlet.java:487)
    at org.openbravo.service.json.DefaultJsonDataService.fetch(DefaultJsonDataService.java:188)
    at org.openbravo.service.datasource.DefaultDataSourceService.fetch(DefaultDataSourceService.java:67)
    at org.openbravo.service.datasource.DataSourceServlet.doFetch(DataSourceServlet.java:215)
    at org.openbravo.service.datasource.DataSourceServlet.doPost(DataSourceServlet.java:543)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
Steps To Reproduce- In Sales Order window, go to grid mode.
- Set the "Creation date" column as shown in the grid.
- Export CSV. The mentioned exception will be raised.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-07-22 09:44marvintmNew Issue
2011-07-22 09:44marvintmAssigned To => marvintm
2011-07-22 09:44marvintmModules => Core
2011-07-27 10:46hgbotCheckin
2011-07-27 10:46hgbotNote Added: 0039427
2011-07-27 10:46hgbotStatusnew => resolved
2011-07-27 10:46hgbotResolutionopen => fixed
2011-07-27 10:46hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/111e6fc5762cbcfefa0e1b37a8396b1fc6e0fe43 [^]
2011-08-01 14:21hudsonbotCheckin
2011-08-01 14:21hudsonbotNote Added: 0039702
2011-08-05 15:32shuehnerNote Added: 0039911
2011-08-05 15:32shuehnerStatusresolved => closed

Notes
(0039427)
hgbot   
2011-07-27 10:46   
Repository: erp/devel/pi
Changeset: 111e6fc5762cbcfefa0e1b37a8396b1fc6e0fe43
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Jul 27 10:45:34 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/111e6fc5762cbcfefa0e1b37a8396b1fc6e0fe43 [^]

Fixed issue 18060. DateTime columns will be correctly exported to CSV

---
M modules/org.openbravo.service.datasource/src/org/openbravo/service/datasource/DataSourceServlet.java
---
(0039702)
hudsonbot   
2011-08-01 14:21   
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/cf2afed6e8ef [^]

Maturity status: Test
(0039911)
shuehner   
2011-08-05 15:32   
Reviewed/tested in pi/pgsql (rev id: 7e1aea78244f). CSV export of timestamp columns like 'creation date' now doesn't crash and exports the timestamp values as expected.