Author Topic: After importing contacts via command line no name shows in search results (Read 882 times)

britebyte · October 21, 2012, 07:03:08 am

I imported a large number of contacts via the command line. I used a slightly modified version of the core CSV importer but the api call that creates the contact was not modified at all. The values I provided were only first_name, last_name, middle_name and external_id. No errors were reported and all 50,000+ contacts were created. I can see that the sort_name and display name were correctly populated in the db since they were created via the api. However in my contact search results no name is being displayed. The name column is empty. I tried flushing all the caches with no luck. Any ideas why the sort_name is not showing?

Edited to add this site is using Drupal 7.1.5 and CiviCRM 4.2.0.

britebyte · October 21, 2012, 08:18:20 am

I realize I was wrong on this. For most of the contacts the sort_name does display fine. There are a couple of pages of contacts showing up at the beginning of the search and for these the sort_name and display_name are NULL. Something must have prevented these from getting generated. I wonder if there are bad characters in the names..any thoughts?

britebyte · October 21, 2012, 10:03:31 am

Figured it out: I had some UTF8 characters in the failing names. My modified version of the CSV import was connecting directly to mysql and I did not set the connection character set.

CiviCRM Community Forums (archive)

News:

Author Topic: After importing contacts via command line no name shows in search results (Read 882 times)

britebyte

After importing contacts via command line no name shows in search results

britebyte

Re: After importing contacts via command line no name shows in search results

britebyte

Re: After importing contacts via command line no name shows in search results