• Intro to AutoHotkey HotStrings with AutoHotkey Intermediate AutoHotkey Intermediate Objects GUIs are Easy w/AutoHotkey Intro to DOS & AutoHotkey AutoHotkey FAQ1 AutoHotkey FAQ2

Automating email metrics w/AutoHotKey, Excel, & RegEx on the naming convention

Automating email metrics

Automating email metrics

I’ve written an AutoHotKey script that logs into our vendor website and uses web scraping exports the recent email campaigns then breaks them out by region, campaign type, Business Unit, etc. and links them back to our SharePoint site for more information.

 

What’s really cool is that I’m putting in formulas (not the static number) thus if some of the items that  are not classified (someone incorrectly used our mailing name so the RegEx broke) they can go back and update the code and all the numbers will adjust!

Automating email metrics

Loading contacts to SilverPop via API call & SFTP file transfer

API call & SFTP file transfer

API call & SFTP file transfer

API call & SFTP file transfer

Loading our contact lists into Engage via their Web interface (browser) takes around 7-9 minutes of focused attention per list.  Doing the same thing with an API call and Secure File Transfer (SFTP) takes seconds!  The below video demonstrates the process from using web scraping to grab the name /ID on our SharePoint server to uploading the file to Engage, creating the name in Engage and tying the new name to the contact list.  The video is longer because I also have it wait for the data job to complete and then write an email confirming the process is complete.

The API call & SFTP file transfer is free with Engage/SilverPop but it isn’t well promoted (on their website nor by their representatives.  Spending a bit of time to get it working is well worth the investment. For the SFTP file transfer I’m using WinSCP but any SFTP program will do.

 

 

API call & SFTP file transfer

AutoHotKey Menu Builder- save hours of time by streamlining menu creation

AutoHotKey menu builderAHK is simple enough for me, an non-programmer, to program in however their GUIs are very tricky.  I wrote an AutoHotKey menu builder to help automate the building of them.  This can save a lot of time when trying to build menus.

Just remember that sub-menus need to be placed above their parents!  This always confused me because I wanted to put them below their parent’s .  You can also review this video which helps educate you on some of the built in features of AHK to control GUI placement

AutoHotKey Menu Builder

Good luck Hillary, Don’t blow it!

Best of luck Hillary; Just don’t blow it!

They say a picture is worth a 1,000 words.  In this case I think I find that statistic a little “hard to swallow”…  LOL!  Then again, in case you have no choice in the matter, this might help!

don't blow it

Good advice from an old friend.  I wonder if any other scandals will come to light in the coming months before election time.

Then again, what does it matter anyway?