Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Enhanced grid export

ansgar's profile image ansgar posted 9 years ago in News Permalink
Up to recently, to create a CSV export of a grid view, you had several menu items and you had to find the right one for your needs:
- Copy selected rows as CSV
- Copy selected rows as HTML
- Copy ... XML, SQL, LaTeX, Wiki markup
- Export grid rows to file
Only the CSV output was configurable in the preferences dialog - which was not in sight at the time when you did the export.

Now, there is only one menu item left in the context menu of any result grid: "Export grid rows". The new dialog which comes up
- asks whether to copy to clipboard or write to a file
- let's you select the file encoding (ANSI seems important for Excel export)
- offers an easy way to create Excel compatible output, which requires specific control characters, depending on the output target
- displays the row number and the byte size of the rows you are going to export
- shows recently used output files by click on the blue down arrow
- remembers your previously used settings, so you can normally call the dialog and just press the enter key to finish.

ansgar's profile image ansgar posted 9 years ago Permalink
Now that we have a dialog for export output options, I wonder if I should add another text input for a value used as NULL value. I guess "Excel compatible" should automatically use an empty string, while exporting a file which afterwards should be imported into MySQL again needs \N as NULL value.
malavikakswamy's profile image malavikakswamy posted 8 years ago Permalink
Hello I am not able to find the export grid rows option. Please could you tell me where exactly can I find it?
Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
malavikakswamy's profile image malavikakswamy posted 8 years ago Permalink
It is not highlighted for me under the Export tab in the main menu as well as not visible when I right click on any grid in the database.
ansgar's profile image ansgar posted 8 years ago Permalink
Rightclick any grid and find "Export grid rows". It is there if you have newer build, so be sure to stay up-to-date.

Please login to leave a reply, or register at first.