HeidiSQL Linux CSV import to new table autodetection does not work

FeverBeaver's profile image FeverBeaver posted 4 weeks ago in Import/Export Permalink

Hello,

I've tried to import a CSV table to MariaDB using the "import to new table" feature, and autodetection does not work. The code remains mostly empty, and clicking on "file analysis" makes the "please wait" (spindle) mouse cursor show for half a second, then nothing happens.

Is there a bug here? Importation parameters are correctly set (separator and all).

HeidiSQL is 12.17.1.1, but was the same with previous version (12.15 ?).

Best regards, Guillaume

2 attachment(s):
  • Capture-d-cran-du-2026-04-18-12-09-08
  • Capture-d-cran-du-2026-04-18-12-09-08
FeverBeaver's profile image FeverBeaver posted 4 weeks ago Permalink

Sorry, the button is "Scan file" in English. Does not work either.

ansgar's profile image ansgar posted 4 weeks ago Permalink

The parser in that dialog uses the control characters in the underlying import dialog:

grafik.png

I guess yours do not match the file you are trying to parse?

FeverBeaver's profile image FeverBeaver posted 3 weeks ago Permalink

Hi Angsar,

Thanks for your hint, that was it, I failed the end of line char. Sorry.

Best regards, Guillaume

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