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 (Moderator: Dave Greenberg) »
  • no way of merging different contact types?
Pages: [1]

Author Topic: no way of merging different contact types?  (Read 365 times)

lynx

  • I’m new here
  • *
  • Posts: 20
  • Karma: 0
  • CiviCRM version: 4.5
  • CMS version: Joomla 2
  • MySQL version: 5.5.40
  • PHP version: 5.3.29
no way of merging different contact types?
January 19, 2015, 09:07:43 am
I was hoping to gradually import new contacts through the mailer (BCC), as they come. But that job always imports them as individuals and there doesn't seem to be an option to change that.

So if I'm talking to a general address like info@ or similar, it creates a new contact that I can't later convert to an organisation or merge it with one if it already exists with a different email. Manual work is still needed and the activity will be lost in the process. So the usefulness of the feature is sadly pretty limited, mostly for documenting exchanges with already recorded contacts.

Any ideas? Should I just post a FR on jira?

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: no way of merging different contact types?
January 19, 2015, 09:43:18 am
In the past if I need to merge an individual with an org I just manually fire off this query in mySql
Code: [Select]
UPDATE civicrm_contact SET contact_type = 'Organization' WHERE id = 123And then I can proceed with the merge. Works fine as long as you're not trying to also deal with custom data fields that apply to one type of contact but not the other.
Try asking your question on the new CiviCRM help site.

lynx

  • I’m new here
  • *
  • Posts: 20
  • Karma: 0
  • CiviCRM version: 4.5
  • CMS version: Joomla 2
  • MySQL version: 5.5.40
  • PHP version: 5.3.29
Re: no way of merging different contact types?
January 20, 2015, 03:04:18 am
yep, that's workable, thanks.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • no way of merging different contact types?

This forum was archived on 2017-11-26.