Import not working

  • We are having trouble with importing new records via CSV. We do this monthly and haven’t had trouble with it in the past. We’ve documented the process and follow it routinely.

    We begin the process by deleting all records, then proceed with the import.

    Unlike previous imports, today we received an error “Incorrect columns found in CSV:….Cannot import data. Make sure all field names are correct in the CSV header” We looked back at previous imports and those headers were included the imported file previously, but we never received an error. We removed those columns from the CSV and tried again. The import did run as expected, but once imported, the dialog box shows the message “924 lines received. The data is importing in the background, refresh the page to get the current status of the import” A refresh of the screen removes that message.

    When looking at the “List Participants” screen, there are no records.

    I rolled back the plugin to v2.0.5 and v2.0.4 and tried again, but no luck.

    For what it is worth, we are also running Participants Database Combination Multi Search and participants Database Locations Map.

    Suggestions?

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

    (@xnau)

    Well first, the error message you’re getting usually means the column names are misspelled or have unexpected characters. The integrity check is not new, but previously, the import would ignore columns that didn’t match the defined columns. Now, it lets the user know it found them so it can be fixed.

    As to the failed import, I’m afraid I don’t have an explanation for that. There was a major change to the import code in version 2.0 which allowed for very large data imports to be imported in the background. If there is a problem in the background code the best way to see what happened is to look at the php error log.

    You may be able to see the error in the Plugin Debugging Log, but more likely you’ll need to look in the php error log which is set up on your server.

    I’m sorry for the inconvenience here, I’m eager to find out what happened, but for the sake of getting a successful import, you may have to roll back to 1.9.7.8

Viewing 1 replies (of 1 total)
  • The topic ‘Import not working’ is closed to new replies.