Answers.Body: <p>Welcome to CiviCRM!</p>
  
  <p>For the import of Boolean fields (yes/no, true/false, check boxes, etc.) the correct syntax is 0 for no or false and 1 for yes or true. <strong>Use 1 instead of Y or YES</strong>, and it should work for you.</p>
  
  <p>Be aware that your imports thus far may have created NULL values in the database. See this question and answer for reference: <a href="https://civicrm.stackexchange.com/a/7396/105">https://civicrm.stackexchange.com/a/7396/105</a></p>
  
  <p>You'll want to check your database or have your admin check those values to make sure you've got 1s and 0s instead of NULL.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-01-04T07:24:37.263Z
Answers.LastActivityDate: 2016-01-04T18:50:03.843Z
Answers.LastEditDate: 2017-04-13T12:53:13.207Z
Answers.UserDisplayName: Allen Hutchison
Body: <p>I am a newby. </p>
  
  <p>Why would 'Do not Email' not be checked even though my import mapped and imported without error?</p>
  
  <p>It says it didn't have an error, but it must have imported with an error. I was able to force an import error message with data like "Checked".</p>
  
  <p>The import completed without error when the Do not Email column is Y. I think it even worked when it is YES. But the import hasn't actually changed the contacts' data.</p>
  
  <p><strong>How do I set up the import correctly for the 'Do Not Email' field?</strong></p>
  
  <p>Thanks. </p>
  
  <p>Johnny </p>
  
Tags: <import><field-mapping>
Title: How do I setup an import for the Do Not Email field?
ThreadText: # How do I setup an import for the Do Not Email field?
  
  (Asked by: username_0 on 2016-01-03)
  
  I am a newby.
  
  Why would 'Do not Email' not be checked even though my import mapped and imported without error?
  
  It says it didn't have an error, but it must have imported with an error. I was able to force an import error message with data like "Checked".
  
  The import completed without error when the Do not Email column is Y. I think it even worked when it is YES. But the import hasn't actually changed the contacts' data.
  
  **How do I set up the import correctly for the 'Do Not Email' field?**
  
  Thanks.
  
  Johnny
  
  **Tags:** import, field-mapping
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2016-01-04. Score: 2
  
  Welcome to CiviCRM!
  
  For the import of Boolean fields (yes/no, true/false, check boxes, etc.) the correct syntax is 0 for no or false and 1 for yes or true. **Use 1 instead of Y or YES**, and it should work for you.
  
  Be aware that your imports thus far may have created NULL values in the database. See this question and answer for reference: <https://civicrm.stackexchange.com/a/7396/105>
  
  You'll want to check your database or have your admin check those values to make sure you've got 1s and 0s instead of NULL.
  
  
  ---
  
  