csv import plugin error

4 posts by 3 authors in: Forums > CMS Builder
Last Post: Yesterday at 11:25am   (RSS)

By KennyH - Thursday at 5:28pm

On a new 3.76 install, I am getting an error after importing a file using CSV Import 1.17, selecting various options such as updating duplicates, and then clicking Import

There was an error sending the request! (200 parsererror)" with additional details about a syntax error with unexpected token 'E'

Advanced Options showing:

  • Use ID Field set to domain_name (with note about duplicate records)
  • Update Duplicates option to update existing records instead of adding them again

It says, "Duplicates Found: 0 (will be updated instead of added)" however they are all duplicates and should be updated instead of added.

Thanks,

Kenny H

Attachments:

Screenshot 2025-05-15 182519.jpg 59K

By Tim - Thursday at 6:32pm

Hi Kenny,

The file you are trying to import, is it a file that you first exported from the table using something like the csvExport plugin? If you export it and then try to immediately import (without changing anything) do you still get the error?

Also, if you check the developer logs in CMSB, do you see any new errors related to this?

Any additional error messages you can provide from the developer logs and details about how the file you are trying to import was created can be a big help.

Thanks!

Tim Hurd
Senior Web Programmer
Interactivetools.com

By KennyH - Yesterday at 8:15am

Hi Tim - 

The first file that triggered this problem was just a generated notepad document with 4 columns of information that has been uploaded hundreds of times without issue before 3.76 (no exaggeration).

I did some further investigating per your suggestion and found the same problem with a file exported and then imported immediately into the same table. Same exact error.

I didn't see this before, but I got an error dated "never" (as is typical of any errors I have been getting lately) that says this:

#3192 - Warning: Undefined array key ""
/home2/xxxxxxxx/domains/xxxxxxxx.dev/public_html/webadmin/lib/upload_storage_strategy.php on line 110
https://www.xxxxxxxx.dev/webadmin/admin.php

Thanks,

Kenny H