Issues with time format and description field in CSV export

[DaMa]

Hello,

today we found, that there's are two (maybe three) issues with CSV export

1. The format of the begin time is wrong. E.g. begin time of 17:35 is exported as 17::3
2. if the description field contains carriage returns, they are exported but should be stripped. A CRs in a CSV causes a new record.
3. Maybe it's a problem of timetracker. German Umlauts are not exported correctly. See example Rückfahrt should be Rückfahrt.

CSV export example:

Code: Select all

2012-04-10,"Huber Sebastian","BDE-Client","Anfahrtszeit","17::3","18:00","0.50","Rückfahrt"   
2012-04-11,"Belsinger Martin","BDE-Client","Projektleitung","9::00","10:00","1.00","Besprechung mit Kunden"   


The CR issue is not shown in the example.

The environement
Server:
Apache/2.2.9 (Debian)
PHP 5.2.6-1+lenny16
mysql Ver 14.12 Distrib 5.0.51a
locale LANG=de_DE.UTF-8

[Nik]

I believe that the 1st item in the list (double colons) has been fixed recently.

Re: item 3 (German characters). Is your database created with UTF8 character set?

[DaMa]

Hello Nik,

I updated to v1.4.18.1587 today. This is the version that was offered for the download today.

issue 1 is still present in XML export but works in CSV export now.

issue 2 is still present

issue 3 was Excel specific. The database is in UTF-8 format and the exported file is UTF-8 too, but Excel's standard import format is Windows (ANSI). One can switch it to UTF-8 whem importing manualy.

Greets!

[Nik]

The problem #1 (duplicate colons in XML reports) should now be addressed in version 1.4.19.1588.

Hope it helps,

Nik

[Nik]

I tried to look at problem #2 (embedded carriage returns in CSV report exports) but currently do not see one.

Notes with carriage returns are exported as quoted fields, which seems to be the right way according to this discussion.

Import to an Excel document worked for me, no new records are created because of embedded CRLFs. The field with a comment is populated correctly.

Am I missing something?

Nik