CiviCRM Community Forums (archive)

Hi there,

I've just started using CivCRM. I'm having great difficulty importing contacts. Any help would be greatly appreciated... I'm completely lost!

I'm trying to import two sets of contacts, individuals and organisations (see attached CSV samples and mappings). The largest of these lists has 64 records.

I've cleaned both lists so that there are no errors at preview. Import appears to go smoothly, with the Summary screen reporting:

Import has completed successfully. The information below summarizes the results.
Total Rows    64    Total number of rows in the uploaded file.
Total Contacts    64    Total number of contact records created or modified during the import.

However, none of these records show up in the contacts. A look at the database in PHPMyAdmin confirms this.

A look at the results in /civicrm/upload reveals two things:
1. status_#.txt reports "No processing status reported yet".
2. the hashed upload files are either clean, or contain one of two errors: (a) "Invalid value for field(s) : country input value not in country table: "The Country value appears to be invalid. It does not match any value in CiviCRM table of countries." OR (b) "Invalid value for field(s) : country input is in table but not "available": "This Country is valid but is NOT in the list of Available Countries currently configured for your site. This can be viewed and modifed from Global Settings >> Localization."
Often, the same country name appears with both errors.

I've also tried adding contacts manually, and I get a seemingly related error - the countries and regions I've added at Global Settings >> Localization can't be selected.

Environment info: local mac running 10.5.6, MAMP with PHP 5.2.5 (Zend off, no cache), MySQL 5.0.41, Apache 2.0.59, Acquia Drupal 6.9, CiviCRM 2.1.4, accessed via Firefox 3.0.6/Safari 3.1.2.


Thanks and regards,
Nick Howlett,
Port Vila, Vanuatu

Backtraces:
Feb 20 23:28:11  [info] $backTrace = /Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Core/Error.php, backtrace, 194
, handle,
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/packages/PEAR.php, call_user_func, 912
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/packages/PEAR.php, PEAR_Error, 576
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/packages/Net/Socket.php, raiseError, 143
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/packages/HTTP/Request.php, connect, 721
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Utils/Geocode/Google.php, sendRequest, 127
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Core/BAO/Address.php(256) : eval()'d code, format, 1
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Core/BAO/Address.php, eval, 256
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Core/BAO/Address.php, fixAddress, 139
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Core/BAO/Address.php, add, 116
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Core/BAO/Location.php, create, 82
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php, create, 255
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Contact/BAO/Contact.php, create, 1413
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Import/Parser/Contact.php, createProfileContact, 1225
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Import/Parser/Contact.php, createContact, 591
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Import/Parser.php, import, 379
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Import/Form/Preview.php, run, 311
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Core/Form.php, postProcess, 247
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Core/StateMachine.php, mainProcess, 166
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Core/QuickForm/Action/Next.php, perform, 63
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Controller.php, perform, 203
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/packages/HTML/QuickForm/Page.php, handle, 103
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Core/Controller.php, handle, 232
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/CRM/Core/Invoke.php, run, 197
/Users/nick/Sites/cleandrupal/sites/all/modules/civicrm/drupal/civicrm.module, invoke, 315
, civicrm_invoke,
/Users/nick/Sites/cleandrupal/includes/menu.inc, call_user_func_array, 348
/Users/nick/Sites/cleandrupal/index.php, menu_execute_active_handler, 18

Feb 20 23:28:23  [info] $IDS Detector Details = Array
(
    [0] => Array
        (
            [name] => coppermine_data
            [value] => YTo2OntzOjI6IklEIjtzOjMyOiI2MTVlZDEyYWZiMTFiNDE1YzE4MTJkZjJkYjYyNzg5MCI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo3OiJlbmdsaXNoIjtzOjM6ImxpdiI7YTozOntpOjA7czozOiI5MjYiO2k6MTtzOjM6IjU4OSI7aToyO3M6MjoiMjkiO31zOjU6InRoZW1lIjtzOjEwOiJ3YXRlcl9kcm9wIjtzOjQ6InNvcnQiO3M6MjoidGEiO30=
            [page] => /cleandrupal/civicrm/ajax/contact?name=
            [userid] => 102
            [session] => ecd399466b768e839dc68f8282e2a758
            [ip] => ::1
            [reaction] => 0
            [impact] => 26
        )

    [1] => Array
        (
            [name] => IDS_request_uri
            [value] => /cleandrupal/civicrm/ajax/contact?name=
            [page] => /cleandrupal/civicrm/ajax/contact?name=
            [userid] => 102
            [session] => ecd399466b768e839dc68f8282e2a758
            [ip] => ::1
            [reaction] => 0
            [impact] => 26
        )

)

Hi John, in response....

It is quick, but I am working locally with a contact list with only 64 records. All null values have been removed.

Re country names, the table that holds the list of names (civicrm_data.mysql) contains values for both the ISO two-letter code and the full name, so I don't think that's the issue. I had been having some errors with country names on preview, but I cleaned those up. On one import (and perhaps this is indicative of the nature of the problem), I received the 'invalid value for field' message for every single record, regardless of country name. But then the next time I attempted to import the same CSV file again, no error message was output, but still no records had been imported. So it is one of those annoying, intermittent problems.

And regardless, I still I can't select the correct country on the contact submission form...

I will attempt to delete some of the columns of data and see if this helps, and post again.

UPDATE, 22 FEB: I've stripped out all extraneous detail, so there are no columns of data set to 'do not import'. CiviCRM correctly identifies all column headings from the CSV, but the same problem is still occurring - import summary shows a successful import, but no data is added to the SQL DB and so no additional contacts are added. VERY FRUSTRATING. If anyone has any clues, I'd love to hear from you!