Title: csv import problem
Last modified: August 21, 2016

---

# csv import problem

 *  [Mary Ahern](https://wordpress.org/support/users/maryahern/)
 * (@maryahern)
 * [13 years, 4 months ago](https://wordpress.org/support/topic/csv-import-problem-3/)
 * I installed customized and populated the Participants Database when making my
   demo presentation to the client. Now that I have the job I’m having trouble with
   the install. Initially under List Display Settings a drop down menu for “Single
   Record Link Field” was unavailable even though I was able to import my list of
   200 records.
 * Deactivating & reactivating the plugin did not return the setting. So I deleted
   the plugin and reinstalled it and reconfigured all my settings. The “Single Record
   Link Field” returned thankfully.
 * However, now attempting to import the same .csv file that previously loaded I
   repeatedly get the following error message:
 * “The number of items in line 20 is incorrect.
    There are 11 and there should 
   be 10.”
 * upon which the plugin only imports a few records and then halts.
 * Is there perhaps some left over coding that is preventing my imports? Where should
   I be looking for cruft in order to have a completely clean install since I know
   this program actually works very smoothly.
    Thanks, …mary
 * [http://wordpress.org/extend/plugins/participants-database/](http://wordpress.org/extend/plugins/participants-database/)

Viewing 1 replies (of 1 total)

 *  Plugin Author [Roland Barker](https://wordpress.org/support/users/xnau/)
 * (@xnau)
 * [13 years, 4 months ago](https://wordpress.org/support/topic/csv-import-problem-3/#post-3817028)
 * Typically, the cuplrit with this problem is a comma in an unenclosed data field.
   I assume you looked at line 20 of your CSV? What you are looking for are commas,
   apostrophes and quotes—these are the troublemakers. They need to be enclosed (
   quoted, in other words) or changed to their HTML entity values if they are in
   a data field. Also, of course, count the commas…there has to be exactly 9 (the
   number of fields – 1) unenclosed commas per line.

Viewing 1 replies (of 1 total)

 The topic ‘csv import problem’ is closed to new replies.

 * ![](https://ps.w.org/participants-database/assets/icon-256x256.jpg?rev=1389807)
 * [Participants Database](https://wordpress.org/plugins/participants-database/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/participants-database/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/participants-database/)
 * [Active Topics](https://wordpress.org/support/plugin/participants-database/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/participants-database/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/participants-database/reviews/)

## Tags

 * [csv](https://wordpress.org/support/topic-tag/csv/)
 * [Import](https://wordpress.org/support/topic-tag/import/)

 * 1 reply
 * 2 participants
 * Last reply from: [Roland Barker](https://wordpress.org/support/users/xnau/)
 * Last activity: [13 years, 4 months ago](https://wordpress.org/support/topic/csv-import-problem-3/#post-3817028)
 * Status: not resolved