Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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.