CVS Export from Events list error message in Excel for Mac

By /

Events Made Easy › Forums › Bug fixed or feature request implemented › CVS Export from Events list error message in Excel for Mac

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • Fri 22 Jan 2016 at 17:39 #55262
    Anonymous
    Inactive

    Hi, Franky.

    When I do a CSV export of one of my events from the Events > Edit page, it won’t open into Excel 2008 for Mac, and I suspect other Mac versions of Excel, too. The error message upon attempting to open the document into Excel is: “SYLK: File format is not valid”

    The problem is the first two characters in the document: “ID”. If these are changed to lowercase, the issue disappears.

    Here’s a web page on the topic: https://support.microsoft.com/en-us/kb/215591

    Regards,
    Jon

    Sat 23 Jan 2016 at 11:29 #55263
    Franky
    Keymaster

    Ok, got it. Could you try if this version of eme_people.php fixes it for you?

    http://plugins.svn.wordpress.org/events-made-easy/trunk/eme_people.php

    I changed the csv export function to enclose all fields all the time without exceptions, so the ID-problem should be solved.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)
  • The forum ‘Bug fixed or feature request implemented’ is closed to new topics and replies.
Scroll to Top