Simple newsletter module research and create the dynamic list functionality

[sumeetpareek]

Need to study and understand all aspects of simple newsletter module.

And then create a functionality such that if we run a query that outputs N number of user ids, that should create a new list of simple newsletter subscribers on the fly.

1. To be able to do that we will have add some temp filed to the user profile (so that our queries can be tested.
2. Need to generated large number of dummy users
3. (Should the generated users be automatically added to subscribers table (not the subscriptions table))?
4. Thought should be given to how the various data points (opened the mail, bounced, spammed etc.) will be marked. This does not has to be implemented yet, but our dynamic lists should allow this in future.
5. Dev site should be ready on the server to be able to test this.

[tkuldeep]

According to me creating newsletter subscription list we have to following things

• Run a query, outputs N number of user ids. By these users ids, newsletter subscription id will be find out and will be saved in serialized object of new table named simplenewsletter_users_list.
  • This table will consist of following columns
  • List_id, List_name, List_query, List_snids, List_newsletter_category.
  • First two column are simple can be easily understood by their name.
  • Now List_query will consist of complete sql query in serialized object, used in describing the details of list mean attributes of list. For example if we want to find out users who are less than 40 yrs and their height should be between 5 to 6 ft. So attributes would be Age => 40 yrs, Height => 5-6 ft.
  • List_uids will conatins the all resulted snids [Simple newsletter IDs ] serialized object.
  • So all uids must have snids. means all uids will be checked, if they are subscribed or not, If not then they will subscribed to newsletters.
• So during sending emails to user_lists, we simply get all snids from this column List_uids and pass these snids to function used to sent the mails.

[tkuldeep]

According to me to complete this project, we should follow following strategy.

• First create well document, what is our requirement, So that when other will read that document, he can think how he will do this, or what would be that best method, which will also help in doing further requirement.
• As we all know our requiremnts [By studying document]. So it will help in selecting process, which we have to use.
  • For example how our database table will be structured, what functions we have to create etc..

[tkuldeep]

Updates:

• Created user category list, But currently I am passing email id and list name manually. No sql-query has written for passing email ids. For getting email ids, sql-query will be very easy.
• Currently I am focusing on only simplenewsletter module. And by using same analogy I am adding new functionality in new custom module named kabootr.
• Users in this list are subscribed to newsletter.
• Admin can subscribers users according to user category and also newsletter category.

[sumeetpareek]

@tkuldeep Currently I see no commits that are referencing this issue?

[mukeshagarwal]

this was part of research and therefore closing it now