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)

 

AHK Studio is an impressive IDE / editor for AutoHotkey

AHK Studio is an amazing and impressive IDE / Editor for AutoHotkey

AHK Studio editor for AutoHotkeyI had an in-depth Hangout with Chad Wilson (Maestrith on the forum), the Author and Designer of AHK Studio.

While I’ve been, and still am, a very satisfied SciTE4AHK user, I was very impressed with many aspects of the tool.  It is very intuitive to use and offers some great features that will simplify a coding.  Not surprisingly AHK Studio is loaded with HotKeys that, once you familiarize yourself with them, will be awesome!  While advanced programmers in AutoHotkey will love the advanced functionality, Noobs will enjoy it’s simplicity.

Here are links where you can you can download it from the AHK forum or from GitHub.  Please keep in mind it is still in development.  (This is both good and bad.  It is good because Chad is very active and open to tweaks/fixes/improvements, bad because “kinks” are never fun)

AHK Studio

Here are a few videos on AHK Studio  and below is the nearly 2-hour video demonstrating some of the configuration settings and functionality.

Setup & Review of AHK Studio- Great IDE & editor for AutoHotkey

 

Web Scraping with AutoHotkey- Data Extraction & emailing to colleagues

web scraping with AutoHotkeyI regularly have to go to login to a website, navigate to a certain page, extract data and then place it into Excel, then email the files to my colleagues.

This video demonstrates how quickly and easily it is done when you program some web scraping with AutoHotKey.  Somehow I lost the audio track however you can still see what is going on.  Also, some of it happens so fast it looks like I sped up the video but it is real-time.  🙂

Demo video of Web Scraping with AutoHotkey and emailing to colleagues

Web Scraping- Data Extraction from a webpage & emailing to colleagues

If you’re new to scraping you can see my earlier post here which gives a good review as well as a program that helps write the AutoHotKey code.