Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Import CSV buggy

theking2's profile image theking2 posted 5 days ago in General Permalink

When I attempt to import a CSV file I get an error in the CSV layout detection. What should I do to import a CSV table

1 attachment(s):
ansgar's profile image ansgar posted 5 days ago Permalink

You can always create the table using the table designer, before you import a csv file.

But I'm curious: could you post some lines of that csv file here (or pm me)? I would like to fix that crash.

theking2's profile image theking2 posted 5 days ago Permalink

I've added the first four datasetz

1 attachment(s):
theking2's profile image theking2 posted 5 days ago Permalink

But for the error to happen it needs a bit more lines....

1 attachment(s):
ansgar's profile image ansgar posted 4 days ago Permalink

Notepad++ detects the file encoding as UTF-8. But I believe there is one broken non-UTF8 character in it:

Description

After replacing it (via Notepad++) with an 'รค', I could successfully import the file.

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




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.