3

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","[email protected]"

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?

Improve this question
4
  • 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?
    – Pradeep Nayak
    Commented Apr 22, 2021 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
    Commented Apr 22, 2021 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
    Commented Apr 22, 2021 at 21:42
  • 1
    Similar issue maybe here: lab.civicrm.org/dev/core/-/issues/2566
    – Demerit
    Commented Apr 26, 2021 at 13:28

0

Reset to default

Your Answer

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

Browse other questions tagged or ask your own question.