distal-attribute
distal-attribute
distal-attribute
distal-attribute

import text file dialog

User, date Message
Written by BubikolRamios
3 years ago
Category: Feature discussion
327 posts since Thu, 14 Jan 10
There should be 'truncate destination table' checkbox.

That would save enormous amount of time.

Imagine that you are clearing errors in source file. Each time you try again you have to manualy clear dest. table contence.
Written by ansgar
3 years ago
4986 posts since Fri, 07 Apr 06
Well, why not put that as a checkbox into the "Options" group box. Only I don't agree with that "enormous amount of saved time" but that's ok, that checkbox makes sense anyway.
Written by ansgar
3 years ago
4986 posts since Fri, 07 Apr 06
Done in r3964
Written by BubikolRamios
3 years ago
327 posts since Thu, 14 Jan 10
Pulling it down rigt away (-:
Written by BubikolRamios
3 years ago
327 posts since Thu, 14 Jan 10
Tested, it works, and remembers state of that check box, when I open it next time.

Could you do the same (remember) for test encoding one of these days, please.
Written by ansgar
3 years ago
4986 posts since Fri, 07 Apr 06
Remember last file encoding? Depends on the file you select, as there is some auto-detection.
Written by BubikolRamios
3 years ago
327 posts since Thu, 14 Jan 10
Auto does not work. It always selects UTF-8, while I have to allways manualy to do selection of cp1250.

1.leavea auto
2.import
3. x errors (hence, besides other thigs, my enormous amount of time from above (-:) --> not all get imported
4. luckily there is now truncate check box, manual select cp1250
5. and it works

my dest. table is utf8_slovenian_ci, also all columns. Files made under win7 (same thing under win xp)
Written by BubikolRamios
3 years ago
327 posts since Thu, 14 Jan 10
"It always selects UTF-8"
That is, I probably don't know what it selects, but it is surely wrong.
Written by ansgar
3 years ago
4986 posts since Fri, 07 Apr 06
Just looked after that in the code: Heidi fires a

SHOW CREATE DATABASE [selected db]

and detects the database charset here to preselect that in the pulldown (and calls it "Let server/database decide" - which is NOT always UTF-8 btw). Now, I can't do both - store your previous selection AND detect the db charset. But I think the current preselection is not the baddest idea.
Written by BubikolRamios
3 years ago
327 posts since Thu, 14 Jan 10
Well, i don't know how encodings realy works, It seems I always produce cp1250. And characters looks OK. If I try to switch into UTF-8 in text editor, some characers turns bad. So remembering last used encoding would be great.

Furthermore, I'm pretty sure that sort order in table dropdown is changing from version to version of HSQL. How can I tell ? I have a table , name starting with _, and before last update of exe it looked like HSQL remembers last used destination table. In newest version I have to scroll thru entire list of tables for each import.

Remembering that would be allso a +.
Written by ansgar
3 years ago
4986 posts since Fri, 07 Apr 06
Your database then seems to have a UTF-8 encoding. That's nice as you can store nearly every international character in that db without loss. On the other hand, you should adapt your file encoding to the encoding of your database, not cp1250.

Tables and databases are sorted alphabetically. The one which is "active" in HeidiSQL gets preselected in the import dialog, means: the table which was doubleclicked and visible in the table tab.
Written by BubikolRamios
3 years ago
327 posts since Thu, 14 Jan 10
Thanks for that inf.
 

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