IT Connect

Information technology tools and resources at the UW

News
Gears

Automation Will Set You Free, Sort Of

If you have a repetitive task then automation is your friend. The catch is that when anything changes your automation likely breaks. Still if you are running a report that requires a lot of check box selecting you might enjoy this tip sent in by Stephen Rondeau.

Stephen is using iMacros to automate running the Class List By Curriculum Course Section report.

Class List By Curriculum Course Section

I use the class list to get a list of all people enrolled in our programs, since I don’t know of any other way to get it. I run it multiple times just before and during the first two weeks of each quarter.

I use an iMacros script to select the right values from the dropdown lists‎ and generate a report in CSV format. That report is saved in a folder that is being watched for changes; when the report is saved, a script is run to extract and reformat the information into a form I can use to create user accounts, get class lists per course, etc.

– Stephen Rondeau, UW Tacoma Institute of Technology

Stephen’s automation is probably more than most people can handle but recording and replaying a macro is easily within reach.

iMacros

iMacros is a Firefox addon that lets you record and replay repetitious work. The next time you find yourself running the same report over and over consider recording a macro.