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 Import (Moderator: Yashodha Chaku) »
  • Importing organization is splitting the record into two organizations
Pages: [1]

Author Topic: Importing organization is splitting the record into two organizations  (Read 644 times)

sandbox

  • I’m new here
  • *
  • Posts: 2
  • Karma: 0
  • CiviCRM version: 4.2.0
  • CMS version: Joomla 2.5.6
  • MySQL version: 5.0.95
  • PHP version: 5.3.16
Importing organization is splitting the record into two organizations
December 10, 2012, 11:21:50 am
Still pretty new to Civi. I'm using the Civi interface vs direct SQL because I need to be able to define these procedures for my client for future data updates.

Civi 4.2.2, Joomla 2.5.6, MySQL 5.5.28, PHP 5.3.16

Original import of Organization:School with ExtID  and related as "District Member of" District based on its ExtID (ExtID's needed to track back to state DOE, DESE sources)
De-dup rule checking is off. These are small batches of 2-20 records.
This worked in original test cases.
Now it's consistently splitting each record into two records of Organization:School. One has the ExtID and relationship, an email and city,state and some other fields. The other record is also Organization:School w/o ExtIDs or relationships, but has the org name, street address, and some other fields.
Work-around: We can delete all of the contacts w/o ExtIDs and then re-run import of the EXACT same file, but this time as an "Update" with a strict de-dupe check. All is well!

What is going on? Can't find anything in this forum or issue tracker.

JonGold

  • Ask me questions
  • ****
  • Posts: 638
  • Karma: 81
    • Palante Technology
  • CiviCRM version: 4.1 to the latest
  • CMS version: Drupal 6-7, Wordpress 4.0+
  • PHP version: PHP 5.3-5.5
Re: Importing organization is splitting the record into two organizations
December 10, 2012, 12:24:43 pm
Two things to try:
* See if this problem exists when doing the same import on the demo server (demo.civicrm.org).  This eliminates the possibility that any site-specific issues are affecting you, and also lets you test against a newer version of the code which might have the bug fixed.

* Try the same import but import as a regular organization contact rather than as a contact subtype.  I've seen some screwy bugs relating to contact subtypes during import, this will help isolate if the problem is related to its being a contact subtype.

Jon
Sign up to StackExchange and get free expert CiviCRM advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Importing organization is splitting the record into two organizations

This forum was archived on 2017-11-26.