1

I prepared a CSV for upload. I'll have to make multiple passes on the upload because I have single entry items and multiple entry data in the spreadsheet. I have created all of my custom fields. I can do a standard contact import with the unsupervised rule.

I see that I need an ID number for the multi-record import. I installed the CSV Import Helper to prepare for the multi-record import. When I select the CSV (I'm using the ; for my field delimiter) I get the DB error: unknown error from CiviCRM.

I'm on WordPress with CiviCRM 5.20.1

The only error I see in the Civi error log is :

[26-Feb-2020 16:20:05 UTC] PHP Notice: Undefined index: SERVER_NAME in /home/websiteweb/public_html/wp-content/plugins/LayerSlider/classes/class.km.autoupdate.v3.php on line 75

[26-Feb-2020 16:20:06 UTC] PHP Warning: session_start(): Cannot start session when headers already sent in /home/websiteweb/public_html/wp-content/plugins/civicrm/civicrm.php on line 364

My end goal is to merge the contact IDs into the data set so I can proceed. Any advice is welcome.

2

The issue was unrelated to the log error, which we will debug at a future time.

The problem was caused by my preferred use of a semicolon ";" as a delimiter instead of a comma ",". I frequently use the semicolon because clients frequently include commmas in names and addresses. Apparently this disambiguation was a problem for the CSV Import Helper.

| improve this answer | |

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.