In-Portal Issue Tracker

Welcome to the In-Portal Open Source CMS Issue Tracker! This is a central management / tracking tool for all types of tasks / issues / bugs for the In-Portal Project. Before reporting any issues, please make sure to read the Guide into Issue Tracker and How to Properly Test and Report Bugs!

Viewing Issue Advanced Details Jump to Notes ] Wiki ] View Simple ] Issue History ] Print ]
ID Category Type Reproducibility Date Submitted Last Update
0001228 [In-Portal CMS] Mailing System feature request always 2012-03-22 11:39 2012-07-25 05:31
Reporter Dmitry View Status public Project Name In-Portal CMS
Assigned To alex Developer
Priority normal Resolution fixed Platform
Status closed   OS
  OS Version
ETA none Fixed in Version 5.2.0-B3 Product Version
  Target Version 5.2.0 Product Build
Time EstimateNo estimate
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
Tags No tags attached.
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
Attached Files patch file icon email_log_rotation.patch [^] (42,652 bytes) 2012-03-26 05:11 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
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 

-  Notes
User avatar (0004508)
alex (manager)
2012-03-26 05:12

Will test all together later.
User avatar (0004509)
alex (manager)
2012-03-26 05:13

Fix committed to 5.2.x branch. Commit Message:

Fixes 0001228: Email Log Rotation and New Fields
User avatar (0004955)
alex (manager)
2012-07-25 05:31

Since 5.2.0 version was released.

- Related Changesets
In-Portal CMS: 5.2.x r15230
Timestamp: 2012-03-26 05:13:31
Author: alex
Details ] Diff ]
Fixes 0001228: Email Log Rotation and New Fields
mod - /in-portal/branches/5.2.x/admin/system_presets/simple/email_logs_email-log.php Diff ] File ]
add - /in-portal/branches/5.2.x/core/admin_templates/logs/email_logs/email_log_edit.tpl File ]
mod - /in-portal/branches/5.2.x/core/admin_templates/logs/email_logs/email_log_list.tpl Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/english.lang Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/install_data.sql Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/install_schema.sql Diff ] File ]
mod - /in-portal/branches/5.2.x/core/install/upgrades.sql Diff ] File ]
mod - /in-portal/branches/5.2.x/core/kernel/utility/email.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/helpers/mailing_list_helper.php Diff ] File ]
add - /in-portal/branches/5.2.x/core/units/logs/email_logs/email_log_eh.php File ]
add - /in-portal/branches/5.2.x/core/units/logs/email_logs/email_log_tp.php File ]
mod - /in-portal/branches/5.2.x/core/units/logs/email_logs/email_logs_config.php Diff ] File ]
mod - /in-portal/branches/5.2.x/core/units/mailing_lists/mailing_list_eh.php Diff ] File ]

- 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



Web Development by Intechnic
In-Portal Open Source CMS
In-Portal Open Source CMS
Copyright © 2000 - 2009 MantisBT Group

Powered by Mantis Bugtracker