CSV IMPORTER 2.2 Important Bug

Dear Mark,

Thanks for updating the CSV importer this morning to version 2.2

Until this release, the CSV Importer had serious problems dealing with UTF8 special characters such as á é €, a serious problem for all your many european customers who use premiumpress.

As of 2.2, which I have tested this morning, if you give the CSV importer a UTF8 CSV file (by saving CSV in excel and then converting it with notepad ++ from Excel default cp1252 to UTF8) it correctly handles special characters. ALLELULIA!

However there still remains a serious bug which restricts the usefulness of the importer.

I include these files for Mark Fail to test out but forum members can also give it a go. My wordpress database is UTF8 standard collation which is the default.

EXCEL can only save CSV files as CP1252 (system default for western euro and USA pcs).

If we try to import the CP1252 csv file (selecting cp1252 in the dropdown) it correctly previews the special characters, but when they are imported into the database, the entire field where the special characters are is replaced with “?”

Please see the screenshots for comparison and try to import the “testexcel.csv” which is cp1252

For comparison I have also included testexcelutf8bom which is the same excel sheet converted to utf8 with notepad ++.

This bug should be fixed as 99% of customers will try to import to couponpress etc straight from excel and hence cp1252.

https://skydrive.live.com/redir?resid=CFFF3A158F1DE2AE!925&authkey=!ABgAxqNx5Q3PQcQ&ithint=file%2c.rar