CiviCRM Community Forums (archive)

We serve an international membership and part of that is the publication of a magazine.  We've run into an issue with the mailing label formatting that CiviCRM provides.

For OCR compatibility a major requirement these days is that the "Country" be all uppercase, and in most cases the line that the postal code is on also be all uppercase.  Some nations now request that all lines be that way (United States Postal Service for one!).  We rely upon the Universal Postal Union for our guidance.. www. upu. int.

Alas out of the box CiviCRM currently uses upper and lowercase.  May we suggest for starters that the Country and State/province tables be made all uppercase. 

We've "fixed" it on our install by running via phpMyAdmin

UPDATE `civicrm_country` SET name = UPPER ( name )
and
UPDATE `civicrm_state_province` SET name = UPPER ( name )
respectively.

Hi,

Would suggest not to fix the data in the DB (most of the time you'd want the lower case, eg on screen as it's more readable and take less space.

What I'd suggest doing it to fix the PHP code that generates the mailing labels to uppercase the name of whatever you need.

Something that would be even more versatile is to improve the token syntax so you can add an extra param, eg: {contact.country|uppercase}

FIY here in Europe, most of the letters & magazines I receive are with the country not all uppercase.

Have created a ticket re the above with a patch

http://issues.civicrm.org/jira/browse/CRM-10571