|
QJ Hawk
|
January 20, 2014 at 8:37 pm
I would like to have a sortable attendee list which updates
dynamically
as guests sign up for our event.
I also want to be able to show a short list of recent attendees on the front page sidebar..
I have looked through the forums, please let me know you have specific shortcodes I can embed..
Latest WP version, etc..
|
|
Dean
|
January 21, 2014 at 5:03 am
Hi,
We do have a shortcode called LISTATTENDEES, which with the event_identifier parameter will list the attendees for that event.
It will update dynamically (on page refresh) but it does have one limitation, it is in last name order only.
It does allow limitation so could be used in a sidebar (your theme will require one line of additional code if it does not already support shortcodes in widgets.
|
|
QJ Hawk
|
January 22, 2014 at 10:20 am
Dean,
Appreciate the response..
The sortability is a big deal – we are registering alumni of a college, and people will want to sort using year of graduation or department…!
Currently I am exporting to excel and using another plug in to provide a sortable list, but it is a manual process..
Any suggestions?
QJ
|
|
Sidney Harrell
|
January 22, 2014 at 6:21 pm
The function that produces the list is overrideable, so you can make a copy of it and modify it. What would you want it to sort by? Looking at the code, it looks like the limit in the shortcode attribute applies to the number of events that are retrieved (if you use an event category, for example), but that it retrieves all the attendees in those events. If you want to alter that behavior, it would again involve copying and modifying a function. But those easy one or two line modifications are something that we are happy to help you with here in the forums.
(boilerplate for placing custom code to override a function:)
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.
|
|
QJ Hawk
|
January 23, 2014 at 2:01 pm
Thank you Sidney, appreciate the update..
Please check this out http://www.nitkan.org/registration/attendee-list/?preview=true&preview_id=234&preview_nonce=d792bb2e8c
I generate this by doing the following:
1. Export excel from the current event plugin
2. Delete all fields I don’t wish to display
3. Save as CSV
4. FTP into my server, upload file
I have set up Csv To SortTable plugin, which then generates the completely sortable list you see.
This is a pain in the but, not to mention inefficient. People don’t see themselves on the list till I do the update.
What I would like is to be able to use a short code with attributes as to which fields I want to display (Name, City, Year of Graduation, Degree) and let people use that to focus in on what they are interested in..
Please let me know what you think!
Regards,
QJ
|
|
Sidney Harrell
|
January 23, 2014 at 9:49 pm
Code: https://gist.github.com/sidharrell/8592212
and example: http://eetesting.info/EE_branch/?page_id=45
It probably needs some CSS love.
|
|
QJ Hawk
|
January 24, 2014 at 6:22 pm
Sidney,
Thank you for the code – let me see if I can get a friend to help, as I am kind of ignorant on how exactly to make this work in my site..
Will get back,
Thanks again,
QJ
|
|
Sidney Harrell
|
January 24, 2014 at 6:58 pm
You’ll want to copy the file that is already on your site in plugins/event-espresso/templates/attendee_list.php over to uploads/espresso/templates. Then replace the code that is currently in there with the code from the gist. Copy sorttable.min.js from plugins/csv-to-sorttable/js to uploads/espresso and point line 47 of my code to it. I just realized I could have used the code that is there and commented out on lines 97 and 98 instead of modifying the query like I did on lines 75-78 to get the answers to your custom questions. Sorry about that.
|
