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) »
  • Import - No Errors, Records "imported" - Records are not importing
Pages: [1]

Author Topic: Import - No Errors, Records "imported" - Records are not importing  (Read 1979 times)

CMLA

  • I’m new here
  • *
  • Posts: 20
  • Karma: 0
  • CiviCRM version: 4.3.7
  • CMS version: Drupal 6.22
  • MySQL version: 5.5.33
  • PHP version: 5.3.27
Import - No Errors, Records "imported" - Records are not importing
May 22, 2009, 01:31:21 pm
I have a frustrating issue with Civicrm-

I am importing some .csv files (with First, Last, Email and Organization) into civicrm. It throws no errors, and goes through the process. At the end, it tells me (19) records were imported....however, when I go to find them by using a Find - they don't exist!

I took a quick look at PHPmyAdmin, and see that each (failed) import creates a new table called civicrm_import_job_xxxxxxxxxxxxxxxxxxxx. In this table, !some! of the imported data is there.

I did an import of a different csv file and it worked like a charm. In the documentation, I read that Civicrm doesn't like excel CSV's so I have tried some exported out of Filemaker and converted from http://labs.brotherli.ch/vcfconvert/. I try to make sure they are all UTF-8 encoded, using commas as the spacers.

Where should I begin to troubleshoot?

CMLA

  • I’m new here
  • *
  • Posts: 20
  • Karma: 0
  • CiviCRM version: 4.3.7
  • CMS version: Drupal 6.22
  • MySQL version: 5.5.33
  • PHP version: 5.3.27
Re: Import - No Errors, Records "imported" - Records are not importing
May 22, 2009, 01:45:19 pm
And what's more - I cannot replicate the problem in the Sandbox.

CMLA

  • I’m new here
  • *
  • Posts: 20
  • Karma: 0
  • CiviCRM version: 4.3.7
  • CMS version: Drupal 6.22
  • MySQL version: 5.5.33
  • PHP version: 5.3.27
Re: Import - No Errors, Records "imported" - Records are not importing
May 26, 2009, 09:18:41 am
Any ideas? At this point I'm toying around with the prospect of having to re-install civicrm...which I'd really rather not do.

CMLA

  • I’m new here
  • *
  • Posts: 20
  • Karma: 0
  • CiviCRM version: 4.3.7
  • CMS version: Drupal 6.22
  • MySQL version: 5.5.33
  • PHP version: 5.3.27
Re: Import - No Errors, Records "imported" - Records are not importing
May 28, 2009, 09:46:44 am
Here's the log file from a failed import -
Code: [Select]
May 28 11:09:05  [info] $Fatal Error Details = Array

 [message] => Strict rule for Organization does not exist
    [code] =>



May 28 11:09:05  [info] $backTrace = /home/cmlacom/public_html/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 265
/home/cmlacom/public_html/sites/all/modules/civicrm/CRM/Dedupe/Finder.php, fatal, 93
/home/cmlacom/public_html/sites/all/modules/civicrm/api/v2/Contact.php, dupesByParams, 322
/home/cmlacom/public_html/sites/all/modules/civicrm/CRM/Import/Parser/Contact.php, civicrm_contact_check_params, 1347
/home/cmlacom/public_html/sites/all/modules/civicrm/CRM/Import/Parser/Contact.php, createContact, 671
/home/cmlacom/public_html/sites/all/modules/civicrm/CRM/Import/Parser.php, import, 366
/home/cmlacom/public_html/sites/all/modules/civicrm/CRM/Import/ImportJob.php, run, 224
/home/cmlacom/public_html/sites/all/modules/civicrm/CRM/Import/Form/Preview.php, runImport, 228
/home/cmlacom/public_html/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 247
/home/cmlacom/public_html/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/home/cmlacom/public_html/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/home/cmlacom/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home/cmlacom/public_html/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home/cmlacom/public_html/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 245
/home/cmlacom/public_html/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 205
/home/cmlacom/public_html/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 339
, civicrm_invoke,
/home/cmlacom/public_html/includes/menu.inc, call_user_func_array, 348
/home/cmlacom/public_html/index.php, menu_execute_active_handler, 18

Interestingly enough, when the duplicate checker is set to No Duplicate Checking, imports go perfectly fine. Solution? Anyone? Bueller?[/code]
« Last Edit: May 28, 2009, 09:49:03 am by CMLA »

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: Import - No Errors, Records "imported" - Records are not importing
May 28, 2009, 10:38:32 am

the error message says:

Strict rule for Organization does not exist

so you need to create one :) Administer CiviCRM >> Find and merge duplicate contacts

The default install has this in the config, so most likely you disabled it?

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

CMLA

  • I’m new here
  • *
  • Posts: 20
  • Karma: 0
  • CiviCRM version: 4.3.7
  • CMS version: Drupal 6.22
  • MySQL version: 5.5.33
  • PHP version: 5.3.27
Re: Import - No Errors, Records "imported" - Records are not importing
May 29, 2009, 03:10:38 pm
That did it! Thanks.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Import (Moderator: Yashodha Chaku) »
  • Import - No Errors, Records "imported" - Records are not importing

This forum was archived on 2017-11-26.