Analyse Data from Event Registrations by Category

Put the query you want into Default Values setting

Haven't tested but Maybe something like would help:

SELECT name as value, name as text FROM #__eb_categories

But this is just a workaround. Why you allow users to choose categories of the event themself? Seems strange to me, but it's up to you

Tuan

Hi Tuan,
We have 5 categories of events. Each event we run is allocated to one of the 5 categories we run around 15 events per day.
I just want to create a workaround so we can analyse the registrations in a spread sheet
The fields in the export file are like this currently 
ID    Event    Event Date    User ID    Type    Organisation    First Name    Last Name    Mobile    Email    #Registrants    Amount    Discount Amount    Late Fee Amount    Tax Amount    Gross Amount    Registration Date    Ticket Number    Ticket Code    Transaction ID    Payment Status    Checked In    Checked In Time    Checked Out Time
We can summarise the data by EVENT, but if we had CATEGORY in the export we could summarise the data by Category so that we would get summarised data by for example
CAT A -All events in CAT A
CAT B -All events in CAT B
CAT C -All events in CATC
CAT D -All events in CAT D
CAT E -All events in CAT  E
So I just want to get the EVENT CATEGORY from the EVENT table and drop into a CUSTOM FIELD that would then have it in the registration files
So the code would be something like EVENTCATAGORY = CATAGORY 
our registration file would then look something like this
ID    Event    EVENTCATAGORY Event Date    User ID    Type    Organisation    First Name    Last Name    Mobile    Email    #Registrants    Amount    Discount Amount    Late Fee Amount    Tax Amount    Gross Amount    Registration Date    Ticket Number    Ticket Code    Transaction ID    Payment Status    Checked In    Checked In Time    Checked Out Time



 

Hi David

I would customize the code to have category data exported instead of asking user choose a category from custom field like that. But it's up to you to choose the way which works for your need

Regards,

Tuan

Hi Tuan,
I completely agree, I DO NOT want the User add/changing the CATEGORY.
All I was thinking was that we could add the category to the registrants records via the custom field and some SQL that is executed when the user books an event.
Can you tell me where the code is in EB which creates the registrants records. Perhaps we could look at putting on change/override in our system. 
I do understand the risks. 
It maybe better to continue this via a Support Ticket.
David
 

Hi Tuan,
I have just seen that new version of EB is out 3.5.12 
One of the improvements is 
4. Improve Export Registrants
There are two new config options to allow you to export event category or username of registrants.
This is exactly what I want!!!!
David 
 

Hi David

You can access to My Downloads menu item, download latest version of Events Booking (version 3.15.2) and update it to your site

Then go to Events Booking -> Configuration, look at Export Registrants Setting tab, set Export Category config option to Yes and category should be exported

Tuan

@David Unwin You are lucky to be my customer, lol.