Early Bird Registration for DrupalCon Portland 2024 is open! Register by 23:59 PST on 31 March 2024, to get $100 off your ticket.
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
Comment #2
metzlerd CreditAttribution: metzlerd commentedI 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.
Comment #3
metzlerd CreditAttribution: metzlerd commentedWith regard to the second option. I'm open to patches on that.