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 »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Batch Update bug causing Household Sort_Name and Display_Name to empty
Pages: [1]

Author Topic: Batch Update bug causing Household Sort_Name and Display_Name to empty  (Read 1439 times)

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
Batch Update bug causing Household Sort_Name and Display_Name to empty
April 26, 2008, 08:02:24 pm
Hi - thought we did something but tested on demo and problem there too.

Having selected Households then put through a Batch Update. All households, including those for whom no change was selected in the profile field setting, then do not have any data (empty search string) in the Sort_Name and Display_Name fields.

Clicking Edit and Save brings it back for any individual record.

Do I put in a ticket?
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

Donald Lobo

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 15963
  • Karma: 470
    • CiviCRM site
  • CiviCRM version: 4.2+
  • CMS version: Drupal 7, Joomla 2.5+
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Batch Update bug causing Household Sort_Name and Display_Name to empty
April 26, 2008, 08:14:58 pm

yes, can you please file an issue for this. we'll definitely fix in 2.1 and if not too big a deal, potentially backport it to 2.0 also :)

lobo
A new CiviCRM Q&A resource needs YOUR help to get started. Visit our StackExchange proposed site, sign up and vote on 5 questions

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: Batch Update bug causing Household Sort_Name and Display_Name to empty
April 26, 2008, 08:30:49 pm
Done - http://issues.civicrm.org/jira/browse/CRM-3034 -  and chris offers this for anyone who has same problem in the meantime
Code: [Select]
UPDATE civicrm_contact
  SET display_name = household_name, sort_name = household_name
WHERE display_name = '' AND sort_name = '' AND contact_type = 'Household';
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

Chris Burgess

  • Ask me questions
  • ****
  • Posts: 675
  • Karma: 59
Re: Batch Update bug causing Household Sort_Name and Display_Name to empty
April 26, 2008, 09:12:00 pm
Not certain if this bug affects Households only. If not, then the SQL above won't be a complete solution.
@xurizaemon ● www.fuzion.co.nz

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: Batch Update bug causing Household Sort_Name and Display_Name to empty
April 27, 2008, 02:27:38 am
I haven't observed any problems with display names disappearing after Batch Update for individuals and have just rechecked on demo with no probls on either Individs or Organisations
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
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Batch Update bug causing Household Sort_Name and Display_Name to empty

This forum was archived on 2017-11-26.