Import Table Data: automatic mapping between table and file columns
a
anonymous
started a topic
almost 17 years ago
[This topic is migrated from our old forums. The original author name has been removed]
Hi there,
I use the "Import Table Data" function quite often and manual mapping between table and file columns is a real time killer.
So it would be very nice, if DBVis could do that for me.
Using exactly the same column names in the CSV as they are named in the table, should make it possible to match them. Right now, the suggested columns form the CSV are simply top down. So a name is suggested for the id in the table and so on.
Is this already possible and just a bug with informix? If not, it would make my databaselife a lot easier
Re: Import Table Data: automatic mapping between table and file columns
Hi Dirk,
I'll add this as a request for enhancement.
Thanks!
Regards
Roger
a
anonymous
said
over 16 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Import Table Data: automatic mapping between table and file columns
Hi Roger,
I'd love to see this feature in 6.1 :)
Automatic encoding detection is another enhancement, I'd like to see with this feature.
Thanks and keep up the good work!
Dirk
Roger Bjärevall
said
over 16 years ago
[This reply is migrated from our old forums.]
Re: Import Table Data: automatic mapping between table and file columns
Dirk,
This is fixed in 6.0.9.
http://www.minq.se/products/dbvis
Regards
Roger
a
anonymous
said
over 16 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Import Table Data: automatic mapping between table and file columns
Thanks for adding this feature so quickly! This is a real timesaver!
anonymous
I use the "Import Table Data" function quite often and manual mapping between table and file columns is a real time killer.
So it would be very nice, if DBVis could do that for me.
Using exactly the same column names in the CSV as they are named in the table, should make it possible to match them. Right now, the suggested columns form the CSV are simply top down. So a name is suggested for the id in the table and so on.
Is this already possible and just a bug with informix? If not, it would make my databaselife a lot easier
Dirk