{{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|