[Users to CSV] Failing to open the CSV file

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.