Issues with time format and description field in CSV export

Discussion forum about Anuko Time Tracker
Post Reply
DaMa
Posts: 9
Joined: Thu Mar 29, 2012 12:19 am

Issues with time format and description field in CSV export

Post by DaMa » Wed May 02, 2012 11:28 pm

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
Posts: 426
Joined: Wed May 26, 2010 5:55 pm

Re: Issues with time format and description field in CSV exp

Post by Nik » Thu May 03, 2012 2:03 am

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?
Last edited by Nik on Sat May 05, 2012 5:35 pm, edited 1 time in total.

DaMa
Posts: 9
Joined: Thu Mar 29, 2012 12:19 am

Re: Issues with time format and description field in CSV exp

Post by DaMa » Thu May 03, 2012 9:03 pm

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
Posts: 426
Joined: Wed May 26, 2010 5:55 pm

Re: Issues with time format and description field in CSV exp

Post by Nik » Sat May 05, 2012 5:37 pm

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

Hope it helps,

Nik

Nik
Posts: 426
Joined: Wed May 26, 2010 5:55 pm

Re: Issues with time format and description field in CSV exp

Post by Nik » Sun May 06, 2012 1:42 am

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

Post Reply