In-Portal Issue Tracker - In-Portal CMS
Viewing Issue Advanced Details
ID: Category: Type: Reproducibility: Date Submitted: Last Update:
1228 [In-Portal CMS] Mailing System feature request always 2012-03-22 11:39 2012-07-25 05:31
Reporter: Dmitry Platform:  
Assigned To: alex OS:  
Priority: normal OS Version:  
Status: closed Product Version:  
Product Build: Resolution: fixed  
 
ETA: none Fixed in Version: 5.2.0-B3  
Reference: https://groups.google.com/d/topic/in-portal-dev/yTfC29_hLEg/discussion
Change Log Message: Added email log rotation and new fields
Estimate Points: 1
Summary: 0001228: Email Log Rotation and New Fields
Description: 1. Make all DB fields in EmailLog table Camel formation.

2. Store complete Email message that has been sent out to the User. It can play the role of Web Copy when needed.

We should have new fields added which will store:

- Email Subject
- Email Body
- AdditionalRecepients (all recipients like CC, BCC users, groups and so on - it's okay to store)
- EmailKey VARCHAR 32 - md5(from+to+subject+time) to be able to reference to this log from the Front end - if needed (will use in URL)

3. Add a new Tag - we would need to have some sort of Tag which can be used within the Template and which during the mailing will be build correct URL with proper Key so users can click and view they web version if needed.

4. Create new setting "Keep Email Log for" (KeepEmailLog) in System Configuration -> Advanced: Mailing Settings, after "Default E-mail Recipients" which would allow to specify number days to keep Email logs and delete all older ones. It's kind of rotation.

Keep Email Log for: Never (turned off), 1 day, 1 week, 2 weeks, 1 month, 3 months, 1 year, Forever (never deleted automatically)

Hint: Email Log stores the exact copy of all emails that been sent out by your website. The following information is stored: Time, Sender, Recipient, Subject and Email Body. This setting allows you to control for how long these emails will be stored in the log and then automatically deleted. Use option Never to completely turn email logging off, and option Forever to disable automatic log cleanup.

a. New install - default to 1 month
b. Upgrade - default to Forever

5. Create new Scheduled Job which would do cleaning based on setting specified in 4)
Steps To Reproduce:
Additional Information:
Relationships
parent of 0001328closed  (5.2.0)alex Long plain text e-mail appear broken in e-mail log 
parent of 0001348closed  (5.2.0)alex EmailLog doesn't store Emails with Very Long Body when sent via Mailing List 
child of 0000066needs feedback  (Icebox)alex Add Email Details feature to Email Logs 
Attached Files: patch email_log_rotation.patch (42,652) 2012-03-26 05:11
http://tracker.in-portal.org/file_download.php?file_id=1565&type=bug
Issue History
Date Modified Username Field Change
2012-07-25 05:31 alex Note Added: 0004955
2012-07-25 05:31 alex Status resolved => closed
2012-07-10 13:43 alex Relationship added parent of 0001348
2012-06-19 04:36 alex Relationship added parent of 0001328
2012-03-26 05:13 alex Note Added: 0004509
2012-03-26 05:13 alex Status reviewed and tested => resolved
2012-03-26 05:13 alex Fixed in Version => 5.2.0-B3
2012-03-26 05:13 alex Resolution open => fixed
2012-03-26 05:13 alex Assigned To !COMMUNITY => alex
2012-03-26 05:13 alex Changeset attached 5.2.x r15230
2012-03-26 05:12 alex Note Added: 0004508
2012-03-26 05:12 alex Status needs testing => reviewed and tested
2012-03-26 05:11 alex Assigned To => !COMMUNITY
2012-03-26 05:11 alex Developer => alex
2012-03-26 05:11 alex Status active => needs testing
2012-03-26 05:11 alex File Added: email_log_rotation.patch
2012-03-26 05:11 alex Estimate Points 0 => 1
2012-03-22 11:54 Dmitry Relationship added child of 0000066
2012-03-22 11:52 Dmitry Reference => https://groups.google.com/d/topic/in-portal-dev/yTfC29_hLEg/discussion
2012-03-22 11:39 Dmitry New Issue
2012-03-22 11:39 Dmitry Change Log Message => Added email log rotation and new fields
2012-03-22 11:39 Dmitry Estimate Points => 0

Notes
(0004508)
alex   
2012-03-26 05:12   
Will test all together later.
(0004509)
alex   
2012-03-26 05:13   
Fix committed to 5.2.x branch. Commit Message:

Fixes 0001228: Email Log Rotation and New Fields
(0004955)
alex   
2012-07-25 05:31   
Since 5.2.0 version was released.