Odd characters in CSV output

brsnyder117's Avatar

brsnyder117

09 Dec, 2013 08:46 PM

See attachments. Subtask ">" character shows up as junk characters in Excel. I'm on Mac, Snow Leopard.

Thanks -- Barbara

  1. Support Staff 1 Posted by Niko on 10 Dec, 2013 11:54 AM

    Niko's Avatar

    Hi Barbara,

    I have investigated this issue, the problem is that Excel for Mac doesn't properly decode CSV files in the UTF-8 character encoding format.
    If you choose "Import..." -> "CSV file" within Excel and then select "Unicode 6.1 UTF-8" for the file origin, the ">" will get replaced by "__". Also, if you select "Unicode 6.1", the full task name will be displayed without a delimiter.

    Alternatively you can open the exported CSV files with Apple Numbers or Open Office without problems.

    Thank you,

  2. 2 Posted by wasted on 24 Dec, 2013 08:40 AM

    wasted's Avatar

    Niko,

    I'm faced with the same problem, but your solution is not good enough. I'm French, so the name of my tasks contains accents sometimes. Messing up the ">" is kind of OK, but messing up with accents is not. Excel for Mac not supporting UTF8 properly is a pain, but you won't get Microsoft to fix it. Your app should enable the user to pick the encoding for the exported file, like other timetracking apps.

    Another tidbit : I seem to remember that the character ">" you picked, while a valid UTF8 character, is not present on default Windows fonts, which would cause an issue if one tried to move a file from their Mac to a Windows computer.

    Cheers,
    David

  3. Support Staff 3 Posted by Niko on 25 Dec, 2013 11:43 AM

    Niko's Avatar

    Hi David,

    thanks for pointing out these problems. I'll make sure to fix them in the upcoming version of Timelime. Letting the user pick the encoding is a good suggestion!

    Thanks again,
    Niko

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Already uploaded files

  • Screen_Shot_2013-12-09_at_12.44.18_PM.png 131 KB
  • Screen_Shot_2013-12-09_at_12.45.17_PM.png 20.5 KB

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

17 Dec, 2018 03:04 PM
30 Nov, 2018 10:00 AM
19 Nov, 2018 01:16 PM
18 Nov, 2018 03:39 PM
15 Nov, 2018 04:35 PM