Shortcut Keys / Macros for Grid

[Nirwen]

Hello,

I just started using PL/SQL Developer after using TOAD for a while, and am very impressed with it so far. Not crashing is a good thing

I am attempting to either create a shortcut key to export grid results from a sql query to an Excel file or create a macro that will do the same, but am having no luck. I am constantly exporting data to Excel, and a keyboard shortcut would be really helpful.

I cannot locate the menu command for the keyboard shortcut, and the macro will not record.

Any suggestions?

 

[mike]

I can't find keyboard shortcut keys to do this either and the macro recorder only records keystrokes as far as I know. Maybe others are more creative than me and can figure it out though.

If it's true that there aren't keyboard shortcuts to do this, ask them to put it on the enhancements requests.

You're not totally stuck though. Another option is AutoHotKey at http://www.autohotkey.com. It's a freeware macro recorder. It seems kind of finicky sometimes, but it can record mouse clicks. I did a quick test and it seems to do it and if you export a lot, it may be worth twiddling.

Anyway, it has an "AutoScriptWriter". I ran it, removed the junk and assigned it to a hotkey of Windows+F1.

One tip is that the mouse click is relative to the window, so when you record the macro, click toward the bottom of the SQL grid so that it will work with different SQL statements. I just did a right click, select all, right click, export to Excel.

This script probably won't work for you because of different screen resolutions and stuff, but to give you a start, it looks similar to this at the end:

;
; AutoHotkey Version: 1.x
; Language: English
; Platform: Win9x/NT
; Author: Mike Matney
;
; Script Function:
; If you press Windows+F1:

; * Select all
; * Export the grid to Excel
;
#NoEnv ; Recommended for performance and compatibility with future AutoHotkey releases.
SendMode Input ; Recommended for new scripts due to its superior speed and reliability.

;Windows+F1 will start the script
#F1::

;MouseClicks to export it
MouseClick, right, 412, 530
Sleep, 100
MouseClick, left, 473, 621
Sleep, 100
MouseClick, right, 473, 621
Sleep, 100
MouseClick, left, 597, 869
Sleep, 100

 

[Nirwen]

Mike,

Thanks for your reply. I've actually used AutoHotKey for expanding text shortcuts. I'll give your suggestion a try.

Nirwen