CiviCRM Community Forums (archive)

In civiCRM 2.2 beta I imported a csv file with basically primary contact info. The file had over 3000 records. At first I thought the import had failed because the "Step 4 of 4" page displayed no information regarding the outcome of the import and the error message "We encountered an unknown error in SetFinished", however, all indications are that all records imported successfully.

what i experienced when importing 184 contacts from a csv file doesn't look like the same error, but it's probably related. all steps went through fine, and the script announced that all records had been imported successfully. trying to find the records, i found that only the first one had actually been imported. neither the new group i specified for the imported contacts, nor the new tag had been created.

in the DB i found several tables called civicrm_import_job.... with all the imported records, but except for the first one they hadn't been added to the contact or other tables.

i didn't find any error in my mysql or apache logs either. i'll try this again, also importing via MySQL, but so far this looks like a bug in CiviCRM's  import system...

running the same import (csv, 194 contacts, ard. one dozen custom fields, duplicate checking "skip") on my web server, the import threw the following error during the last step:

/home/phani/public_html/db/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 260
/home/phani/public_html/db/sites/all/modules/civicrm/CRM/Core/DAO.php, fatal, 707
/home/phani/public_html/db/sites/all/modules/civicrm/CRM/Import/Parser/Contact.php, getFieldValue, 537
/home/phani/public_html/db/sites/all/modules/civicrm/CRM/Import/Parser.php, import, 366
/home/phani/public_html/db/sites/all/modules/civicrm/CRM/Import/ImportJob.php, run, 224
/home/phani/public_html/db/sites/all/modules/civicrm/CRM/Import/Form/Preview.php, runImport, 228
/home/phani/public_html/db/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 247
/home/phani/public_html/db/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/home/phani/public_html/db/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/home/phani/public_html/db/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/home/phani/public_html/db/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/home/phani/public_html/db/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 232
/home/phani/public_html/db/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 197
/home/phani/public_html/db/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 342
, civicrm_invoke,
/home/phani/public_html/db/includes/menu.inc, call_user_func_array, 348
/home/phani/public_html/db/index.php, menu_execute_active_handler, 18
i'll try to figure out what this means, but on first sight i can't make much sense of it. BUT ALL CONTACTS have actually been IMPORTED. new group & tag were NOT created, and the temp. import_job table is still there. so overall it seems to be working.

(i suspect the failure on my local machine was due to it being rather slow, mysql not tuned at all, and me running KDE 4.3, which is at present in alpha-testing.)

if this helps anybody figuring out what's not working properly good; otherwise i can live happily with how importing works now.

that wasn't the case, i provided an external ID. but i'll wait for the next beta release. until then importing works good enough. i also imported activity history, providing the internal ID, and that works fine, too.

two things i noticed: that a subject is still required--even though i read somewhere that subject field wasn't required anymore since 2.whatever. this isn't a problem, of course.

and then the external ID doesn't seem to be available for synchronization of activity imports. i had to export the contacts to get the internal ID and provide that; also something that's supposed to be fixed in 2.1, i think.

thanks, phani.

i _am_ using 2.2 here, and couldn't find external ID for matching imported activities. i'll look again the next time, which will be in a couple hours, but am pretty sure there's only internal ID in the drop-down list.

thanks, phani.