CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviCase (Moderator: Dave Greenberg) »
  • Is it possible to edit the 'activity type' of an existing activity in civicase?
Pages: [1]

Author Topic: Is it possible to edit the 'activity type' of an existing activity in civicase?  (Read 446 times)

kza

  • I’m new here
  • *
  • Posts: 9
  • Karma: 0
  • CiviCRM version: CiviCRM 4.5.4
  • CMS version: Wordpress Version 4.0.1
  • MySQL version: ?
  • PHP version: ?
Is it possible to edit the 'activity type' of an existing activity in civicase?
January 29, 2015, 02:32:09 pm
Hi all,

We seem to be unable to change the 'Activity Type' to an activity that has already been created. Is there anyway around this? We are using 'Activity Type' to track different kinds of interactions with clients, but we need to be able to update these Activity Types based on changes to our information architecture (we're still working out the types, categories, tags, etc).

Thanks!
Kristin

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Is it possible to edit the 'activity type' of an existing activity in civicase?
January 29, 2015, 02:51:24 pm
You could do this directly in the sql database.
Note that the civicrm_activity table stores activities and revisions, so be sure to get them both by checking the is_current_revision flag.
Try asking your question on the new CiviCRM help site.

demeritcowboy

  • Ask me questions
  • ****
  • Posts: 570
  • Karma: 42
  • CiviCRM version: Always the latest!
  • CMS version: Drupal 6 mostly, still evaluating 7.
  • MySQL version: Mix of 5.0 / 5.1 / 5.5
  • PHP version: 5.3, usually on Windows
Re: Is it possible to edit the 'activity type' of an existing activity in civicase?
January 29, 2015, 11:11:55 pm
There could be a problem with custom fields and loss of data if you change the type, e.g. what happens if you have data in some custom fields and then change the type to a type that doesn't even have those fields. This would be the same with non-case activities.

Another possibility rather than activity types is to use a single activity type and have a custom field on it for "subtype" or whatever you want to call it (maybe "interaction type" based on your post). Then just change that field when you need to change what the entry represents.

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Is it possible to edit the 'activity type' of an existing activity in civicase?
January 30, 2015, 06:10:04 am
Yes agree that if you are planning to do this on an ongoing basis, switching activity types around is not a good workflow.
I read from your post that you just needed to do it once to clean up some experimental data, which is why I suggested changing it in the db, but just this once ;)
Try asking your question on the new CiviCRM help site.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviCase (Moderator: Dave Greenberg) »
  • Is it possible to edit the 'activity type' of an existing activity in civicase?

This forum was archived on 2017-11-26.