Export registrants, include Event ID?

  • Finn Christensen
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
6 years 11 months ago #115487 by Finn Christensen
Export registrants, include Event ID? was created by Finn Christensen
When exporting registrants from Events Booking to Excel, is there a way I can have it to include the Event ID and not only the title of the event? (many of our events have the exact same "title", but I need to be able to make Excel files where the Event ID is also on the lists...…. I hope this can be done :)


Thanks
Finn

Please Log in or Create an account to join the conversation.

More
6 years 11 months ago #115497 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Export registrants, include Event ID?
Hi Finn

We don't have option to include Event ID in the export. Maybe event date should be enough? You can go to Events Booking -> Configuration, look at Themes tab, set Show event date config option to Yes

After that, try again. The system will include event date in the export and it might solve your concern

Tuan

Please Log in or Create an account to join the conversation.

  • Finn Christensen
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
6 years 11 months ago #115570 by Finn Christensen
Replied by Finn Christensen on topic Export registrants, include Event ID?
Hello
No, unfortunately we have several events, each with a unique event id, on the same dates...… that is why it would be great to be able to see the event's id on the export of registrants :)

Could it be done as a customized job, and how much would you charge for it? :)

Thanks
Finn

Please Log in or Create an account to join the conversation.

More
6 years 11 months ago #115571 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Export registrants, include Event ID?
Hi Finn

You can try to get this file, unzip it, upload it to components/com_eventbooking/helper/override folder on your site, and check the result

It should work as expected

Regards,

Tuan
Attachments:

Please Log in or Create an account to join the conversation.

  • Finn Christensen
  • Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
6 years 11 months ago #115573 by Finn Christensen
Replied by Finn Christensen on topic Export registrants, include Event ID?
It worked :) :)

THANK YOU SO MUCH!!!!!!

THANKS! :)

Finn

Please Log in or Create an account to join the conversation.

More
6 years 11 months ago #115577 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Export registrants, include Event ID?
Great. Happy to hear that and thanks for confirming

Regards,

Tuan

Please Log in or Create an account to join the conversation.

More
6 years 11 months ago #116306 by Christoph
Replied by Christoph on topic include CUSTOM FIELDS to registrants export
Hello Tuan,

I need the custom field in the registrants export. I'm trying to figure out helper/data.php and learned from your override version how to add the event id but this does not work as easily for the custom fields.

Did find function prepareCustomFieldsData() but invoking it inside prepareRegistrantsExportData() does not work.

Could you please provide the code to be added to data.php to render custom field data in the registrants export?

Thank you,
Chris

Please Log in or Create an account to join the conversation.

More
6 years 11 months ago #116313 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic include CUSTOM FIELDS to registrants export
Hi Chris

I'm sorry but I could not provide that code. It will take sometime to try, modify code, check the result... to have it works. For this, you would need to try to do it yourself, maybe try to make it works without override first:

1. Modify the code to get registrants data to include custom_fields field in #__eb_events (at the moment, it is not included in $rows array)

2. Call prepareCustomFieldsData inside prepareRegistrantsExportData as you figured out

3. Modify $headers and $fields array to include title and name of these event custom fields

That's not a quick code which I can provide as part of support, sorry. So please try to do it yourself, it you cannot get it done, you will need to hire someone or hire us to do it for you. It will cost you about 30$ for doing this modification

Regards,

Tuan

Please Log in or Create an account to join the conversation.

Moderators: Tuan Pham Ngoc