Support

Home Forums Custom Files Add-on (EE3) Adding a new column to Attendee Report screen

Adding a new column to Attendee Report screen

Posted: October 17, 2012 at 2:21 pm

Viewing 6 reply threads


Alexander Puente

October 17, 2012 at 2:21 pm

Hi Everyone!

Basically I created an event, I added an “age” question to the registration page, and I had some people sign up. Is there an easy way that I can go into the programming and have event espresso give me the option to add the “age” column (or any of the other questions i added) to the attendee overview screen?

🙂


Jonathan Wilson

October 17, 2012 at 2:38 pm

Hello Alexander,

At this time there isn’t an option to do this. I think it is a great idea. I will add it to our features request list so our developers can take a look.


Alexander Puente

October 17, 2012 at 2:43 pm

Thanks Jonathan! You think there’s a way of hacking into it (for the time being) and make it do it?


Jonathan Wilson

October 17, 2012 at 2:59 pm

I will ask our developers and get back to you.


Chris Reynolds

  • Support Staff

October 17, 2012 at 3:57 pm

The problem with this is that it’s much more complicated than what you probably think.

Custom questions are stored in wp_events_question. The answers to those questions are stored in wp_events_answer. Those are two new tables that we’d need to pull in that aren’t being called on the attendee list page yet. Then to figure out which questions are actually being used on any given event (to prevent every single question ever created from being displayed on the attendee list), you’d need to call in wp_events_detail to get the question groups id, then wp_events_qst_group_rel to figure out which questions are assigned to which groups. That’s 4 separate tables in the database and we haven’t even loaded a single attendee yet. Right now, the attendee list uses one: wp_events_attendee.

So, can it be done? Sure. Should it be done? No, probably not.

There’s a lot of room for improvement in our database tables and we’re working on reducing the number of tables Event Espresso uses. In theory, this is something that should be possible in the future but it’s not realistically feasible right now. (Saying this, I realize there are hacks that could be done — you could load all the questions and hide them with the show/hide columns filter, but you’d still be pulling in at least 2 new potentially very large database tables into an otherwise relatively simple database query. This type of SQL query could easily cause your server to break under the strain if you had a lot of events, a lot of attendees, a lot of questions or all of the above.)


girlsrockcampaignboston

October 18, 2012 at 8:00 am

We really need this option also, so while I understand the complexity, it would be excellent for admins to be able to see a custom column or two in the tables. It would save a lot of time and make the process of organizing attendees much cleaner.


Josh

  • Support Staff

October 18, 2012 at 10:05 am

Hi there,

If you really need this option, you might consider hiring a developer to customize the software to fit your specific needs and maintain these changes. We’re not in a position to add this feature any time soon, and one of the constraints that we have to work with is that a majority of our customers are installing WordPress and Event Espresso on cheaper shared hosting. The reality is if we add this feature right now, it could make for a difficult situation for many of our customers who may be limited budget wise and can’t upgrade to server hardware that can handle the load this would add. As Chris explained in the above reply, we need to reduce the overhead it takes to load up the attendee list on the admin side before we can add features that will add overhead.

Viewing 6 reply threads

The support post ‘Adding a new column to Attendee Report screen’ is closed to new replies.

Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.

Event Espresso