Many Pies

Many Pies

Friday, April 27, 2007

I can recommend WinBatch

A post I put on the Blackbaud User Society (Blackbus) forum recommended WinBatch, so I thought I'd expand on it here.

It costs $99.95. It replays keystrokes to the screen using a scripting language. So you can get it open records, copy fields, manipulate them, paste them back and so on.

It's idea for repetative tasks that don't need the mouse. I mainly use it for Raiser's Edge but you can use it for most applications that can use the keyboard to do things.

So for example, this script takes a list of Funds in an Excel spreadsheet and puts an X before the fund name.
delaytime = 0.5
for i = 1 to 353
SendKeysto("Microsoft Excel","{F2}+{HOME}^c{ESC}")
timedelay(delaytime)
SendKeysto("Microsoft Excel","{DOWN}")
SendKeysTo("The Raiser","!i")
SendKeysTo("Find", "^v~")
timedelay(delaytime)
SendKeysTo("Find", "{ESC}~")
timedelay(delaytime)
while strsub(WinGetActive(), 1, 10) == "The Raiser"
timedelay(delaytime)
endwhile
sendkey("{TAB 2}{HOME}X{TAB 8}{SPACE}")
while strsub(WinGetActive(), 1, 10) != "The Raiser"
timedelay(delaytime)
endwhile
next i


{SPACE} is the space bar. {ESC} is escape. ~ is return. ! means alt and then the next character. ^ means control and the next character. It can do many different things, we only use a fraction of its capabilities, but it's saved days of tedious work over the past few years.

tags:

No comments: