Anyone? This is an issue for our client who is not very computer savy.
This was a few weeks ago, but I had the same trouble. I fixed some lines of code in the plugin to work for me. I can’t guarantee i will work for you.
In short,
I changed the header to be text/csv
I removed the line that encoded the file as UTF-16LE
I made the file COMMA delimited, not Tab. Since it’s a COMMA Separated
Values file.
line 36 in getcsv.php:
header(“Content-type: text/csv”); //change application to text
line 1039 in db.php:
fputcsv($fp, $csvRow); //remove the chr(9)
line 1058: in db.php
comment out the line like this
//$str = chr(255).chr(254).mb_convert_encoding( $str, ‘UTF-16LE’, ‘UTF-8’);
It still opens in Excel.
THANK YOU! That worked perfectly. Developers please make this change in your next update
@eeidsness, Excel 07 and 10 will not open files containing international characters properly if generated as suggested above (they need the line that converts the encoding). This StackOverflow thread explains why I did what I did, though there are many options that might be more portable.
@cpaprotna, If you could tell me exactly what version of Excel and OS you are using, I could try to recreate the problem. The generated files were designed to open properly by ‘double click’ rather than importing… I just assumed a naive user would do it this way, so I tried to make it easy for them.
I’m not sure what operating system and version of excel my client is using, but I replicated this very easily with Chrome, Windows 7 and Excel 2007. T The file was opened via a double click.
For me, the fix above is better than accounting for international characters. The site will not have too many international characters.