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) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions (Moderator: Dave Greenberg) »
  • Change contact type ie. from 'individual' to 'organisation'
Pages: [1]

Author Topic: Change contact type ie. from 'individual' to 'organisation'  (Read 1552 times)

tth.om

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 4.1.1
  • CMS version: Joomla! 2.5.4
  • MySQL version: 5.1.56
  • PHP version: 5.2.17
Change contact type ie. from 'individual' to 'organisation'
July 12, 2012, 04:40:12 am
Hi

we come across contact records that have been imported wrong - ie. an organisation has been imported or recorded as an individual or the other way around. It would be nice to be able to change the type in ie a drop-down menu in stead of having to delete the record and start over.

Rosieqtx

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 3.4.7
  • CMS version: Drupal
  • MySQL version: not sure
  • PHP version: notsure
Re: Change contact type ie. from 'individual' to 'organisation'
July 25, 2012, 08:14:54 am
Having the same problem. Is there a way to change it via the back end? I accidentally changed the record type of a number of records via upload and I'd like to change them back since they all have significant activities/relationships/etc.

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Change contact type ie. from 'individual' to 'organisation'
July 25, 2012, 09:29:03 am

No way to do it via the UI in the backend. You can potentially do it directly in the DB by modifying the contact_type field.

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

Owen

  • I post occasionally
  • **
  • Posts: 83
  • Karma: 2
    • Leukaemia & Lymphoma Research
  • CiviCRM version: 4.3.4
  • CMS version: Drupal 7
  • MySQL version: -
  • PHP version: -
Re: Change contact type ie. from 'individual' to 'organisation'
July 26, 2012, 12:58:48 am
I often change them directly in the civicrm_contact table in the database.

You'll need to change the contact_type field also the contact_sub_type if you're using it. And also the name from organisation_name to first_name & last_name

Rosieqtx

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 3.4.7
  • CMS version: Drupal
  • MySQL version: not sure
  • PHP version: notsure
Re: Change contact type ie. from 'individual' to 'organisation'
August 07, 2012, 08:12:38 am
Thanks! That worked perfectly.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Discussion (deprecated) »
  • Feature Requests and Suggestions (Moderator: Dave Greenberg) »
  • Change contact type ie. from 'individual' to 'organisation'

This forum was archived on 2017-11-26.