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.

Placeholder in Export grid rows filename

simbabque's profile image simbabque posted 7 years ago in Import/Export Permalink
Hi there,

is it possible to have placeholders/variables in the filename I specify in the Export grid rows dialogue? I'd like to do multiple exports of the same query at different points of time. It would be great if I could just have a timestamp in the filename automatically.

Maybe this is already there and I haven't found the doc yet. If not, I'd like to suggest that.

Thanks a lot!
ansgar's profile image ansgar posted 7 years ago Permalink
Not yet. It's in the more comprehensive SQL export (Tools > Export database), but not in the grid export dialog. Nice idea. However, that needs to be documented somewhere in the dialog itself. Suggestions on how that could look like?
kalvaro's profile image kalvaro posted 7 years ago Permalink
Funny, you get a pretty obvious tooltip that informs you about the feature but I had never noticed it.

Komodo IDE has a handy drop-down list that accomplishes two goals:

1. Tells you about the feature
2. Allows to insert tokens

I think it's a pretty handy GUI.



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.
kalvaro's profile image kalvaro posted 7 years ago Permalink




Anse, does the "Embed picture" feature no longer work?
kalvaro's profile image kalvaro posted 7 years ago Permalink
http://imageshack.us/photo/my-images/829/komodoideshorcuts1.png/
http://imageshack.us/photo/my-images/526/komodoideshorcuts2.png/
kalvaro's profile image kalvaro posted 7 years ago Permalink
Oh, sorry, I wasn't linking the actual pictures!


ansgar's profile image ansgar posted 7 years ago Permalink
Nice! Think I'll add such a button to the grid export dialog. Hoping the other two buttons are still self explanatory..
kalvaro's profile image kalvaro posted 7 years ago Permalink
It'd also be useful in the "Export database" dialogue and I suppose it could be shared code.
simbabque's profile image simbabque posted 7 years ago Permalink
I like the Komodo thing. You're right, it has that, but I've not thought about it in this context. Another not so nice but effective way is how PuTTY handles it in its Logging Config. It just shows an explanation as text below the textbox. But I agree with kalvaro, the button is great.

Code modification/commit from ansgar.becker, 7 years ago, revision 4409
Process placeholders in filename also in grid export dialog. Provide a list of valid placeholders below the recent files pulldown menu. See http://www.heidisql.com/forum.php?t=12506
ansgar's profile image ansgar posted 7 years ago Permalink
Done in r4409. A list of placeholders is now present in the pulldown menu with the recent files.

Think I have to add such a pulldown to the SQL export dialog too, so it's more noticable.

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