I want to import a large group of people and some of them have opted out of SMS communications and some have opted out of email communications. I have tried multiple ways of entering the fields in my CSV files and none of them will import properly. For example, I created a column "Do Not Email" and in the field for those who wanted do not want to receive email I put "YES" and the file imported properly, but the contact record does not say Do Not Email. What is the correct way to add this information?
1 Answer
Use the number "1" for yes and a blank for no.
One way to see this is if you do an export and then look at how it outputs it.
-
THANK YOU! Looked everywhere in the guides as to what values would work in the field.– CynthiaCommented Aug 30, 2019 at 1:40
-
1@cynthia Could you submit a documentation update? It's quite simple: docs.civicrm.org/user/en/latest/the-civicrm-community/…– Aidan ♦Commented Aug 30, 2019 at 8:21