#4807 closed defect (fixed)
Date fields formatting lost during export to csv
| Reported by: | Owned by: | Matthew Good | |
|---|---|---|---|
| Priority: | high | Milestone: | 0.11 |
| Component: | report system | Version: | 0.9.4 |
| Severity: | major | Keywords: | |
| Cc: | sverma@… | Branch: | |
| Release Notes: | |||
| API Changes: | |||
| Internal Changes: | |||
Description
At the bottom of each Report page, there are links to download the results in other formats, namely Comma- or Tab-delimited Text.
However, the files that are generated do not retain the original datetime formats for the Created and Modified columns and instead contain time integers.
Keeping the original date formats is useful, for example when imported into an excel sheet or other program where readable dates make more sense.
(Please fix before my project manager kills me)
Attachments (2)
Change History (12)
by , 18 years ago
| Attachment: | csvdate.patch added |
|---|
comment:2 by , 18 years ago
| Version: | → 0.9.4 |
|---|
I am using version 0.9.4 and the patch doesn't seem to help. Do you have a patch available for my version?
comment:3 by , 18 years ago
| Milestone: | → 0.11 |
|---|
There are no planned enhancements for 0.9 at this point, even none for 0.10 and actually, we could start to think about postponing new enhancements for 0.11 as well ;-)
comment:4 by , 18 years ago
| Resolution: | → fixed |
|---|---|
| Status: | new → closed |
This is implemented by r4846. ISO dates and times are used to enable better parsing than the locale-based representation used in the HTML.
by , 17 years ago
| Attachment: | trac-0.10.4_t4807_cvsdate.patch added |
|---|
Convert date & time values in CSV/TAB files (Patch Against 0.10.4)
follow-up: 7 comment:6 by , 16 years ago
| Cc: | added |
|---|---|
| Resolution: | fixed |
| Status: | closed → reopened |
Reopening as I feel the problem belonging to this category. When i export to csv using the "Download in other formats" date changes from for example 09/04/08 to 1220556898 . Why is this taking place and what can i do to avoid it . Our system is unable to find no corelation between the two. Please advise.
comment:7 by , 16 years ago
| Resolution: | → fixed |
|---|---|
| Status: | reopened → closed |
Replying to sverma@…:
… When i export to csv using the "Download in other formats" date changes from for example 09/04/08 to 1220556898 . Please advise.
If you're using Trac 0.10.x, upgrade to 0.11.1 or later, or apply the attachment:trac-0.10.4_t4807_cvsdate.patch on your installation if you can't upgrade for some reason.
In any case, the issue has been fixed in r4847 (though izip was not such a good idea in retrospect ;-) ).
comment:8 by , 15 years ago
| Resolution: | fixed |
|---|---|
| Status: | closed → reopened |
| Version: | 0.9.4 → 0.11 |
When I export some report to csv, the date format is like this "2009-07-17 18:38:43+00:00". How can I export to this format: "2009-07-17 18:38:43"? (without "+00:00") Is this a bug of 0.11 ?
follow-up: 10 comment:9 by , 15 years ago
| Resolution: | → fixed |
|---|---|
| Status: | reopened → closed |
| Version: | 0.11 → 0.9.4 |
No, this is intentional because the formatting is always iso formatting. The rationale is summarized by comment 4.
comment:10 by , 15 years ago
Replying to Felix Schwarz <felix.schwarz@…>:
No, this is intentional because the formatting is always iso formatting. The rationale is summarized by comment 4.
Thank you. Is there a way to export to csv using the datetime format without "+00:00"? I'm trying to open csv files in excel, but excel isn't reconizing this format as a valid date.
Convert date & time values in CSV/TAB files