CSV import – error I can’t resolve

  • cranky613

    (@cranky613)


    2 years, 4 months ago

    Hi — Forgive me if this is lengthy but I hope to give you an accurate picture of the issue — and I’ve combed through all your excellent documentation and the forum for info on CSV imports, but haven’t found a resolution to my issue.

    I have a CSV file on 850 records (about 300 KB). It’s very text-heavy, so I’ve converted all the apostrophes, single- and double-quotes to the html codes as instructed. I’ve double-checked my headers match those of the db parameters. Still, I am only able to import about 70 records before I get the following error message:

    Import Complete:
    69 records added
    1 record skipped due to errors
    69 records imported
    Import terminated due to error on line 2

    I’ve combed through everything on line 2 (record 2?) and found no issue; in fact record 2 was imported perfectly.

    I’ve dumped the data and reloaded it; I’ve tweaked some accented characters to html codes; combed through my data with a fine-toothed comb. (Aarrgh!!)

    I know that I’m repurposing this plugin for something very different from its intended purpose, but your database offers all the features and customization capabilities I’m looking for and had been working perfectly for the past 7 years. Only the latest WP and plug-in updates have cacked me out.

    I’m not a programmer at all — only a librarian-nerd and hobbiest. I have worked with some databases in the past. Help?

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

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

    (@xnau)

    2 years, 4 months ago

    I know that the error messaging here does not provide much detail, that is because the process is running in the background and the code that detects the problem doesn’t have a way to know what the specific problem was. This message means there was an issue with the import (such as a failed field validation), not with the data in the CSV…you’d see a different message if that was the case.

    To get more information about what happened, you’ll need to look at the php error log. the plugin debugging log could possibly catch it, but it’s not guaranteed.

    If the error is a validation error, then what that means is you have a field that has a validation of some kind set up on it, and the incoming data is not validating. Check to make sure all the data that is coming in is valid for all the fields that have validation.

    Check the Manage Database Fields page to see the validation configuration for the fields you’re importing data to.

    Thread Starter cranky613

    (@cranky613)

    2 years, 4 months ago

    Thanks for this… I’ll go through the field parameters to make sure I’ve got the validations properly set. I’m not sure I can understand the debugging logs, but with this info, it may give me a clue. Many thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘CSV import – error I can’t resolve’ is closed to new replies.

Tags