…is only used to reduce workload & lay-off employees
…is mainly driven by cost savings
…completely replaces the need for a person
Why Don’t More People Automate / Use AutoHotkey?
People do notlike change. (correlation with age?)
People don’t realize what canbe automated (“think small” – “magicredo” button?)
Managers / Decision makers think it is “too expensive”
No “GUI” to use for creating scripts. Non-techies get “overwhelmed” with coding.
Everyone is “too busy” to learn how to save time. Even though they’re interested in saving time they don’t find time to learn how to automate. (Story of a woodcutteris a great analogy; remember to take time to ‘sharpen the saw’)
Some people are too proud to let-on that they really don’t understand what you’re doing. They might try it on their own but get frustrated and give up after 15 minutes. (Perhaps reviewing 1-1 is better than in groups?)
Managers oftendo not encourage their employees to automate. (I’ve had several bosses that told me NOTto automate.)
Most people think short-termand not long-term. This can present itself in the following dimensions
The job is “too small” to be automated (almost never true)
The job is a “1-time” need (rarely, if ever, the case; the “job” might be but the “approach” is bound to come up again)
I’m the only one that would use this (rarely the case)
It will take too long to write code to automate (I think this is one of the best things about AutoHotkey. FAST!)
It must be “fully automated” (No need to automate the entire process)
Not considering “side-effects” of automation (tracking log to examine events, employee / customer satisfaction etc.)
Best Approach to Get Adopters
1.Don’t overwhelm them with all that AutoHotkey can do!
Only get them to learn 1 thing!
Give them time to learn/adopt that and then come back with additional tips
2.Curtail what you demonstrate to the prospect’s level
In the first hour of our AutoHotkey webinar we demonstrated Quick Access Popup from our guest speaker Jean Lalonde. It is an amazingly customizable tool that allows you to have what you want at your fingertips!
Here is an abbreviated list of some of the great features:
Create shortcuts to folders, programs, files, links, Snippets, special folders, etc.
Easily create Hotkeys for above shortcuts
Works with most Open/Save dialog boxes
Integrated with most file managers (Windows Explorer, Directory Opus, Total Commander, etc.)
The tool itself is highly customizable
Have “shared” sections as well as individual ones
Organize your menu into folders & sub-folders
Customize Menu/GUI shortcut with an icon (that makes sense to you)
We then talked about what a “text file” is and frequent sources of them (Export from programs, sever logs, emails, etc). We also briefly discussed what is File / Character Encoding & why are there frequent problems with it (this is a very deep topic which we could have spent days discussing!)
Also discussed what a “flat file” is and how they are different than:
XML and JSON files
We then shared some of the frequently used built-in commands and functions for parsing text in AutoHotkey.
The program requires a CSV file and utilizes Microsoft’s Component Object Model to open Excel and examine the headers for a field named “email”. Once it finds it it removes duplicate email addresses and saves them as a new file in the same folder with the naming showing how many rows are present. This greatly reduces the amount of work needed to do the job.
This should ease the removal of duplicates from CSV files.
While SPSS has a built in capability of exporting to CSV, it doesn’t export in a format that most online tools accept. I wrote an SPSS script which accepts one parameter (the path & name of the file) then it exports the file into a better CSV format that tools do accept.
Demonstrates the use of a parsing script to create CSV files that are ready to be uploaded to survey tools