can I know what translation method are you using? however maybe you can try to add this in your theme functions.php
function my_em_csv_header_output(){
echo "\xEF\xBB\xBF"; // UTF-8
}
add_action('em_csv_header_output','my_em_csv_header_output');
Hi
Well, the site is in Swedish, I use Codestyling Localization to translate certain theme specific words like “Read more” – but how would that impact the CSV export of booings in Events Manager?
I will try the code you gave – but right now I’m having trouble creating a working child theme…
I think Angelo was wondering if the information in the csv file has been translated but it sounds as if your site is only in Swedish.
I think this might be partly an encoding issue. Is your admin area running in Swedish?
Is there an option to change the encoding used in the app you’re viewing the csv file in? If there is, can you test with UTF-8 encoding?
I use Excel – and I don’t know anything about excel… so I don’t know how to change some setting to UTF-8 encoding..
sorry 🙁
Erle
(@erlewilliams)
I did a quick search on setting Excel to UTF-8. Check this article: http://stackoverflow.com/questions/6002256/is-it-possible-to-force-excel-recognize-utf-8-csv-files-automatically
The solution was to set the file orgin to “65001 : Unicode (UTF-8)” during the import process.
I’ve also seen this happen if the delimiter is not set properly during the import process. So if the values are comma delimited be sure to choose comma delimited when importing.
Hope that helps.
Okay, that got it to work. But it would be easier if the file exported from Events Manager where of the sort to behave like this automatically, some how… is that possible?
….also, the changes I made to what columns to include (and to exclude), are still not showing. So this is still left to solve…
@erlewilliams Thanks – that’s really helpful.
@niwin I think the delimiting character may be the cause of your columns problem.
When you first open the file, are you given a choice of which separator character to use? If you choose a different character does it help?
It might also help to experiment with the text delimiter options.
At this stage, it sounds to me more like this is an issue with Excel and Swedish, rather than Events Manager and Swedish.
Yes, you’re probably right about the Swedish thing. But why does my changes to the fields not show on the file?
Also – wouldn’t it be nice if there where some setting for what type of CSV that the plugin would export? So I could choose some version that is compatible with my spreadsheet program?
BTW – this is how the file looks like in Finders Preview:
http://cl.ly/image/2z3a0X032p1g
So the file itself is good – its just excel that cant open it properly (MS junkware)
Also – just tried opening the file in Numbers. No problem there.
….just noticed that my changes to the fields DOES show. So scratch that last question.
Thanks for your help!
