Answers.Body: <p>We have done some recent work on an Extension through which you can nominate a 'before' date and it then cleans out the Mailings along with the abundance of Activities, Activity Contacts etc.</p>
  
  <p>So this is not 'Archiving' as per the OP, this is deletion and does not answer your question but am hoping it proves a useful answer for others who might stumble on this. We will be writing up a blog shortly. On the big databases we are testing this on it is clearing out millions of rows of data and speeding up other queries particularly related to Actvities.</p>
  
  <p>Extension is at <a href="https://github.com/jitendrapurohit/nz.co.fuzion.deleteoldbulkmailings" rel="nofollow noreferrer">https://github.com/jitendrapurohit/nz.co.fuzion.deleteoldbulkmailings</a></p>
  
  <p>NOTE: Usual warnings apply. Turn off logging before running this.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-09-12T09:34:56.980Z
Answers.Text: Hi @petednz, I'd be very interested in this.  Do you have more details?
Answers.UserDisplayName: William Mortada
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2018-04-05T18:32:43.530Z
Answers.LastActivityDate: 2018-10-07T19:25:35.223Z
Answers.LastEditDate: 2018-10-07T19:25:35.223Z
Answers.UserDisplayName: petednz - fuzion
Body: <p>I look after a Civi install which has hundreds of completed mailings. I'd like to tidy things up a bit by archiving a lot of the older mailings, but there's no way that I can see to achieve this using the user interface.</p>
  
  <p>Would it be OK simply to set the is_archived field in the civicrm_mailing table to '1'? I know for a lot of stuff tinkering directly with the database isn't a good idea, but in this case?</p>
  
  <p>Ideally the mailing search results pages would work in the same way as contact search results pages and have checkboxes and an action menu, but that's not evident in the version currently running here (4.7.29 I think).</p>
  
Comments.ContentLicense: CC BY-SA 3.0
Comments.CreationDate: 2018-04-06T19:58:58.393Z
Comments.Text: mailing.is_archived looks safe to set through the database. To be a little safer I'd try it on one mailing first
Comments.UserDisplayName: Demerit
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2018-11-23T19:42:26.633Z
Comments.Text: @Graham, modifying the table work for you? We have the same issue. Thanks!
Comments.UserDisplayName: slbradio
Tags: <mailing>
Title: What's the optimal method to archive a lot of mailings?
ThreadText: # What's the optimal method to archive a lot of mailings?
  
  (Asked by: username_0 on 2018-04-05)
  
  I look after a Civi install which has hundreds of completed mailings. I'd like to tidy things up a bit by archiving a lot of the older mailings, but there's no way that I can see to achieve this using the user interface.
  
  Would it be OK simply to set the is\_archived field in the civicrm\_mailing table to '1'? I know for a lot of stuff tinkering directly with the database isn't a good idea, but in this case?
  
  Ideally the mailing search results pages would work in the same way as contact search results pages and have checkboxes and an action menu, but that's not evident in the version currently running here (4.7.29 I think).
  
  **Tags:** mailing
  
  > **Comments:**
  > **username_1**: mailing.is_archived looks safe to set through the database. To be a little safer I'd try it on one mailing first  
  > **username_2**: @username_0, modifying the table work for you? We have the same issue. Thanks!  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_3 on 2018-04-05. Score: 4
  
  We have done some recent work on an Extension through which you can nominate a 'before' date and it then cleans out the Mailings along with the abundance of Activities, Activity Contacts etc.
  
  So this is not 'Archiving' as per the OP, this is deletion and does not answer your question but am hoping it proves a useful answer for others who might stumble on this. We will be writing up a blog shortly. On the big databases we are testing this on it is clearing out millions of rows of data and speeding up other queries particularly related to Actvities.
  
  Extension is at <https://github.com/jitendrapurohit/nz.co.username_3.deleteoldbulkmailings>
  
  NOTE: Usual warnings apply. Turn off logging before running this.
  
  > **Comments:**
  > **username_4**: Hi @username_3, I'd be very interested in this.  Do you have more details?  
  
  ---
  
  