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

Import csv

BubikolRamios posted 3 years ago in Feature discussion
Sometimes I would like HEIDI sql to be able to create table on the fly.


That is, if I feed .csv file to it, that there would be option - auto create table where you would tell new table name, columns would be by default named forinstance col1,col2,...
ansgar posted 3 years ago
Table creation is a complex task, which you can see in the table designer. Doing that "on the fly" would hide tons of settings you have, starting with column types, ending with foreign keys.
BubikolRamios posted 3 years ago
I ment default type for colmuns varchar, and the table would be temporary, no indexes, ...

Reason, forinstance , to remove/ignore one or several not important colums, which is easy done with sql, and hard with anything else.
BubikolRamios posted 3 years ago
Or, another way to make it happen:

Adding option to choose which columns to import. Heidi sql could show how many are there in .csv, from which we would be able to pick which. Like 3 of them if dest table has 3 target columns.
ansgar posted 3 years ago
That's basically what issue #1379 already asks for.

BubikolRamios posted 3 years ago
may I suggest that you put under:
"ignore first 0 lines"
something like
"ignore columns: 1,4,7"

that would be peace of cake implementing, I presume.

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