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) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Display name, how to change lastname firstname order
Pages: [1]

Author Topic: Display name, how to change lastname firstname order  (Read 3375 times)

r4zoli

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Wordpress
  • MySQL version: 5
  • PHP version: 5
Display name, how to change lastname firstname order
February 23, 2013, 05:38:00 am
I found an old topic http://forum.civicrm.org/index.php?topic=6816.0
It is valid for CiviCRM 4.2?

I use civi with wordpess.

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Display name, how to change lastname firstname order
February 24, 2013, 04:19:55 am
You should be able to do this with Administer/Customize Data and Screens/Display Preferences. At the bottom of that page you will find how the display name and the sort name are set up. So if you want to change the way that the names are displayed, you can change it there. Or is it more that you want?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

r4zoli

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Wordpress
  • MySQL version: 5
  • PHP version: 5
Re: Display name, how to change lastname firstname order
February 24, 2013, 04:49:24 am
I changed the order, but on contact list in search results shows
Code: [Select]
firstname, lastname instead of desired
Code: [Select]
lastname, firstname I set code to
Code: [Select]
{contact.individual_prefix}{ }{contact.last_name}{ }{contact.first_name}{ }{contact.individual_suffix} in "Individual Display Name Format".

Another problem in mail merge the the example template use  {contact.display_name} which has same wrong order (for me).

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Display name, how to change lastname firstname order
February 24, 2013, 05:27:48 am
For the search results, you will have to set the other option, I believe it is the sort order as far as I know. Let me know if that works for the first three problems.

As far as the mail merge issue, for every contact a field is saved with the display name based on the settings once the record is created. That means if you change it on an existing install, you almost have to go through each existing contact and edit it to re-set the name sequence. You could write a little script for that?
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

r4zoli

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Wordpress
  • MySQL version: 5
  • PHP version: 5
Re: Display name, how to change lastname firstname order
February 24, 2013, 05:49:17 am
"Individual Sort Name Format" cahnged on same page to
Code: [Select]
{contact.last_name}{, }{contact.first_name} and has no effect on search results.
See screenshot.

Erik Hommel

  • Forum Godess / God
  • I live on this forum
  • *****
  • Posts: 1773
  • Karma: 59
    • EE-atWork
  • CiviCRM version: all sorts
  • CMS version: Drupal
  • MySQL version: Ubuntu's latest LTS version
  • PHP version: Ubuntu's latest LTS version
Re: Display name, how to change lastname firstname order
February 24, 2013, 05:56:08 am
Okay, so what you are seeing is the effect I mentioned before. The display name is already set in the DB with the 'old' setup.
Consultant/project manager at EEatWork and CiviCooP (http://www.civicoop.org/)

r4zoli

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Wordpress
  • MySQL version: 5
  • PHP version: 5
Re: Display name, how to change lastname firstname order
February 24, 2013, 06:49:32 am
Maybe it is a Wordpress generated problem?

All contacts came from Wordpress, no other contats added.

All users admins or has editors rights, and the names imported into CiviCRM contacts in wrong place, the first name into lastname field and the last name to the first name field.
If I cahanged to the right place, and saved contact, it was ok.
later left CiviCRM to wordpress, and went back to CiviCRM new contact was created with the wrong data, next to the changed original, with all data from wordpress.

Possibly it is bug, in CiviCRM.
I have no php programming knowledge, I'm a experinced user, or little above.

I will try to add test data, into contacts, will report back.

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: Display name, how to change lastname firstname order
February 24, 2013, 07:34:03 am

Those patterns only apply to new contacts. So try adding a few new contacts and see if they obey the new patterns

for the existing contacts, u'll need to do it directly in mysql or write a small php script to do so

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

r4zoli

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Wordpress
  • MySQL version: 5
  • PHP version: 5
Re: Display name, how to change lastname firstname order
February 25, 2013, 04:50:40 am
No success.
Created several new contacts after the changes in display name and sort name.
The contacts registered as first name, last name.
More interestingly, the communication settings shows something connected to the my main problem.

See comm2.png setting shows the selected firstname.

See communication.png, then in email and postal salutation selected firstname, but in realaity it is a lastname of contact.

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: Display name, how to change lastname firstname order
February 25, 2013, 07:34:20 am

display name format is different from greetings format which are also token based. Search for greetings in the administer civicrm screen

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

r4zoli

  • I post occasionally
  • **
  • Posts: 88
  • Karma: 1
  • CiviCRM version: 4.7
  • CMS version: Wordpress
  • MySQL version: 5
  • PHP version: 5
Re: Display name, how to change lastname firstname order
March 03, 2013, 03:49:26 am
Possibly I found the root cause of all my problems in the translation, more correctly in the wrong translation of  First Name and Last Name.
The correct one 'First Name' = 'Keresztnév' and the 'Last Name' must be 'Vezetéknév'.

Now I corrected in transifex, and if I know correctly it will be in the incoming 4.3 version.

For your information the Hungarian naming order is same as Japanese, Last Name followed by First Name.
Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Discussion »
  • Internationalization and Localization (Moderators: Michał Mach, mathieu) »
  • Display name, how to change lastname firstname order

This forum was archived on 2017-11-26.