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 (Moderator: Dave Greenberg) »
  • Contact Display Name Format is not being applied
Pages: [1]

Author Topic: Contact Display Name Format is not being applied  (Read 899 times)

mcarson

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 5
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.4.22
Contact Display Name Format is not being applied
April 28, 2014, 07:14:05 am
We have recently upgraded to 4.4.4 and started noticing some display issues with the Contact Display Name field.
Currently it appears to be random  :-\

Previous to the upgrade, a contact's record would contain individual prefix first name last name at the top of the page. For example, Dr. David Fraser. Now, after the upgrade this appears as first name last name. For example, David Fraser. This affects everywhere where display name is used, including on exports.

I have checked the Individual Display Name Format in Display Preferences. This is correct.

Any ideas?
“Anyone who has never made a mistake has never tried anything new.” - Albert Einstein
"If you are travelling at the speed of light and you turn on your headlights, would they work?" - Unknown

mcarson

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 5
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.4.22
Re: Contact Display Name Format is not being applied
April 28, 2014, 07:48:49 am
Update:
When I changed the value of the individual prefix in the contact record and saved, the new value was applied.

There are around 2000 records that are impacted.

Does anyone know if running a SQL script to update these records would work?
« Last Edit: April 28, 2014, 08:08:07 am by mcarson »
“Anyone who has never made a mistake has never tried anything new.” - Albert Einstein
"If you are travelling at the speed of light and you turn on your headlights, would they work?" - Unknown

mcarson

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 5
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.4.22
Re: Contact Display Name Format is not being applied
April 28, 2014, 08:53:04 am
Another update!
Exported all individual records to csv, containing the Sort Name, Display Name and Individual Prefix fields. The entire individual prefix column is empty?!

Don't know where I can go from here...
“Anyone who has never made a mistake has never tried anything new.” - Albert Einstein
"If you are travelling at the speed of light and you turn on your headlights, would they work?" - Unknown

jaapjansma

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Re: Contact Display Name Format is not being applied
April 28, 2014, 08:56:18 am
There is a background job for updating the greetings probably this would also update the display name and sort name. You could try to run this job manually and see if it fixes your problem.

You can find this job by administer --> System settings --> backrgound jobs
Developer at Edeveloper / CiviCoop

mcarson

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 5
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.4.22
Re: Contact Display Name Format is not being applied
April 28, 2014, 09:09:12 am
Thanks. Executed the job with no effect :(
Confused ??? as to why the export of the individual prefix is empty.
“Anyone who has never made a mistake has never tried anything new.” - Albert Einstein
"If you are travelling at the speed of light and you turn on your headlights, would they work?" - Unknown

mcarson

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 5
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.4.22
Re: Contact Display Name Format is not being applied
April 28, 2014, 09:29:38 am
Updating every record one at a time would probably take forever. I'm guessing that something occurred during the upgrade process and wasn't noticed until now.

I am currently in the process of updating 100 records at a time by using batch update using profile. Saving the resulting page updates all the prefixes correctly. For now, that'll do. Still have to understand why the individual prefix column, when exported is blank.

Thanks
“Anyone who has never made a mistake has never tried anything new.” - Albert Einstein
"If you are travelling at the speed of light and you turn on your headlights, would they work?" - Unknown

joanne

  • Administrator
  • Ask me questions
  • *****
  • Posts: 852
  • Karma: 83
  • CiviCRM version: 4.4.16
  • CMS version: Drupal 7
Re: Contact Display Name Format is not being applied
April 28, 2014, 01:01:14 pm
Are the prefixes still missing from an export for the records you have fixed?
« Last Edit: April 28, 2014, 01:10:31 pm by joanne »

mcarson

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 5
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.4.22
Re: Contact Display Name Format is not being applied
April 29, 2014, 12:03:24 am
After updating around half of the contacts using batch update, I exported all our individual contact records including the individual prefix column

There is nothing exported for the individual prefix field, yet it appears that the display name was updated. Checking in the database, the prefix_id column contains what appears to be correct information...

Thanks

“Anyone who has never made a mistake has never tried anything new.” - Albert Einstein
"If you are travelling at the speed of light and you turn on your headlights, would they work?" - Unknown

petednz

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4899
  • Karma: 193
    • Fuzion
  • CiviCRM version: 3.x - 4.x
  • CMS version: Drupal 6 and 7
Re: Contact Display Name Format is not being applied
April 29, 2014, 05:03:44 pm
https://issues.civicrm.org/jira/browse/CRM-14259

you might want to upgrade to 4.4.5 and confirm the fix works
Sign up to StackExchange and get free expert advice: https://civicrm.org/blogs/colemanw/get-exclusive-access-free-expert-help

pete davis : www.fuzion.co.nz : connect + campaign + communicate

mcarson

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 5
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.4.22
Re: Contact Display Name Format is not being applied
April 29, 2014, 05:06:09 pm
Thanks. I'll upgrade to 4.4.5 and let you know
“Anyone who has never made a mistake has never tried anything new.” - Albert Einstein
"If you are travelling at the speed of light and you turn on your headlights, would they work?" - Unknown

mcarson

  • I post occasionally
  • **
  • Posts: 110
  • Karma: 5
  • CiviCRM version: 4.4.4
  • CMS version: Drupal 7.x
  • MySQL version: 5.5
  • PHP version: 5.4.22
Re: Contact Display Name Format is not being applied
May 11, 2014, 01:50:17 am
I have upgraded to 4.4.5 and this appears to have worked. Thanks.
“Anyone who has never made a mistake has never tried anything new.” - Albert Einstein
"If you are travelling at the speed of light and you turn on your headlights, would they work?" - Unknown
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM (Moderator: Dave Greenberg) »
  • Contact Display Name Format is not being applied

This forum was archived on 2017-11-26.