past events removal

  • Richard Chick
  • Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 10 months ago #126053 by Richard Chick
past events removal was created by Richard Chick
It does not seem possible to automatically delete past events. If that is true what strategy should be employed to maintain a clean database?

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

More
4 years 10 months ago #126062 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic past events removal
Hi Richard

Why do you want to delete events? What will happen with registrants of these events?

Tuan

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

More
4 years 10 months ago #126065 by Sunil
Replied by Sunil on topic past events removal
Tuan I would also appreciate an option to archive old events and registrants.
Maybe not delete but archive.

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

  • Richard Chick
  • Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 10 months ago #126082 by Richard Chick
Replied by Richard Chick on topic past events removal
My site is intended to connect users to performing and fine arts events in a geographical area. The key requirements are for the site to,
1.) present accurate, easily searchable event information in an uncluttered format which is entirely under the control of the user,
2.) allow event managers with limited technical skills to easily submit their event information on the front end only (for single and multiple but not necessarily repeating dates), and
3.) be made secure and maintainable with a minimum of administrative resources.
It is not necessary for any of the event or registration information to be retained or archived once the event has been presented. In fact I don't consider registration to be a necessary feature of my site at all although I will probably take advantage of it if there are no collateral downsides.
I expect that some of my event submitters will not be conscientious about removing out-of-date event information and I would have to sweep the database on a regular basis to prevent saturating the resource.

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

More
4 years 10 months ago #126083 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic past events removal
If you want something like that, I think you will need to write a system plugin to perform checking and removing events and it's registrants from database if needed

For example, each time the plugin runs, check and if any events older than 100 days, delete these events and it's registrants

Tuan

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

  • Richard Chick
  • Topic Author
  • Offline
  • New Member
  • New Member
More
4 years 10 months ago #126115 by Richard Chick
Replied by Richard Chick on topic past events removal
OK thanks Tuan. I see that you have documentation for adding plugins.

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

More
4 years 10 months ago #126127 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic past events removal
Actually, for this, you would need to develop a system plugin. So the documentation which we are having is useless. You can look at plugins/system/ebreminder/ebreminder.php for a sample system plugin comes with Events Booking by default

Tuan
The following user(s) said Thank You: Richard Chick

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

More
3 years 1 month ago #141854 by OTWD
Replied by OTWD on topic past events removal
Hi Tuan, In line with GDPR it would be essential to have a system that can easily delete all registrant details from the database after a specific date. Of course this can be done with sql but a plugin that does this would be very welcome.

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

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

More
3 years 1 month ago #141869 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic past events removal
You can always delete registrants from backend in Registrants Management. For deleting automatically, a plugin will need to be developed but not hard

If there are more customers need it, I will work on the development

Tuan
The following user(s) said Thank You: Richard Chick

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

Moderators: Tuan Pham Ngoc