csv import problem

  • Mary Ahern

    (@maryahern)


    12 years, 12 months ago

    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://ww.wp.xz.cn/extend/plugins/participants-database/

Viewing 1 replies (of 1 total)
  • Plugin Author xnau webdesign

    (@xnau)

    12 years, 12 months ago

    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.

Tags