Body: <p>After importing a CSV file of contacts, the rows with errors can be downloaded and fixed. Today I noticed that the &quot;Reason&quot; column is missing from this error list. For example the Import_errors.csv file might contain this:</p>
  <pre><code>    &quot;Line Number&quot;,&quot;Reason&quot;,&quot;First Name&quot;,&quot;Last Name&quot;,&quot;Email - Home&quot;
      &quot;1&quot;,&quot;Joe&quot;,&quot;Blow&quot;,&quot;joe@example.com&quot;
  </code></pre>
  <p>So in this example there are 5 column headers but only 4 data elements. That is consistently how these files appear, one column is missing. This is Civicrm 5.35.1 on Wordpress 5.7.1. Any ideas?</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-04-22T14:13:41.750Z
Comments.Text: I do see reason on error csv when importing on 5.35.1. Do you know any specific reason why the row failed to import after going through the record?
Comments.UserDisplayName: Pradeep Nayak
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-04-22T16:09:27.350Z
Comments.Text: The above is just an example. Earlier today I imported 4 CSV files and got an error listing from all 4, with a total of 28 error records which is approximately 20% of the import. All 4 were missing the reason column as described. Without a stated reason it is hard to tell what went wrong but I will look for a pattern and post an update. Based on your experience with 5.35.1 though, it sounds like it is an issue with my data or my installation. I don't know how to debug that.
Comments.UserDisplayName: twowheeler
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-04-22T21:42:53.583Z
Comments.Text: Here is the update: All of the errors I checked were due to duplicate records in the database. The dupes appear to be all coming from the Woocommerce-Civicrm plugin, so that is a separate issue. But this does not explain why the import errors file is missing the reason code for duplicate records.
Comments.UserDisplayName: twowheeler
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2021-04-26T13:28:18.697Z
Comments.Text: Similar issue maybe here: https://lab.civicrm.org/dev/core/-/issues/2566
Comments.UserDisplayName: Demerit
Tags: <contacts><import>
Title: Reason column missing from contact import error list
ThreadText: # Reason column missing from contact import error list
  
  (Asked by: username_0 on 2021-04-22)
  
  After importing a CSV file of contacts, the rows with errors can be downloaded and fixed. Today I noticed that the "Reason" column is missing from this error list. For example the Import_errors.csv file might contain this:
      "Line Number","Reason","First Name","Last Name","Email - Home"
      "1","Joe","Blow","joe@example.com"
  
  So in this example there are 5 column headers but only 4 data elements. That is consistently how these files appear, one column is missing. This is Civicrm 5.35.1 on Wordpress 5.7.1. Any ideas?
  
  **Tags:** contacts, import
  
  > **Comments:**
  > **username_1**: I do see reason on error csv when importing on 5.35.1. Do you know any specific reason why the row failed to import after going through the record?  
  > **username_0**: The above is just an example. Earlier today I imported 4 CSV files and got an error listing from all 4, with a total of 28 error records which is approximately 20% of the import. All 4 were missing the reason column as described. Without a stated reason it is hard to tell what went wrong but I will look for a pattern and post an update. Based on your experience with 5.35.1 though, it sounds like it is an issue with my data or my installation. I don't know how to debug that.  
  > **username_0**: Here is the update: All of the errors I checked were due to duplicate records in the database. The dupes appear to be all coming from the Woocommerce-Civicrm plugin, so that is a separate issue. But this does not explain why the import errors file is missing the reason code for duplicate records.  
  > **username_2**: Similar issue maybe here: https://lab.civicrm.org/dev/core/-/issues/2566  
  
  ---
  
  ## 0 answers
  
  