Import csv

BubikolRamios's profile image BubikolRamios posted 12 years ago in Feature discussion Permalink
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's profile image ansgar posted 12 years ago Permalink
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's profile image BubikolRamios posted 12 years ago Permalink
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's profile image BubikolRamios posted 12 years ago Permalink
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's profile image ansgar posted 12 years ago Permalink
That's basically what issue #1379 already asks for.
BubikolRamios's profile image BubikolRamios posted 12 years ago Permalink
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.