|
Donato Dandreo
|
March 11, 2014 at 10:30 am
I am using the plugin that allows users to choose add on items which increase the price. When I export the data to excel, the column with the shirt size looks like this: XLÂ [Â +$20.00Â ]
Is there a way to make it so it exports clearer? Maybe just the size?
|
|
Lorenzo Orlando Caum
|
March 11, 2014 at 2:34 pm
Hi Donato,
Those characters should not be there. Could you let me know the version of Event Espresso that you are running on your site?
This information is available in WordPress admin –> Plugins. Then look for EE in the plugins list.
—
Lorenzo
|
|
Donato Dandreo
|
March 11, 2014 at 2:58 pm
Version 3.1.36.4.P
|
|
Dean
|
March 12, 2014 at 2:45 am
Hi,
Thanks for that, I can confirm I am seeing those too. I will raise a ticket to look into this.
|
|
Donato Dandreo
|
March 12, 2014 at 11:13 am
Thank you just let me know when there’s a solution.
|
|
Dean
|
March 13, 2014 at 1:50 am
Hi,
I’ll add a note to the file to update this thread once resolved.
|
|
Seth Shoultes
|
March 13, 2014 at 1:17 pm
Donato,
This hasn’t ever been reported before now. Can you please tell us what type of character encoding you are using when opening the file as well as what is used in your database?
|
|
Donato Dandreo
|
March 18, 2014 at 1:24 pm
Hello, not sure what you mean by encoding in the file when I open it? I just use excel. This is what I use for the field setting on the quesion:
S|20,M|20,L|20,XL|20,XXL|20
|
|
Dean
|
March 19, 2014 at 4:24 am
Seth, I have updated the ticket but from my testing, if the file is opened by default, Excel is opening it in Windows ANSI.
Manually opening the file and selecting UTF-8 (In excel it is open, select file, change File Origin to UTF-8, click finish) will result in the correct formatting.
Screenshot http://take.ms/19Q3G
There is no way that I know of to force Excel to automatically use UTF-8, so you may have to open the files via Excell rather than just doubleclick them.
|
