[Plugin: CSV Importer] Imported 0 posts and 0 comments in 0.02 seconds.

  • mattspaeth

    (@mattspaeth)


    12 years ago

    I have the latest version of this plugin installed and I am getting this error. My first attempt at running the plugin, I didn’t have the correct headings on the columns and the plugin registered that it read the entries but was not able to pull data. Now, I have the columns correctly labeled and it keeps giving me the ‘Imported 0 posts and 0 comments in 0.02 seconds.’ message.

    What should I check to troubleshoot?

    Edit: I even tried importing sample.csv so I would know if there is a problem with my file or the plugin installation. It did not work, same message. So it’s a problem with the plugin. I tried deleting and reinstalling, still not working.

    http://wordpress.org/extend/plugins/csv-importer/

Viewing 4 replies - 1 through 4 (of 4 total)
  • cheey2003

    (@cheey2003)

    12 years ago

    Hi Matt,

    You will need to make sure that the CSV file is in the right format as unfortunately CSV files created with Excel will not make the grade (from my experience).

    When you open the sample.csv in the Notepad, you will notice that there is need for quote delimiter, in order the CSV importer to work properly 🙂

    Eg.
    Sample.csv
    “Field_1″,”Field_2″,”Field_3”

    CSV created with Excel
    Field_1,Field_2,Field_3

    Thread Starter mattspaeth

    (@mattspaeth)

    12 years ago

    Thanks Cheey,

    I am trying to use a CSV I exported from a Bento database, which apparently doesn’t make the grade either. I looked at the file and it only had one of fields quote delimited, probably because this field contains paragraphs of text.

    Do you know of any tools I could use to either import and export a better formatted CSV? Or alternatively, an application that processes CSVs to change delimiting?

    Thanks,
    Matt

    sebestenyb

    (@sebestenyb)

    11 years, 11 months ago

    I had the same issue, and turned out that in my case the issue was caused by a php setting, and that I used Mac to create the CSV.

    auto_detect_line_endings

    I put the following lines in to the .htaccess:

    php_flag auto_detect_line_endings On

    Cheers, Sebi

    Iroquois Twist

    (@anthonyccl)

    11 years, 11 months ago

    In newer versions of Excel you can select “Windows Comma Separated (.csv)” which appears to work.

    I’ve successfully imported an Excel 2011 csv using this method (on OSX 10.7).

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘[Plugin: CSV Importer] Imported 0 posts and 0 comments in 0.02 seconds.’ is closed to new replies.