Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0018060
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2011-07-22 09:442011-08-05 15:32
ReportermarvintmView Statuspublic 
Assigned Tomarvintm 
PriorityhighResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision111e6fc5762c
ProjectionnoneETAnoneTarget Version3.0MP2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018060: 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.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0039427)
hgbot (developer)
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 (developer)
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 (administrator)
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.

- Issue History
Date Modified Username Field Change
2011-07-22 09:44 marvintm New Issue
2011-07-22 09:44 marvintm Assigned To => marvintm
2011-07-22 09:44 marvintm Modules => Core
2011-07-27 10:46 hgbot Checkin
2011-07-27 10:46 hgbot Note Added: 0039427
2011-07-27 10:46 hgbot Status new => resolved
2011-07-27 10:46 hgbot Resolution open => fixed
2011-07-27 10:46 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/111e6fc5762cbcfefa0e1b37a8396b1fc6e0fe43 [^]
2011-08-01 14:21 hudsonbot Checkin
2011-08-01 14:21 hudsonbot Note Added: 0039702
2011-08-05 15:32 shuehner Note Added: 0039911
2011-08-05 15:32 shuehner Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker