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) »
  • Mailing Labels are missing the contact name
Pages: [1] 2

Author Topic: Mailing Labels are missing the contact name  (Read 7270 times)

ToddW

  • I’m new here
  • *
  • Posts: 16
  • Karma: 1
Mailing Labels are missing the contact name
February 18, 2010, 04:10:39 pm
First off, excellent work on v3.

However, when using the Mailing Labels action, most contacts are missing names on the output PDF--just addresses only. Am I missing something? I've reproduced this on the demo site.

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Mailing Labels are missing the contact name
February 18, 2010, 10:41:24 pm
We have added 2 special configurable taken:

Email Greeting: {contact.email_greeting}
Postal Greeting: {contact.postal_greeting}
Addressee Greeting: {contact.addressee}

Make sure it is set for your contacts.

Kurund
Found this reply helpful? Support CiviCRM

pkeogan

  • I post frequently
  • ***
  • Posts: 130
  • Karma: 4
    • BackOffice Thinking
Re: Mailing Labels are missing the contact name
February 19, 2010, 08:36:09 pm
I'm having the same issue for mailing labels.

The token is set correctly and is the default option.  However, the mailing labels do not include the addressee. I need to go to communication preferences and manually update.   Since that's not possible for 30K+ plus contacts, I exported the contact records and imported them into the custom addresse field.  It's a fairly quick work around, but I'd prefer not to do it.

Either this is a bug or I'm missing something.....

Thanks

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Mailing Labels are missing the contact name
February 19, 2010, 09:05:33 pm
For contact records which were created prior to the new implementation of Address and Greetings - you need to populate the cached Addressee Name, Email Greeting and Postal Greeting in the contact records (address_display, postal_greeting_display, email_greeting_display) using the provided command line batch update script:

bin/UpdateGreeting.php

The script has doc inline for it's parameters.

New contact records will have these 'cached' fields automatically populated on insert and / or edit.
Protect your investment in CiviCRM by  becoming a Member!

pkeogan

  • I post frequently
  • ***
  • Posts: 130
  • Karma: 4
    • BackOffice Thinking
Re: Mailing Labels are missing the contact name
February 23, 2010, 10:34:48 am
The script is asking for a username and password.  However, there don't appear to be any arguments for the them in the script.  Is their something I'm missing?

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Mailing Labels are missing the contact name
February 23, 2010, 11:19:43 am
Use this url:

http://<drupal_root>/sites/all/modules/civicrm/bin/UpdateGreeting.php?name=<username>&pass=<pw>&key=<sitekey>

Kurund
Found this reply helpful? Support CiviCRM

Andrew Perry

  • I post occasionally
  • **
  • Posts: 98
  • Karma: 1
  • Building empowering tools that comply with rules
    • Community Builders Australia
  • CiviCRM version: 3.x, 4.x
  • CMS version: Joomla 1.0.x, 1.5.x -> Drupal 6.x, 7.x, WordPress
  • MySQL version: 5.1, 5.5, 5.6
  • PHP version: 5.2, 5.3, 5.4
Re: Mailing Labels are missing the contact name
February 25, 2010, 12:16:56 am
Sorry, but the inline documentation is a little unclear.

Is it more like:

http://<drupal_root>/sites/all/modules/civicrm/bin/UpdateGreeting.php?name=<username>&pass=<pw>&key=<sitekey>&ct=<contact_type>&gt=<greeting_to_update>&id=<id>?

I was about to do this and then suddenly was concerned that this would update all of the contacts and not just those who have not got their email_greeting set.  Is that the case?

If so, it would be great if there could be an option introduced so that you can just update blank ones as I have a client who has already gone through and selected what should be used for specific contacts depending on their preferences.
Community Builders Australia Pty Ltd
www.communitybuilders.com.au

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Mailing Labels are missing the contact name
February 25, 2010, 03:49:14 am
Sorry for the confusion, let me clarify:

Quote
http://<drupal_root>/sites/all/modules/civicrm/bin/UpdateGreeting.php?name=<username>&pass=<pw>&key=<sitekey>&ct=<contact_type>&gt=<greeting_to_update>
This will reset greeting type to default for all the contact whose greeting type is set.

Quote
http://<drupal_root>/sites/all/modules/civicrm/bin/UpdateGreeting.php?name=<username>&pass=<pw>&key=<sitekey>&ct=<contact_type>&gt=<greeting_to_update>&id=<id>
This will update greeting type specified using "id" param for all the contact whose greeting type is set.

Quote
http://<drupal_root>/sites/all/modules/civicrm/bin/UpdateGreeting.php?name=<username>&pass=<pw>&key=<sitekey>&ct=<contact_type>&gt=<greeting_to_update>&force=1
This will reset greeting type to default for all the contact.

Quote
http://<drupal_root>/sites/all/modules/civicrm/bin/UpdateGreeting.php?name=<username>&pass=<pw>&key=<sitekey>&ct=<contact_type>&gt=<greeting_to_update>&id=<id>&force=1
This will update greeting type specified using "id" for all the contacts

HTh
Kurund

Found this reply helpful? Support CiviCRM

dschafer

  • I post occasionally
  • **
  • Posts: 93
  • Karma: 3
    • Backoffice Thinking
  • CiviCRM version: 3.2.3 - 4.4.4
  • CMS version: Drupal 6.x, 7.x, Wordpress
  • MySQL version: 5.1.x - 5.5.x
  • PHP version: 5.2.x - 5.4.x
Re: Mailing Labels are missing the contact name
February 26, 2010, 12:11:40 pm
Hi,
If we run this update for addressee what will the addressee bet to?

Will they all bet set to {contact.individual_prefix}{}{contact.first_name} etc. ?

Also can we configure the default addressee format globally?

Thanks

dschafer

  • I post occasionally
  • **
  • Posts: 93
  • Karma: 3
    • Backoffice Thinking
  • CiviCRM version: 3.2.3 - 4.4.4
  • CMS version: Drupal 6.x, 7.x, Wordpress
  • MySQL version: 5.1.x - 5.5.x
  • PHP version: 5.2.x - 5.4.x
Re: Mailing Labels are missing the contact name
February 26, 2010, 01:42:10 pm
Ok to answer my own post--

I believe the addressee format will be set to default format for the contact type set in the addressee option list.

Also it appears that each time a new contact is entered the user must select the addressee format - the default is not assigned.

If there is only one format for the contact type will it be assigned?

Thanks

dschafer

  • I post occasionally
  • **
  • Posts: 93
  • Karma: 3
    • Backoffice Thinking
  • CiviCRM version: 3.2.3 - 4.4.4
  • CMS version: Drupal 6.x, 7.x, Wordpress
  • MySQL version: 5.1.x - 5.5.x
  • PHP version: 5.2.x - 5.4.x
Re: Mailing Labels are missing the contact name
February 26, 2010, 03:00:34 pm
OK - successfully ran UpdateGreeting.php. Can see that addressee_id on contact records is set correctly.

However when we select the "Make Mailing Labels" option - the labels come out without addressee field.

our label format is:
{contact.addressee}
{contact.street_address}
{contact.supplemental_address_1}
{contact.supplemental_address_2}
{contact.city}{, }{contact.state_province}{ }{contact.postal_code}

Any suggestions?

If addressee is cached - where - and how is it cleared?

Thanks

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Mailing Labels are missing the contact name
February 26, 2010, 03:08:16 pm
Quote from: dschafer on February 26, 2010, 01:42:10 pm
I believe the addressee format will be set to default format for the contact type set in the addressee option list.

Also it appears that each time a new contact is entered the user must select the addressee format - the default is not assigned.

If there is only one format for the contact type will it be assigned?


Addressee format should be set to default format for a that contact, AND the evaluated value saved to civicrm_contact.addressee_display column in the DB (this is were addressee is cached).

User should not HAVE to select an addressee format when using New Contact form to create a contact. The default should be used regardless of whether there are one or several addressee formats configured for a given contact type. I just retested on demo, adding a 2nd Individual Addressee format and making it the default (rather than the default default), and it works as expected. My new default was just first and last name. Then I added a contact, entered prefix, first and last name and hit save. The record is here:

http://drupal.demo.civicrm.org/civicrm/contact/view?reset=1&cid=1413

If you are able to recreate a different (unexpected) behavior on the demo, please file an issue w/ detailed steps.
Protect your investment in CiviCRM by  becoming a Member!

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Mailing Labels are missing the contact name
February 26, 2010, 03:12:33 pm
See above for DB location of cached addressee. Just tested mailing label output on demo w/ my 2 new records (Jason Sarris, Susan Sarris). I didn't enter any address fields - but the expected addressee values are there. (Jason Sarris was created with original default addressee format.)

Again, if you can recreate condition on demo where addressee is stored but doesn't show up in mailing label output, please file an issue. Otherwise, I guess some more debugging on your site - checking the DB table values etc. - is in order.

I think you've found this - but Addressee options are set here:
http://drupal.demo.civicrm.org/civicrm/admin/options/addressee?group=addressee&reset=1
Protect your investment in CiviCRM by  becoming a Member!

kmarkley

  • I post frequently
  • ***
  • Posts: 178
  • Karma: 14
  • CiviCRM version: 4.4.3
  • CMS version: Drupal 7.24
  • MySQL version: 5.1.56
  • PHP version: 5.3.27
Re: Mailing Labels are missing the contact name
February 26, 2010, 05:25:46 pm
If a contact is created via event registration (either front or back end), then none of the greetings are generated.  Edit/save (even with a name change) also does not trigger the generation of greeting/addressee.  Recreated on demo server.

I'm having an additional problem on my install in which UpdateGreeting.php appears to run fine (returning "Greeting is updated for contact(s). (Done)"), but none of the addressee fields are updated.  I am curious if it is related.  The majority of my contacts were created either by event registration or import.

Dave Greenberg

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 5760
  • Karma: 226
    • My CiviCRM Blog
Re: Mailing Labels are missing the contact name
February 26, 2010, 05:37:38 pm
Quote from: kmarkley on February 26, 2010, 05:25:46 pm
Edit/save (even with a name change) also does not trigger the generation of greeting/addressee.  Recreated on demo server.

I've asked Kurund to check in on other points - but for above, please clarify what exact URL's you are hitting when you say Edit/Save. (In general, when describing how to recreate a problem - url's are most helpful to clarify things).
Protect your investment in CiviCRM by  becoming a Member!
Pages: [1] 2
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Mailing Labels are missing the contact name

This forum was archived on 2017-11-26.