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"

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?

  • 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? Apr 22 '21 at 14:13
  • 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.
    – twowheeler
    Apr 22 '21 at 16:09
  • 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.
    – twowheeler
    Apr 22 '21 at 21:42
  • 1
    Similar issue maybe here: lab.civicrm.org/dev/core/-/issues/2566
    – Demerit
    Apr 26 '21 at 13:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.