I have an error on exporting data in csv.

My data has special characters like ñ or é, á .. I have been able to create a report of this data, and when I export it in csv I can see correctly, but when I open this file for example in Excel, the word that has those special characters appears in this way 'Monografía'.. The database is in collation utf8_general_ci.

Also, the data exported in csv is separated by a comma , and I need it separated by a semicolon ; Could be possible to configure this in the module?

Thanks in advance

Comments

ariane created an issue. See original summary.

metzlerd’s picture

I don't know that I can consider this a bug. The problem is that there is no method to to determine character set for a CSV file. Microsoft products don't support UTF-8 data which is what the server is. I've tried several methods for character set conversion, but none of them have been reliable. I'm open to ideas and patches here, but I haven't figured out a reliable solution.

metzlerd’s picture

With regard to the second option. I'm open to patches on that.