I'm using Views Data Export to generate CSV files for end-users to use and then re-upload using Feeds. I need Vietnamese characters like
â ỏ ể to be converted to
a o e before export as these are in users' names.
utf8_decode in Views Data Export settings but it doesn't work for all characters and
even then, changing Feeds to use
ISO-8859-1 still results in a "This isn't a UTF-8 file" error.
It seems that changing a setting in Excel can fix this but that isn't an option for me for usability reasons. I'm not the one who will be using these CSV files so I need these names to be exported properly.