CiviCRM Community Forums (archive)

Note that I found a similar, but old, discussion similar to this, but it didn't seem like it was resolved, and I couldn't find a solution that I could understand.
http://forum.civicrm.org/index.php/topic,12302.msg52890.html#msg52890


I'm using 3.4.2 in Drupal 6.

Using the standard addressee options, and the default mailing label address settings, most of my labels are missing the addressee. I imported most of the contacts. The only labels that seem to include an addressee are the people I've entered using the New Contact form, or people that already have a Drupal user account.

I've noticed that if I edit a contact that was imported, and go into Communication Preferences, the Addressee drop-down says "select". But when I create a new contact, the default is already selected.

What would be the easiest/best way to fix this so that all of the imported contacts have the default greetings?

Do I need to import another column for "Postal Greeting" with the following as the field content?
{contact.individual_prefix}{ } {contact.first_name}{ }{contact.middle_name}{ }{contact.last_name}{ }{contact.individual_suffix}

I tried the URL specified in the above discussion, but got a fatal error. I'm new to working with Drupal and CiviCRM, so I'm looking for a solution that is simple enough that even I can handle.

Thanks in advance for any advice you can give.

Import contacts does not set the Addressee values, so you do want to run the UpdateGreeting.php command line script to set the 'Addressee' values for your contacts to the default. Use Hershel's URL below, but you need to include two additional required parameters for the script, so it looks like this:

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

You should also review the wiki pages on running these command line scripts since you'll need to set "sitekey" for you site first:
http://wiki.civicrm.org/confluence/display/CRMDOC40/Command-line+Script+Configuration
http://wiki.civicrm.org/confluence/display/CRMDOC40/Update+Greetings+and+Address+Data+for+Contacts

I found a work around by using different tokens.
http://forum.civicrm.org/index.php/topic,535.0.html#msg83535

I don't feel like I know what I'm doing enough to add something to the documentation. But for us beginners, this would be great to have explained in the docs, and in the little help pop-up by the fields on the Address Settings page.

Thank you both, again, for your help.