Importing fails when trying to import a csv file which looks something like the following:

Id;Name
223;"D'land"

The Name contains a single quote ' and the resulting SQL command looks like this:

INSERT INTO {import_ct_clients} (Id, Name) VALUES(223,'D'land');

This obviously fails because of the extra quote in the statement... The fix I'm guessing is to automatically escape any existing quotes (addslashes function?).

Ben

Comments

kartelusm’s picture

kartelusm commented

Yes, tnx. I'll implement utf8_encode(addslashes(...)) line for the text field in the next release.

kartelusm’s picture

kartelusm commented
Status: Active » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.