A case of csv upload failure caused by \”” exists

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