Forums (Obsolete)


Member	damon.amanabadi-artisgroup.com - 7/12/2011 10:54:32 PM Email Archiving issue Hi Guys, The table of CMC_EMail is growing in terms of size and row count as we are running a weekly newsletter for more than 200000 users !!! Is there any way to filter the emails that are being archived? for example only from partcular senders or.... Am I clear ? we're using 5.5 Cheers,

Kentico Support

kentico_zdenekc - 7/13/2011 5:03:18 AM

RE:Email Archiving issue

Hi,

The settings for archiving sent emails is in Site manager -> Settings -> Emails -> Archive e-mails (days).
Normally, the sent emails should be removed from the queue (represented by CMS_Email table) after successful sending. I would therefore also recommend to check the Email queue and optionally the Event log (Site manager -> Administration) for any failed emails or errors related to the email queue.
To archive the emails only from specific senders, some customizations would have to be made, probably in source code..

Regards,
Zdenek


Certified Developer 9	charbf - 7/13/2011 8:22:54 PM RE:Email Archiving issue Hi, If you don't want to change the source code. you can also create a Scheduled Task http://devnet.kentico.com/docs/5_5r2/devguide/index.html?scheduling_a_custom_code.htm Franck


Kentico Support	kentico_zdenekc - 7/14/2011 3:52:38 AM RE:Email Archiving issue Thanks Franck, That's a good idea (assuming you mean some manipulation with records from the standard email table/queue). In addition to the standard custom scheduled task approach, you could create a task within App_Code as described in Martin Hejtmanek's post Provide your classes from App_Code --Zdenek


Member	Aon_Vlado - 1/18/2013 8:32:33 AM RE:Email Archiving issue Where are the archived emails getting stored? We did not realized the emails are archiving and we lost emails we need. How to restore them? Thanks, Vlado


Member	Aon_Vlado - 1/18/2013 9:11:27 AM RE:Email Archiving issue Never mind. I figured out that setting “Archive e-mails (days)” means that email are stored for this number of days only and older emails will be deleted. We lost the emails :-( Maybe it should be set to 0 as default out of the box. Vlado

Kentico Support

kentico_zdenekc - 1/20/2013 9:50:35 AM

RE:Email Archiving issue

Hi,

Thanks for the update. Basically the sent email is either archived or deleted. The setting is meant as to how long to keep an archived email...
Also, if set to 0, e-mails will not be archived at all.

If you wish to archive them, we would recommend to use a combination of higher value of Archive e-mails (days) setting and/or maybe also use some custom scheduled task that would periodically store the archived emails to some other repository (e.g. a zip archive, some cloud repository or any other suitable archiving medium).

Regards,
Zdenek