Home Posts tagged "automation" (Page 8)

Tag: automation

select multiple items on a form (in mass)

AutoHotkey Merchandise-White Stress ball

In order to speed-up our page load times I like to archive items to an old folder.  Unfortunately there is no easy way to select some, but not all, items.   What I really wanted to do is automate select multiple items from a list.

Web scraping with AutoHotKey to the rescue!!! This simple looper is fast, flexible and a life saver. It simply sends tabs and the space key to my browser window saving me a lot of time and mundane work.  Below is the AutoHotKey code which is set to work in Chrome

 
WinActivate, ahk_class Chrome_WidgetWin_1 ;activate chrome window- lightning fast compared to IE
Loop, 25
{
Send, {Tab 2} ;sends two tabs
	sleep, 5
Send, {Space} ;selects / deselects item
}
return

And here is a video in case you’re not getting the value.

Select multiple items from a list

A black AutoHotkey branded water bottle on a desk beside a laptop, with a person reading a newspaper in the background

HTML Testing & URL Verification tool with AutoHotKey and Excel

URL verificationURL VerificationAutoHotkey Merchandise-White Stress ball

Working in Internet Marketing I’m frequently involved with reviewing new and active web pages.   When I started the process was manual and quite time consuming so I wrote a script to automate much of it.  This video demonstrates it in action.  It requires you to navigate in IE (yes, I know…) and uses Microsoft COM to rip all the URLs by web scraping with AutoHotkey from the active page and dumps them into a spreadsheet for URL verification.  It also pulls things like the title of the page, # of words on the page, most popular words,  Values for name and ID elements as well as the actual URL and outerHTML.

The script also allows you to choose your overall area which is great because there is probably a template that your company uses (and you’ll probably want to exclude items that are part of site navigation, not unique to that particular page.

Standardized naming convention via SharePoint

Standardized naming conventionsStandardized naming conventions are a must for consistent email metrics.

In this post I demonstrated how I used a regular expression to automate email metrics.  I thought I’d create a short video demonstrating how we were able to use SharePoint to automate the creation of our campaign names.  Pre-SharePoint our clients would create and enter names manually.  This was a nightmare!

Standardized naming conventions

This video demonstrates how we managed to get SharePoint to ease the creation of our naming conventions.

https://www.youtube.com/watch?v=rl7_N-iBb20