Note: You are viewing an old version of this page. View the current version.

Differences between version 14 and previous revision of RobertButler.

Other diffs: Previous Major Revision, Previous Author

Newer page: version 14 Last edited on Tuesday, 28 March 2017 10:53:12 by RobertButler Revert
Older page: version 13 Last edited on Tuesday, 28 March 2017 10:52:15 by RobertButler Revert
@@ -39,11 +39,12 @@
  # id 
  # group 
  # status 
  # timestamp 
-* === Returned  
+* === OptOuts  
  # id 
  # idnum 
+ # reason  
  # timestamp 
 * === Cache 
  # idnum 
  # first 

version 14

EMAIL CAMPAIGN MANAGER DESCRIPTION

  • Email Manager Back-end Component

    1. Manages Email Campaigns internally
    2. Requests email tokens from the front-end (PHP) website.
    3. Delivers emails to addresses with with thankyou and optout tokens, taking note of bounces.
    4. Updates shared database (SQLite, Pgsql?) for the front-end to be able to display campaign status

  • Email Manager Front-end Component

    1. written in PHP, uses shared database to update user(s) on campaign status, progress, bounces, opt-outs, etc.
    2. Uses kohana Web/MVC framework.
    3. Requests Campaign information (create, delete, start, stop, etc.)

Database Schema

  • Tables

    1. Campaigns
    2. Processed
    3. Returned
    4. OptOuts?
    5. Cache

Tables

  • Campaigns

    1. id
    2. name
    3. status
    4. created_on
    5. updated_on

  • Processed

    1. id
    2. idnum
    3. status
    4. timestamp

  • Returned

    1. id
    2. group
    3. status
    4. timestamp

  • OptOuts?

    1. id
    2. idnum
    3. reason
    4. timestamp

  • Cache

    1. idnum
    2. first
    3. middle
    4. last
    5. address
    6. city
    7. state
    8. zip
    9. entered
    10. submttd
    11. uid