When importing, Induvidual Prefixes don't seem to "take" and apply. Why is this, and how does one get around it?

2 Answers 2


Why?, well I have no idea (sorry to dissapoint!)

How to get around - well, it would appear that civi requires the numeric Value (1,2,3), rather than the label (Mr, Mrs etc) for the option. To find the values for substitution one can go to:

administer > System Settings > Option Groups

and hit the "options" link to the right of "Individual Contact Prefixes". The prefixes in your csv will need to be substituted with these values.

Hope that helps...

  • As of 4.6.14 Civi is looking for the label (e.g. 'Mr') , not the value. But of course the matching has to be exact, as Aidan points out below
    – Andy Clark
    Commented Mar 16, 2016 at 12:33

Make sure the prefixes in the import exactly match the ones configured. If you have "Mr." configured but the import has "Mr", the record is imported without error but the prefix is not set (as of 4.6.10)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.