Start a new topic

Import Table Data: automatic mapping between table and file columns

[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


Dirk

[This reply is migrated from our old forums.]

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
[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
[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
[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!