Business Objects- Creating alerts to alert your query is done executing

Business ObjectsSAP Business Objects doesn’t make it easy to know when the query is completed running (at least not while you’re working on something else). I wrote an AutoHotKey script to alert me it is completed running (and boy does it alert me! LOL).

This way I can put BO in the background and continue working on other tasks.  When the query is complete, I get both a visual and audio alert informing me it is complete.

I had a hard time “hooking” into Business Objects but I was able to monitor status bar to see when it changes/updates.

Video showing Business Objects Alert

Alerts in Business Objects

Screen Clipping w/built in email attachment, IMUGR upload, & saving

screen clippingI use this AutoHotKey screen clipping script at least a dozen times a day. I think most people SHOULD be using it that often but don’t realize how useful it can be.

The below video walks through a some examples of how I use it.  Trust me, after you start using it for a few days, you’ll wonder how you managed to get by all these years without having it!

screen clipping & built-in options

My version allows you to:

  1. have multiple clips on the main window
  2. automatically write a pretty email customized to the time/date and attach a .png file (easy to tweak to whatever format you want)
  3. upload to  IMUGUR:  If you want to do this you’ll need your own oAuth token.  Watch this video to explain how to get one
  4. save locally and paste path to file wherever needed (I use this for Facebook very frequently)
  5. save locally with a time-stamp

Here is the video demonstrating it’s usage

Screen clipping and various uses

and here is the AutoHotkey code (Be sure you create and swap out an IMUGR API key)

 

Get text from a list box; use AutoHotKey to grab items from programs

Get text from a list boxSometimes I’d like to be able to, progromatically, extract values listed inside a program.  Unfortunately many programs I use do not allow the ability to get text from a list box.

One of AHKs great strengths is how well it “hooks” into Windows.  I wrote an AutoHotKey script which allows me to copy and paste a list of items selected in the window.  There are lots of options like retrieve all items, only those selected, obtain the count of either previously mentioned.  Once you have all the items you can send instructions back to the list box and specify which one you want selected (thus if you frequently go back and select the same items, it can automate the process.

Get text from a list box

Grabbing Selected Items from SPSS

Transfer systems automatically regardless of their sources

transfer systems

Transfer Systems regardless of their sources

Our clients enter campaigns into a SharePoint page that need to be transferred to our CMS. Unfortunately the two systems are not tied in any way and there are no existing API Web Services that we can leverage.

There are over 250 items that might be selected which means we end up taking a lot of time to, manually, transfer the campaigns.

I wrote a script with AutoHotKey that automates much of the process (as well as replacing Unicode values with their HTML equivalents).  This allows me to transfer systems automatically with very little effort!

This saves a TON of mundane time by performing web scraping with AutoHotkey and is more reliable than doing it manually.

Transferring items between disparate systems