CSV Import error in CSV FIle

  • fmlynet

    (@fmlynet)


    8 years, 10 months ago

    I am trying out this plugin on a test website I have set up. I am trying to import a CSV file to see if it will work. I have counted the delimiters, files, and even re-imported the CSV file. It comes back into Excel perfectly formated. I get the following errors:
    New columns imported from the CSV file.
    The number of items in line 1 is incorrect.
    There are 10 and there should be 11.
    Zero records imported

    There are 11 items in the header line and each line after that. I have tried adding and subtracting from the header line and the number just increases and decreases by one.

    The page I need help with: [log in to see the link]

Viewing 1 replies (of 1 total)
  • Plugin Author Roland Barker

    (@xnau)

    8 years, 10 months ago

    OK, it looks like the problem is in the first record after the header. If you’ve got anything like commas or quotes in your data, it has to be properly enclosed. Usually, this is done with double quotes, then make sure your enclosure character is double quotes.

    If you want to send the first few lines to me as a csv attached to the email, I’ll take a look at it. [email protected]

Viewing 1 replies (of 1 total)

The topic ‘CSV Import error in CSV FIle’ is closed to new replies.