CiviCRM Tips and Tricks

Exporting Special Characters from CiviCRM to CSV

Does your data contain special characters such as accented letters or names with apostrophes? Have you exported that data in CSV format and found that those special characters have been made even more special (funky, actually)?

If so, there is a setting called "Language Encoding" located in CiviCRM under Administer > Localization > Languages, Currency, Locations that can be configured as "UTF-8" such that any special characters being exported to CSV will be preserved when you open the file.

Getting Wild(card) with Advanced Searching

CiviCRM Advanced Search offers two wildcard characters: the percentage symbol (%) and an underscore (_). A wildcard is a single character that can represent one or a number of characters or an empty string of unknown characters. For many of us, we are used to the asterisk (*) as being the wildcard character from old command line computers but in CiviCRM, the percentage symbol (%) and an underscore (_) are used. 

Extended Report - Price Set Line Items

When you first install CiviCRM, you are given the ability to create different Financial Types. Using the Price Set functionality, you can assign each item in the Price Set to a different Financial Type. For example, you might have an event with tickets, the option to sponsor, and the option to make an additional donation. Each of these items could be mapped to different Financial Types.  

4 Quick Tips for Using CiviMail

1. Text Over Images 

Many email users have their email client (e.g. Outlook, Apple Mail, Gmail) set to show text until they explicitly allow images. This means that the first look your email recipients have of your email is text only. Make a good impression with this. As an added bonus, this helps with not being considered SPAM and makes your email useful for those readers not able to see images at all.

2.  Resize Images