PT Commons

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