Issues with time format and description field in CSV export

Discussion forum about Anuko Time Tracker

Issues with time format and description field in CSV export

Postby 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
DaMa
 
Posts: 9
Joined: Thu Mar 29, 2012 12:19 am

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

Postby 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.
Nik
 
Posts: 247
Joined: Wed May 26, 2010 5:55 pm

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

Postby 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!
DaMa
 
Posts: 9
Joined: Thu Mar 29, 2012 12:19 am

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

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

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

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


Return to Time Tracker

Who is online

Users browsing this forum: Bing [Bot] and 2 guests

cron