We meet an issue that a csv with more than 10000 lines can only import the first 3000 lines, which is only 63 records.
After look into customers csv data, which is exported from a MySQL workbench, we found that a special part.
\”” exists in the line
That explains everything. In csv, \ and “ all work as escape character, “ is use to escape “ itself. So if one “ inside the “” needs to be written as “” ( one quote becomes two quote.
And there’s also an \ in front of “” which caused the issue.
How to resolve the issue:
Replace \”” with “”
Error message in the UI is
IOException reading next record: java.io.IOException: (line 2790) invalid char between encapsulated token and delimiter