Reporting across events

[Michael]

We have many events that all share the same fields, including “additional Fields’ for personal info. Is there a way to run a report that combines results from all of these events into one table?

Alternatively, is there a way to set up events/”subevents” differently to achieve this goal?

thanks in advance,
Mike

[George]

Hey Mike,

Thanks for reaching out.

Unfortunately the answer is generally “No” to both of your queries 🙁 Sorry to disappoint!

All event data does reside in your database, though. So you could totally write—or have someone else write—custom SQL queries that grabbed data from a whole range of events you specify.

Our plugins don’t provide this out of the box, unfortunately, but the data is all there in MySQL and so that provides a number of options you can tinker with or have someone else tinker with.

Please let me know if there are any other issues or questions I can try to help with!

— George

[Michael]

Thanks, George – It looks to me like each ticket submission is stored as an array (XML?) within a single field. Is that correct? So the task would be to pull all of those records, then manipulate the XML. Is this the right track?

If so, this seems like a great way to do it. I have run into problems with Ninja Forms where every field in a form is a record in the database. Ran up against a 75K limit on number of records imposed (I guess) by GoDaddy.

[George]

Hey Michael,

Each ticket’s “Attendee Information” is stored in the wp_postmeta Database table. Each “set” of attendee meta is indeed stored as an array within a single field. It is not XML, it’s a serialized array. You can learn about serializing and unserializing here: http://us2.php.net/serialize

I hope this helps!

Best of luck with your custom queries,
George

[Support Droid]

Hey there! This thread has been pretty quiet for the last three weeks, so we’re going to go ahead and close it to avoid confusion with other topics. If you’re still looking for help with this, please do open a new thread, reference this one and we’d be more than happy to continue the conversation over there.

Thanks so much!
The Events Calendar Support Team

[Author]

Posts