Move Registrant from Waiting List into New Event

  • OTWD
  • Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
10 years 11 months ago - 10 years 11 months ago #61752 by OTWD
Hi
In version 1.7.0
If an event becomes fully booked and people are joining the waiting list we may decide to run a second event.
Is it possible to move those registrants from the waiting list into the new event?
Also does the "move registrant to waiting list" plugin work on paid events too considering people must now fully pay and register in order to join the waiting list?
Thanks

Success consists of going from failure to failure without loss of enthusiasm.
Last edit: 10 years 11 months ago by OTWD.

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

More
10 years 11 months ago #61763 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Move Registrant from Waiting List into New Event
Sorry but it is difficult to do that and we won't have support for it very soon

Tuan

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

More
10 years 11 months ago #61770 by James Riley
Replied by James Riley on topic Move Registrant from Waiting List into New Event
You should be able to do this manually using phpMyAdmin / HeidiSQL or whatever database manager you want.
Just edit the __eb_registrants table, and change the event_id for the registrants you want to move to the id of the new event. Just be careful when editing the DB directly as you can REALLY mess things up for EventBooking or your entire website if you make changes to something your shouldn't :whistle:

James Riley .: EventBooking user since 2014 ::: JoomDonation user since 2016 :.
.: grfx & web design / IT / AV @ St. Therese Institute of Faith and Mission, Bruno, SK, Canada :.

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

More
10 years 11 months ago #61771 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Move Registrant from Waiting List into New Event
Just moving is simple. I think we can run a SQL command to do that
Code:
UPDATE #__eb_registrants SET event_id=ID_OF_NEW_EVENT WHERE event_id=ID_OF_CURRENT_EVENT and published = 3

The difficulty part is handling payment. Don't know how we should do it

Tuan

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

  • OTWD
  • Topic Author
  • Offline
  • Platinum Member
  • Platinum Member
More
10 years 11 months ago #61772 by OTWD
Thanks for your replies
They should have paid to be on the waiting list, so can we not just transfer them then change status to paid?

Success consists of going from failure to failure without loss of enthusiasm.

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

More
10 years 11 months ago #61776 by James Riley
Replied by James Riley on topic Move Registrant from Waiting List into New Event

Tuan Pham Ngoc wrote: The difficulty part is handling payment. Don't know how we should do it


This is all a part of the "waiting list -> registered" support that needs to be fully implemented (as discussed in other recent posts).

On Twd wrote: They should have paid to be on the waiting list, so can we not just transfer them then change status to paid?

I don't think there is payment processed for 'waiting list' signup -- at least I'm pretty sure that there wasn't on the one event I had go over capacity a few months ago.

James Riley .: EventBooking user since 2014 ::: JoomDonation user since 2016 :.
.: grfx & web design / IT / AV @ St. Therese Institute of Faith and Mission, Bruno, SK, Canada :.

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

Moderators: Tuan Pham Ngoc