MYsql Code in (HTML) Export

maeeh's profile image maeeh posted 12 years ago in Feature discussion Permalink
Hi All,

i am currently using the html-export very often to document some issues and i am really missing the source code of the query in the report as it was in the earlier versions of HeidiSQl (or was it SQLFront).
So I would like to suggest having an button in the export-screen giving the user the oppurtunity to choose wether the query-code is included in the output or not.

Greetings

Axel
ansgar's profile image ansgar posted 12 years ago Permalink
I'll check if that's doable.
maeeh's profile image maeeh posted 12 years ago Permalink
Thanx a lot Ansgar.

It would really help me rememebering which query i wrote for different purposes, as my Snippets-Folder is quite full with other often used queries.

But if it is not possible, no problem, notepad++ may help ;)
Code modification/commit from ansgar.becker, 12 years ago, revision 7.0.0.4180
Add "Include query" checkbox option onto grid export dialog. See http://www.heidisql.com/forum.php?t=10853
ansgar's profile image ansgar posted 12 years ago Permalink
Done in r4180, please try out that new checkbox.
jfalch's profile image jfalch posted 12 years ago Permalink
works well.

I think it should not be too difficult to enable this in XML as well (<query sql="...">) ...
maeeh's profile image maeeh posted 12 years ago Permalink
works like a charm, thanx a lot
ansgar's profile image ansgar posted 12 years ago Permalink

I think it should not be too difficult to enable this in XML as well ...



Not difficult. But is that right, just to put some additional XML element at the top?
Code modification/commit from ansgar.becker, 12 years ago, revision 7.0.0.4186
Tweak grid export dialog with some minor enhancements:
- Auto select ANSI encoding for Excel output, see http://en.wikipedia.org/wiki/Comma-separated_values#Application_support
- Auto modify file extension when selecting format
- Support "Include query" checkbox in XML format, see http://www.heidisql.com/forum.php?t=10853#p11082
- Imitate mysqldump's XML style, see http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html#option_mysqldump_xml
ansgar's profile image ansgar posted 12 years ago Permalink
r4186 now allows the "Include query" option for XML output. Also, I modified the XML style to imitate what mysqldump does, see http://dev.mysql.com/doc/refman/5.5/en/mysqldump.html#option_mysqldump_xml
jfalch's profile image jfalch posted 12 years ago Permalink
thank you.

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