Cannot import CSV

[expired user #7556]'s profile image [expired user #7556] posted 10 years ago in Import/Export Permalink
I am using Windows 8.1 64-bit, MySQL 5.6.15, HeidiSQL 8.2.4690 and I'm trying to import a CSV file but it is failing with the error below.



I have successfully imported this file using Sequel Pro on a Mac OSX machine, with Western (Windows Latin 1) encoding, which I assume the below is the equivalent of.



This is the table setup.



A typical line of the CSV is

http://gyazo.com/8ebcb5530fb3a90d0b3daea0d50d9c37


What is happening?
[expired user #7556]'s profile image [expired user #7556] posted 10 years ago Permalink
Ok, well I managed to mess up my first post pretty badly and I can't see an edit button. What is meant to be in the first post:




AB1 0AA,57.101478,-2.242852,385386,801193,NJ853011,"","Aberdeen City","Lower Deeside Ward", S12000033,S13002484,Scotland,S99999999,"Aberdeen South",1980-01-01,1996-06-01,"","",,,"","",""
BubikolRamios's profile image BubikolRamios posted 10 years ago Permalink
Heidi sql does have some issuses with files format & encoding.
First try with 'client parses file content' option.

But in any case check manualy if all rows were imported, even if all goes witout any error !

Check also if '(' in file path is doing problems.
[expired user #7556]'s profile image [expired user #7556] posted 10 years ago Permalink

Heidi sql does have some issuses with files format & encoding.
First try with 'client parses file content' option.

But in any case check manualy if all rows were imported, even if all goes witout any error !

Check also if '(' in file path is doing problems.



Sorry for late reply but thanks for the help. I moved the file to a different location so it didn't have the '(' and it worked perfectly.
ansgar's profile image ansgar posted 10 years ago Permalink
'(' and ')' in the filename are not your problem. It's the "escape" control character, which must not be the same character as the "field encloser". You have selected " for both, but the LOAD command needs different chars here to work properly.

There is no file encoding problem here, and HeidiSQL does not have "some issues" with encodings, or at least very few. In this case the servers LOAD command is the one to blame.

Please login to leave a reply, or register at first.