Project

General

Profile

PrefixSuffix Mapping » History » Version 1

Jon Goldberg, 01/08/2015 11:13 PM

1 1 Jon Goldberg
{{lastupdated_at}} by {{lastupdated_by}}
2
3
h1. Prefix/Suffix Mapping
4
5
Here, we're referring to name prefixes like "Mr.", "Ms.", "Dr.", "Senator", and suffixes like "Esq.", "Sr.", "MD", and so on.
6
7
When editing an individual's prefix/suffix, CiviCRM requires you to pick from a list.  It's easy to edit, but is intended to 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.
8
9
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:
10
11
* If it is a valid prefix/suffix, please put "keep" in column 2.
12
* If it's an invalid prefix/suffix, please put "blank" in column 2.
13
* If it needs to be changed to something else, please put the new value in column 2.
14
15
Please see the remapping below for inspiration on standardizing!
16
17
| *Source value* | *Target value* |
18
|Bro.|Brother|
19
|Br.|Brother|
20
|Mr. Dean|Dean|
21
|DR|Dr.|
22
|DR.|Dr.|
23
|Doctor|Dr.|
24
|Dr|Dr.|
25
|dr|Dr.|
26
|Father|Fr.|
27
|Father|Fr.|
28
|Fr|Fr.|
29
|Judge|The Honorable|
Go to top