|
Alexander Schmidt
|
January 22, 2014 at 12:45 pm
Hi,
When exporting the list of attendees the excel file uses weird characters instead of ‘æ’ ‘ø’ ‘å’. As my site and all attendees are from Denmark, where we use these letters alot, this is a huge problem. How can i fix it?
PS. Is there anyway to leave out some of the information, that comes with the file? For example seat tag. And can i change the order it’s in, so that name comes first?
Thanks a lot!
|
|
Sidney Harrell
|
January 22, 2014 at 2:41 pm
I just tested this out, and it looks like the characters are correct in the actual text file. When I first tried to open it in my spreadsheet program, the characters were wrong. I tried to open it again and specified the character set as ‘UTF-8’, and the characters displayed correctly.
The exporting is controlled by two functions in includes/functions/export.php. The first function deals with exporting events and the second with attendees. Both are overrideable functions, so you can copy them and modify them. You can add this code to one of the following:
1 – Your theme’s functions.php file. It may get overwritten the next time you update your theme.
2 – The EE custom files add-on in the custom_functions.php file.
3 – Use this blank plugin to hold the custom function.
|
|
Alexander Schmidt
|
January 22, 2014 at 3:04 pm
Hi,
I’ve changed my encoding in settings to UTF-8, but it still shows uncorrectly. How did you change yours? Please note that i am using Mac.
Another thing, that i can hopefully explain:
When people register they write a name of the boat they will be using at my event.
It is possible to register more attendees at once, but the boat name only registers with the primary attendees. This mean that when i filter in excel, and sorts the attendees after boat name, the additional attendees are not sorted correctly. Can i make the boat name field, a field that counts for all attendees at one registration?
Thanks a lot
|
|
Sidney Harrell
|
January 22, 2014 at 5:14 pm
When I go to import the spreadsheet file into LibreOffice, it asks which encoding and language the file is in. I would guess that your spreadsheet has a similar interface when you go to open the file. If you are using excel, then this may help: http://superuser.com/questions/280603/how-to-set-character-encoding-when-opening-excel<br>
It sounds like you would need some custom coding work done on the export functions. We can recommend one of our pros: https://eventespresso.com/developers/event-espresso-pros/. Another solution would be to run a custom function to:<br>
Grab a list of all the primary attendees.<br>
Foreach primary attendee, grab their answer to question number 37 (for example) and a list of all additional attendees for that primary attendee.<br>
Foreach additional attendee, if they don’t have an answer for question 37, add an entry in the answers table with the same answer as the primary attendee.<br>
A custom function like that is easier to code for the specific situation (you know what the question id is) and doesn’t require coding any user interface. That makes it a lot cheaper solution for you. The code can be added to this blank plugin to hold the custom function, and you whenever you want to do your export, activate the custom plugin, and then deactivate it, so that function isn’t running on every page load.
|
|
Alexander Schmidt
|
January 23, 2014 at 4:01 am
Hi again,
Thank you!
What’s the cheapest way to make it work? The most important thing is, that i can sort attendees after boat name, both if i they have or haven’t registered together.
Could you simply make a ‘shared’ field, in the start, that counts for all attendees within one registration?
Thanks.
|
|
Alexander Schmidt
|
January 23, 2014 at 7:45 am
Or could I simply make the field under additional attendees too, and then pre-populate it with what the primary attendee wrote?
|
|
Tony
|
January 24, 2014 at 4:06 am
Hi Alex,
You could add the question to the Personal Information Group and set it to required. Then require personal information for addition attendees within the event settings.
However if you are not use Multi Event Registration (MER) then you would need to input all the additional attendee info for each attendee http://d.pr/i/UpBR (each additional attendee would need those fields to be entered manually)
If you are use MER you could then add the event to the cart, select the number of tickets, fill in the Primary attendee info (which would then include Boat name) and then use the Copy info feature we have with MER to copy that to all the attendees within that registration. http://d.pr/i/ldtS (clicking the green ‘YES’ button copies all the information from the Primary attendee, to all the attendees)
It can be slightly confusing for users, so may not be suitable, but thought I’d post it as an option.
|
