Why cancelled registrants are exported?

More
4 years 10 months ago #135350 by GED
When I export a list with registrants also the persons who had cancelled are existing on this list.

I can't find any button or something else...

Thanks for helping...

Regards
GED

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

More
4 years 10 months ago #135380 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Why cancelled registrants are exported?
Hi GED

By default, the system export all registrants. If you don't want to export cancelled registrants, please :

1. Go to Events Booking -> Registrants

2. In the Status filter dropdown, choose Paid

3. Press Export Registrants button in the toolbar to export registrants with Paid status only

Do the same steps above with Pending status to export Pending registrants

Then you will have two export files with different status (Paid/Pending) and without Cancelled Registrants

Tuan

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

More
3 years 1 month ago #150427 by Manfred Lilge
Replied by Manfred Lilge on topic Why cancelled registrants are exported?
Hi,

Is there an option to have filters configured for exports triggered on the front-end?

Optionally, which php-file would I need to customize to hard code a paid-status filter?

Thanks,
Manfred

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

More
3 years 1 month ago #150442 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Why cancelled registrants are exported?
Hello Manfred

From Registrants Management screen, you can choose Paid status from status filter dropdown before pressing Export button and only paid registrants will be exported

If you still want to modify code, the file components/com_eventbooking/controller/registrant.php , method export

The original code is:
Code:
$model->setState('filter_event_id', $eventId) ->setState('limitstart', 0) ->setState('limit', 0) ->setState('filter_order', 'tbl.id') ->setState('filter_order_Dir', 'ASC');

Change it to:
Code:
$model->setState('filter_event_id', $eventId) ->setState('filter_published', 1) ->setState('limitstart', 0) ->setState('limit', 0) ->setState('filter_order', 'tbl.id') ->setState('filter_order_Dir', 'ASC');

And it should work OK

Regards,

Tuan

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

More
3 years 1 month ago #150476 by Manfred Lilge
Replied by Manfred Lilge on topic Why cancelled registrants are exported?
Thanks, Tuan!

The issue is that the Registrants Management Screen won't pop up if one triggers the export through the "Export Registrants" menu item or the "Export Registrants" button in the event details view.

Hence, my question for customizing the code.

Will check the file as suggested.

/Manfred

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

More
3 years 1 month ago #150490 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Why cancelled registrants are exported?
Ah, I see. For this, you can try to get this file, unzip it, upload to components/com_eventbooking/controller/override folder , then check it again to see if it works (I haven't tested it, just wrote the code quickly to have it overridden - it won't be lost when you update Events Booking in the future

Tuan
Attachments:

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

Moderators: Tuan Pham Ngoc