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

Import csv

User, date Message
Written by BubikolRamios
3 years ago
Category: Feature discussion
326 posts since Thu, 14 Jan 10
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,...
Written by ansgar
3 years ago
4784 posts since Fri, 07 Apr 06
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.
Written by BubikolRamios
3 years ago
326 posts since Thu, 14 Jan 10
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.
Written by BubikolRamios
3 years ago
326 posts since Thu, 14 Jan 10
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.
Written by ansgar
3 years ago
4784 posts since Fri, 07 Apr 06
That's basically what issue #1379 already asks for.
Written by BubikolRamios
3 years ago
326 posts since Thu, 14 Jan 10
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.