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.