Answers.Body: <p>The issue was unrelated to the log error, which we will debug at a future time.</p>
  
  <p>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.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-02-26T18:44:47.500Z
Answers.LastActivityDate: 2020-02-26T18:44:47.500Z
Answers.UserDisplayName: LyonsDigital
Body: <p>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.</p>
  <p>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.</p>
  <p>I'm on WordPress with CiviCRM 5.20.1</p>
  <p>The only error I see in the Civi error log is :</p>
  <blockquote>
  <p>[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</p>
  <p>[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</p>
  </blockquote>
  <p>My end goal is to merge the contact IDs into the data set so I can proceed. Any advice is welcome.</p>
  
Tags: <contacts><import><data-import><csv>
Title: I need some help resolving db error:unknown error CSV Import helper when selecting a CSV from my desktop
ThreadText: # I need some help resolving db error:unknown error CSV Import helper when selecting a CSV from my desktop
  
  (Asked by: username_0 on 2020-02-26)
  
  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.
  
  **Tags:** contacts, import, data-import, csv
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2020-02-26. Score: 2 | Accepted answer
  
  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.
  
  
  ---
  
  