[feature request] update some fields on table based on a CSV

It would be nice if I can load a CSV file into HediSQL and, for each line, it can make an UPDATE on the table, based on a key chosen as the primary key.

Unless I missed something, now you can just insert whole lines (with some choice about how to override these lines when existent), but you can not update part of the rows.

For example, in a table with 10 fields, update only the price of a product starting from a csv in which there is a unique ID and the new price per row.

thanks,
Marco

That sounds like a very special feature, and will probably not used by many users, don't you think?

Frankly no, Navicat has this feature and this is the only reason I borrow a Mac at work :)

I work a lot in eCommerce. It happens very often that the site managers (or in general people from business departments) want to perform some bulk update of categories, pricing and more. They do not know anything about SQL, do not even know what a database is. They only know (basic) Microsoft Excel.

So, I export the data they need (maybe joining many tables) so they can identify their products and see some details (descriptions, categories etc).
Then I have to re-import the data. With Navicat I select the CSV column that matches the ID of the product (primary key of a table), then the column that corresponds to the price. Two clicks more and it's all updated in seconds.

Do not make me to buy a Mac just to update a database, please! :D

Prior to stamp my request as unnecessary, please ask if others need this functionality. I am sure that anyone using HeidiSQL and must interface with people who are not software engineers, will appreciate the ease of exchanging information by simply using CSV readable by Microsfot Excel / Openoffice / Google Drive.

Sorry, I can't find an "edit post" button.
There is an image as reference



In general, HediSQL interface and ease of use is way better than Navicat 7 for Mac (the version I use instead of HeidiSQL to manage CSV on a borrowed computer).
But CSV management is the only reason why I have not stopped completely using other software than HediSQL

Any news?
I've seen that's not really a "very special feature", there are several similar requests in this forum.
No support at all for new feature requests? :(

http://www.heidisql.com/forum.php?t=14700
http://www.heidisql.com/forum.php?t=673
http://www.heidisql.com/forum.php?t=11211

No, that just means I don't add every feature someone is asking for.

That approach is very different from the way HeidiSQL does the CSV import. HeidiSQL initially only supported the LOAD DATA command in MySQL, and provided a dialog for it. Later I added an alternative mode, where HeidiSQL itself parses the CSV file and inserts rows in the target table. This "update" mode needs a new dialog as I guess the current one is already too crowded to support even more things.