PrefixSuffix Mapping » History » Revision 2
Revision 1 (Jon Goldberg, 01/08/2015 11:13 PM) → Revision 2/3 (Jon Goldberg, 01/08/2015 11:14 PM)
{{lastupdated_at}} by {{lastupdated_by}}
h1. Prefix/Suffix Mapping
Here, we're referring to name prefixes like "Mr.", "Ms.", "Dr.", "Senator", and suffixes like "Esq.", "Sr.", "MD", and so on.
When editing an individual's prefix/suffix, CiviCRM requires you to pick from a list. It's easy to edit, but is intended to avoid the common situation of seeing "Mr", "Mr.", "MR.", and "mr." all in the same database. When I migrate your data from another system, I can automatically remap your prefixes/suffixes to standardize them, drop bogus prefixes/suffixes, and add unusual but legit prefixes/suffixes to your CiviCRM list.
You should have in your ownCloud folder (or an e-mail from me) two files - one called "invalid prefixes.csv" and the other "invalid suffixes.csv". Please open them in a spreadsheet program (Excel, LibreOffice Calc, Google Spreadsheets, etc.) and place the following in column B:
* If it is a valid prefix/suffix, please put "keep" in column 2.
* If it's an invalid prefix/suffix, please put "blank" in column 2.
* If it needs to be changed to something else, please put the new value in column 2.
Please see the remapping below for inspiration on standardizing!
| *Source value* | *Target value* |
|Bro.|Brother|
|Br.|Brother|
|Mr. Dean|Dean|
|DR|Dr.|
|DR.|Dr.|
|Doctor|Dr.|
|Dr|Dr.|
|dr|Dr.|
|Father|Fr.|
|Father|Fr.|
|Fr|Fr.|
|Judge|The Honorable|
Go to top