- Posts: 85
 - Thank you received: 0
 
Backend Cleanup. Allow Archive of old subscriptions. Customize views
- Ahmad Arshad
 - Topic Author
 - Offline
 - Premium Member
 - 
            
         
        Less
        More
        
            
    
        
            
        
                3 years 4 months ago         -  1 year 9 months 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: 1 year 9 months ago  by Ahmad Arshad.            
            Please Log in or Create an account to join the conversation.
- Tuan Pham Ngoc
 - Offline
 - Administrator
 - 
            
         
            
        
                3 years 4 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: 85
 - Thank you received: 0
 
            
        
                2 years 11 months 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 11 months 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: 85
 - Thank you received: 0
 
            
        
                2 years 11 months 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 11 months 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: 85
 - Thank you received: 0
 
            
        
                2 years 7 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: 85
 - Thank you received: 0
 
            
        
                2 years 3 weeks 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: 85
 - Thank you received: 0
 
            
        
                1 year 11 months 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 © 2025 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.