WordPress.org

Support

Support » Plugins and Hacks » [Users to CSV] Failing to open the CSV file

[Users to CSV] Failing to open the CSV file

Viewing 4 replies - 1 through 4 (of 4 total)
  • The plugin is creating the csv with a semi-colon instead of a comma.

    Edit line 37 of the plugin:

    function arrayToCsvString($array, $separator=’,’, $trim=’both’, $removeEmptyLines=TRUE) {

    Hi,

    I edited that line of code, and can open it with a basic text-editor, but not with Excel 2008. Is there a reason for that and is it important?

    Thanks

    Not sure if it’s a good idea to use a comma instead of a semi-colon as a separator. It depends on the data though I guess. Most of my data have sentences which *have* commas but not necessarily semi-colons, so the colon seems ideal.

    If possible could maybe use ‘|’?

    Using version 1.4 and here are the places I had to modify:

    1. Line 56 (which evilzenscientist referred to line 37), same modification. Although only changing it doesn’t fix the “;” problem, so following is the next.

    2. Line 194 change $sep = “;”; to $sep = “,”;

    3. Then there was a problem with MS Excel that reported something like:

    “Excel has detected that the ‘MyOutput.csv’ is a SYLK file, but cannot load it. Either the file has errorsa or it is not a SYLK file. Click OK to try to openn the file in a different format.”

    To fix it I had to replace all the instance of ‘ID’ to ‘USERID’, that solved all the issues.

    So far so good. I will report more changes if there is any.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Users to CSV] Failing to open the CSV file’ is closed to new replies.
Skip to toolbar