Enhanced grid export

User, date Message
Written by ansgar
2 years ago
Category: News
4026 posts since Fri, 07 Apr 06 		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.
Written by ansgar
2 years ago
4026 posts since Fri, 07 Apr 06 		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.
Written by malavikakswamy
2 years ago
9 posts since Mon, 18 Jul 11 		Hello I am not able to find the export grid rows option. Please could you tell me where exactly can I find it?
Written by malavikakswamy
2 years ago
9 posts since Mon, 18 Jul 11 		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.
Written by ansgar
2 years ago
4026 posts since Fri, 07 Apr 06 		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.