CiviCRM Community Forums (archive)

Probably a bug.... or "feature"?? 
Importing activity for a household using external ID as key does NOT work in civicrm 2.2.0.

Using the Contact ID as key works just fine for Households and Individuals. Using external ID as key works for individuals only, NOT for households.

Easy to duplicate:
Add an external ID to a household (use 1024, if using the example attached file)
Go to Import/Activity
Select the attached (downloaded) file
Select "First row contains column headers"
Select "DD/MM/YYYY" as date format (I'm a "southerner")
Continue and import - you'll get an error stating that "No matching Contact found for (1024)" in the error file that's generated.

Cheers,
Marty.

Demo site is having a bad hair day - keep getting (when trying to update external ID or view contacts):

Sorry. A non-recoverable error has occurred.
DB Error: no such field

Database Error Code: Unknown column 'civicrm_value_constituent_information_1.my_file_65' in 'field list', 1054

Cheers,
Marty.

OK, so I created a new household, gave it an external ID of 1024 and tried to import the activity. It did NOT import! It does, however, import to an Individual record, so it looks like an issue with households?
Cheers,
Marty.

Already done - http://issues.civicrm.org/jira/browse/CRM-4400

Thanks,
Marty.