- Posts: 84
- Thank you received: 0
Backend Cleanup. Allow Archive of old subscriptions. Customize views
- Ahmad Arshad
- Topic Author
- Offline
- Premium Member
Less
More
2 years 6 months ago - 10 months 2 weeks ago #152331
by Ahmad Arshad
Backend Cleanup. Allow Archive of old subscriptions. Customize views was created by Ahmad Arshad
Dear Tuan,
We get close to 700 subscriptions every 4 months. As you can tell, from a scalability prospective, it can be problematic long term. I am proposing the following:
1) Ability to "ARCHIVE" subscriptions, similar to how archive works in articles. It would mean that all the expired/cancelled/refunded subscriptions more than X months old could be archived so it does not clutter the subscription view.
2) Perhaps we could also create a new DB table osmembership_subscribers_archived separate from osmembership_subscribers for performance reasons that can keep historical data for years without affecting the current subscriptions?
I wonder if others would be interested in a solution like that...
We get close to 700 subscriptions every 4 months. As you can tell, from a scalability prospective, it can be problematic long term. I am proposing the following:
1) Ability to "ARCHIVE" subscriptions, similar to how archive works in articles. It would mean that all the expired/cancelled/refunded subscriptions more than X months old could be archived so it does not clutter the subscription view.
2) Perhaps we could also create a new DB table osmembership_subscribers_archived separate from osmembership_subscribers for performance reasons that can keep historical data for years without affecting the current subscriptions?
I wonder if others would be interested in a solution like that...
Last edit: 10 months 2 weeks ago by Ahmad Arshad.
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
2 years 5 months ago #152335
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Business Intelligence - Moving Expired to a new DB / View
Hi Ahmad
1. Might be something which we implement in the future
2. Something I won't look at it for now because it could cause unexpected behavior. We can have much more records than that, so no need to move it to a separate table for now
(There are customers use the extension with more than 30K subscription records and counting, it is working well, so no need for worry about this for now)
Regards,
Tuan
1. Might be something which we implement in the future
2. Something I won't look at it for now because it could cause unexpected behavior. We can have much more records than that, so no need to move it to a separate table for now
(There are customers use the extension with more than 30K subscription records and counting, it is working well, so no need for worry about this for now)
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- Ahmad Arshad
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 84
- Thank you received: 0
2 years 1 month ago #154592
by Ahmad Arshad
Replied by Ahmad Arshad on topic Business Intelligence - Moving Expired to a new DB / View
Bumping this up.
I wonder if others would be interested in overhauling the backend of Membership Pro...
1. De-clutter some of the configuration options.
2. Ability to archive expired subscriptions
3. Pick the columns to display in the SUBSCRIPTIONS / SUBSCRIBERS / REPORTS sections
4. Decouple Last Name and Email so they are separate columns
5. Use AJAX to load data rather than reload of the page (if possible)
I feel like this is such a great plugin with so much potential.
I want to thank Tuan and his team for working on this
I wonder if others would be interested in overhauling the backend of Membership Pro...
1. De-clutter some of the configuration options.
2. Ability to archive expired subscriptions
3. Pick the columns to display in the SUBSCRIPTIONS / SUBSCRIBERS / REPORTS sections
4. Decouple Last Name and Email so they are separate columns
5. Use AJAX to load data rather than reload of the page (if possible)
I feel like this is such a great plugin with so much potential.
I want to thank Tuan and his team for working on this
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
2 years 1 month ago #154596
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Business Intelligence - Moving Expired to a new DB / View
Hi Ahmad
Happy to work on #2, #3 and #4. For #1, could you please explain more details about it?
For #5, something which I'm not ready to work on it right now
Tuan
Happy to work on #2, #3 and #4. For #1, could you please explain more details about it?
For #5, something which I'm not ready to work on it right now
Tuan
Please Log in or Create an account to join the conversation.
- Ahmad Arshad
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 84
- Thank you received: 0
2 years 1 month ago #154606
by Ahmad Arshad
Replied by Ahmad Arshad on topic Business Intelligence - Moving Expired to a new DB / View
Dear Tuan,
You can ignore 1). All I meant was to rethink the configuration and subscription tabs since we have many many options within, but its completely workable. Thankyou for taking a look at 2) 3) and 4)
You can ignore 1). All I meant was to rethink the configuration and subscription tabs since we have many many options within, but its completely workable. Thankyou for taking a look at 2) 3) and 4)
Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
- Offline
- Administrator
2 years 1 month ago #154611
by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Business Intelligence - Moving Expired to a new DB / View
OK, Thanks. For #1, if you have any ideas to improve configuration page to make it easier to understand/follow, please suggest it to me . Happy to look at suggestions and get it improved.
Regards,
Tuan
Regards,
Tuan
Please Log in or Create an account to join the conversation.
- Ahmad Arshad
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 84
- Thank you received: 0
1 year 8 months ago #157470
by Ahmad Arshad
Replied by Ahmad Arshad on topic Business Intelligence - Moving Expired to a new DB / View
Bumping this up to keep this on your radar dear Tuan.
Please Log in or Create an account to join the conversation.
- Ahmad Arshad
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 84
- Thank you received: 0
1 year 2 months ago #161358
by Ahmad Arshad
Replied by Ahmad Arshad on topic Business Intelligence - Moving Expired to a new DB / View
bump - hope we can revamp the backend
Please Log in or Create an account to join the conversation.
- Ahmad Arshad
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 84
- Thank you received: 0
1 year 2 weeks ago #162618
by Ahmad Arshad
Replied by Ahmad Arshad on topic Business Intelligence - Moving Expired to a new DB / View
Hey Tuan,
With Joomla 5.0.1 now available, it would be great if we can revisit this request. It would be great if we can work on the backend a bit for the heavy users
With Joomla 5.0.1 now available, it would be great if we can revisit this request. It would be great if we can work on the backend a bit for the heavy users
Please Log in or Create an account to join the conversation.
Support
Documentation
Information
Copyright © 2024 Joomla Extensions by Joomdonation. All Rights Reserved.
joomdonation.com is not affiliated with or endorsed by the Joomla! Project or Open Source Matters.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.
The Joomla! name and logo is used under a limited license granted by Open Source Matters the trademark holder in the United States and other countries.