Answers.Body: <p>In general I use this rule of thumb:
  - the core activity types that I do not use I will disable so I am sure they are still in the system and I do not disrupt anything without meaning to
  - if I added my own activity types and I know I no longer need them and have no active activity of that type in the system I delete the activity type</p>
  
  <p>Disabling is certainly the safest option!</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-31T19:32:04.957Z
Answers.Text: Thank you! Now is there a way to disable activity types that are dont have the option to disable or delete (basically built in ones) so they don't show up?
Answers.UserDisplayName: Gina
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-31T07:29:38.040Z
Answers.LastActivityDate: 2016-03-31T07:29:38.040Z
Answers.UserDisplayName: ErikH - CiviCooP
Answers.Body: <p>Disabling the activity is what you want. That removes an activity as a live option moving forward, but maintains the historical data.</p>
  
  <p>Deleting the activity removes it as an option and erases the historical data.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-31T21:52:14.530Z
Answers.Text: what is the best way to disable core activities types that are enabled by default and has no option to disable from the UI, example Inbound Email?
Answers.UserDisplayName: Kboy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-04-01T13:04:25.833Z
Answers.Text: You could try to disable in the database, but if they are reserved (you can not change in the UI) it usually has a reason....so test carefully.
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-06T17:06:35.000Z
Answers.Text: @Erikh, can you help me the db command to disable this activity types? how will this affect upgrades if it is disabled in the database?
Answers.UserDisplayName: Kboy
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-07T07:56:29.717Z
Answers.Text: see my new answer
Answers.UserDisplayName: ErikH - CiviCooP
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-03-30T16:06:44.503Z
Answers.LastActivityDate: 2016-03-30T16:33:07.273Z
Answers.LastEditDate: 2016-03-30T16:33:07.273Z
Answers.UserDisplayName: Allen Hutchison
Answers.Body: <p>you will have to check the table civicrm_option_value with option_group_id 2 (activity type). The query to find them would be: </p>
  
  <pre><code>SELECT * FROM civicrm_option_value WHERE option_group_id = 2
  </code></pre>
  
  <p>To be safe, I would check for the ones you were looking for if the <em>is_reserved</em> column is set to 1, and if so, change it to 0. The query to do that would be (using the id column):</p>
  
  <pre><code>UPDATE civicrm_option_value SET is_reserved = 0 WHERE id = 12345
  </code></pre>
  
  <p>You should then be able to remove them in the UI. All this based on the assumption that this is the problem! If not, you would have to check for other causes.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2017-02-07T07:59:42.373Z
Answers.LastActivityDate: 2017-02-07T07:59:42.373Z
Answers.UserDisplayName: ErikH - CiviCooP
Body: <p>I am wondering what the difference between deleting and disabling an activity is? I would like to clean up the activity field options drop down menu to only reflect the ones we would like to continue using without deleting or affecting any of the historical activities associated with the ones we are planning to delete.</p>
  
  <p>Thanks for your help.</p>
  
Tags: <activities><activity><delete>
Title: Deleting vs. Disabling an Activity Type
ThreadText: # Deleting vs. Disabling an Activity Type
  
  (Asked by: username_0 on 2016-03-30)
  
  I am wondering what the difference between deleting and disabling an activity is? I would like to clean up the activity field options drop down menu to only reflect the ones we would like to continue using without deleting or affecting any of the historical activities associated with the ones we are planning to delete.
  
  Thanks for your help.
  
  **Tags:** activities, activity, delete
  
  
  ---
  
  ## 3 answers
  
  ### Answer by username_1 on 2016-03-31. Score: 2 | Accepted answer
  
  In general I use this rule of thumb:
  - the core activity types that I do not use I will disable so I am sure they are still in the system and I do not disrupt anything without meaning to
  - if I added my own activity types and I know I no longer need them and have no active activity of that type in the system I delete the activity type
  
  Disabling is certainly the safest option!
  
  > **Comments:**
  > **username_0**: Thank you! Now is there a way to disable activity types that are dont have the option to disable or delete (basically built in ones) so they don't show up?  
  
  ---
  
  ### Answer by username_2 on 2016-03-30. Score: 3
  
  Disabling the activity is what you want. That removes an activity as a live option moving forward, but maintains the historical data.
  
  Deleting the activity removes it as an option and erases the historical data.
  
  > **Comments:**
  > **username_3**: what is the best way to disable core activities types that are enabled by default and has no option to disable from the UI, example Inbound Email?  
  > **username_1**: You could try to disable in the database, but if they are reserved (you can not change in the UI) it usually has a reason....so test carefully.  
  > **username_3**: @Erikh, can you help me the db command to disable this activity types? how will this affect upgrades if it is disabled in the database?  
  > **username_1**: see my new answer  
  
  ---
  
  ### Answer by username_1 on 2017-02-07. Score: 2
  
  you will have to check the table civicrm_option_value with option_group_id 2 (activity type). The query to find them would be: 
  SELECT * FROM civicrm_option_value WHERE option_group_id = 2
  
  To be safe, I would check for the ones you were looking for if the is_reserved column is set to 1, and if so, change it to 0. The query to do that would be (using the id column):
  UPDATE civicrm_option_value SET is_reserved = 0 WHERE id = 12345
  
  You should then be able to remove them in the UI. All this based on the assumption that this is the problem! If not, you would have to check for other causes.
  
  
  ---
  
  