csv import plugin error
8 posts by 4 authors in: Forums > CMS Builder
Last Post: June 4 (RSS)
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
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!
Senior Web Programmer
Interactivetools.com
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
Hi Kenny,
Can you send in a 2nd level support request and we'll take a look? https://interactivetools.com/support/request/
Also, feel free to include steps to reproduce the "never" date issue or anything else as well, and we'll resolve and patch as needed or advise what the issue might be.
Thanks!
interactivetools.com
Hi Rez,
We're working on updating it to work with the latest CMSB version.
Can you try the beta zip here of CSV Import and let me know if that one works for you or returns any errors?
https://interactivetools.com/plugins/csv-import/
Note that it requires CMSB v3.76
Let me know any questions, thanks!
interactivetools.com
Hi All,
We've released CSV Import 1.18 to address this issue: https://interactivetools.com/plugins/csv-import/
Let me know if you need anything else, cheers!
interactivetools.com