• Intro to AutoHotkey HotStrings with AutoHotkey Intermediate AutoHotkey GUIs are Easy with AutoHotkey Intro to DOS & AutoHotkey AutoHotkey FAQ AutoHotkey FAQ

AutoHotkey GitHub Webinar: Become an amazing AHK Programmer in 2020

AutoHotkey Github WebinarWe had an awesome webinar today! Jean Lalonde, author of Quick Access Popup, lead us on a great webinar today regarding how to use GitHub to with our AutoHotkey scripts & programs.  BTW we streamed the webinar live to this AutoHotkey Facebook group.

AutoHotkey Podcasts Highlighted

Ways to make money with around AutoHotkey  

Selling Software Group Discussion   

  • Jackie Sztuk
  • Ryan Wells
  • Jean Lalonde
  • Raptor X
  • Charlie Simmons / Tank
  • Joe Glines

Do people see what needs Automation?

Script Highlight

taskManager by fenchai23

TaskManager

AutoHotkey GitHub Webinar

Video Hour 1: High-level overview
Video Hour 2: Finishing up on GitHub

Here’s the deck shared by Jean Lalonde during the webinar

 

AutoHotkey Webinar- SQLite3 with AutoHotkey

SQLite3 with AutoHotkeyIn today’s webinar Jean Lalonde, author of Quick Access Popup, lead us through a demonstration how to use SQLite with AutoHotkey.

Video Hour 1:  High level overview

Video Hour 2: Continue overview and Q&A

Script Highlight: This was actually a “website” highlight.  Skrommel’s 1-hour Software is a great site with 116 examples of scripts that can manipulate various tasks on Windows.  His code is available both as an executable as well as the AutoHotkey source files.

SQLite3 with AutoHotkey

Here is a link to the SQLite3 with AutoHotkey files Jean shared and reviewed below

–SQLite files:

–Class_SQLiteDB library (by just me)

–Utility DB Browser for SQLite

SQLite-First_Example.ahk

  • Open an existing database

–Display error report

  • Query the database
    • in a RecordSet with Query()
    • in a Table with GetTable()
  • Execute various commands
    • Insert rows into a table
    • Delete rows

 

BLOB_Sample.ahk

  • Store and retrieve binary large objects (BLOB)

SQLite-TheBeatles.ahk

  • Create a new database
  • Create table and indexes
  • Insert multiple rows (import)
  • Display in a ListView with GetTable
  • Execute various commands
    • Alter table (add columns)
    • Vacuum the database

Using transactions

  • BEGIN TRANSACTION;
  • ROLLBAK:
  • COMMIT:

AutoHotkey User / Expert Interviews

In the below videos I interview AutoHotkey experts / users.  The goals are to:

  1. Find better ways to get new people to adopt / try AutoHotkey
  2. Stimulate ideas how current users might leverage AutoHotkey in other ways
  3. Create a bigger community of AutoHotkey users
  4. Raise awareness of AutoHotkey with non- users

1) AutoHotkey User / Expert interview: Jean Lalonde

My first interview was with Jean Lalonde, author of Quick Access PopUp.    Jean has also co-hosted several webinars with Jackie and I and is a very competent programmer.

2) AutoHotkey User / Expert Interview: Chad Wilson

In this interview I speak with Chad / Maestrith.  Chad is the author of AutoHotkey Studio and is a guru using GUIS, XML, and Objects.  In the video we discuss how he got into programming and some areas people should focus when learning AutoHotkey.  We also review a couple dozen applications (at a high level) that we collaborated on together.

 

3) AutoHotkey User / Expert Interview: Jack Dunning

In this interview I speak with Jack Dunning from Jack’s AutoHotkey Blog and Computor edge .  Jack has also authored several books on AutoHotkey. They can be purchased from his blog or on Amazon.com.

 

4) AutoHotkey User / Expert Interview: Charlie Simmons / Tank

Charlie / Tank actually works in the Robotics Process Automation (RPA) industry and is an admin on the AHK forum.  Below is my interview with him.  If the RPA industry interests you you can see another discussion with him here.  BTW- at the end of the interview Charlie mentions anyone with AutoHotkey knowledge could probably get a high-paying job in the RPA industry.

 

5) AutoHotkey User / Expert Interview: Nicolás Castillo

In this interview I speak with Nico from Mexico.  Nico has a background in IT and also works in the real estate industry.  We talked through some of his personal uses as well as how he’s helped people at his work.

 

6) AutoHotkey User / Expert Interview: Mitch Berry

In this interview I speak with Mitch out of North Dakota. He is an experienced Planner and Electrical & Instrumentation Specialist with a demonstrated history of working in the energy industry.

 

7) AutoHotkey User / Expert Interview: Jim Ford

In this interview I speak with Jim Ford out of China. He has a background in programming is Amazing! He’s programmed in over 50 languages and worked in technology all is life. We had a lively discussion about automation, corporate world, consulting world, RPA (Robotics Process Automation) and where technology is going.

 

8) AutoHotkey User / Expert Interview: Susan Thomas

In this interview I speak with Susan Thomas out of Nashville, TN. We talked about what life is like working at a huge company and how there is a group of ~20 people at her work with the task of “automating” (many using AutoHotkey).

 

9) AutoHotkey User / Expert Interview: Joe Glines

Yes, I interviewed myself!  LOL   I realized even though I mentioned a lot of what Maestrith and I had worked on together, there was a ton of stuff that I’ve done with AutoHotkey on my own and I wanted to make sure I shared with y’all.  I’m in Dallas, TX and have an undergraduate degree in Marketing and a Masters in Market Research.  I worked for a long time as a Data Scientist (way before they were called that) and then spent the last 8 years working in Internet marketing.

 

10) AutoHotkey User / Expert Interview: Isaias Baez / RaptorX

In this interview I speak with Isaias Baez / RaptorX out of the Dominican Republic. When I first started learning more than Hotstrings & Hotkeys I was fortunate enough to stumble upon RaptorX’s YouTube channel AHKTuts.
If you’re wanting to learn some advanced things like DLL Calls, SendMessage, etc. I highly recommend you check them out!

 

11) AutoHotkey User / Expert Interview: Dr. Gabriel Cook /

In this interview I speak with Dr. Gabriel (Gabe) Cook out of the Pasedena, CA. Gabe and I have been coding with each other for nearly 20 years now! Initially we worked in SPSS (a statistical program) but over the past years we’ve also played with Python and AutoHotkey. Quite a few years Gabe & I take a week to have a “code-cation” where we get together and work 12-hour days learning how to code! I highly recommend you have a “coding buddy”!

 

12) AutoHotkey User / Expert Interview: Ryan Wells

In this interview I speak with Ryan Wells out of Kiev, Ukraine. Like me Ryan has been using AutoHotkey for ~10 years; the first years using Hotkeys & Hotstrings, now he automates things with COM, Gui’s, etc. Ryan demonstrated some of the cool things he’s automated for his, and his wife’s work.   During the interview Ryan mentioned James Clear on Systems not Goals and How 1% Performance Improvements Led to Olympic Gold

 

 

13) AutoHotkey User / Expert Interview: Hellbent

In this interview I speak with Hellbent out of Canada. He has a background in C and has been creating awesome AutoHotkey GUI tutorials on his YouTube channel CivReborn .

 

14) AutoHotkey User / Expert Interview: joedf /

In this interview I speak with joedf out of Canada. He has a background in Geology and is an admin on the AutoHotkey forum.

 

15) AutoHotkey User / Expert Interview: Steve Maziarz

In this interview I speak with Steve Maziarz out of Dallas Texas. Steve and I used to work together and is as nice as he is smart! He has a background in IT / Technology and has been coding for longer than most of y’all have been alive!

 

16) AutoHotkey User / Expert Interview: Jackie Sztuk

In this interview I speak with Jackie Sztuk out of Denmark. He has a background in design and has been co-hosting webinars with me for over two years now.

 

17) AutoHotkey User / Expert Interview: Rick C

In this interview I speak with RickC out of Plano,TX. He has a background in IT and has a degree in programming. I met Rick when I tried to start a local “AutoHotkey meet up” in the Dallas/Ft. Worth area. While I didn’t get many to attend, it was cool to meet another AHK user!

 

18) AutoHotkey User / Expert Interview: Jesús Prieto

In this interview I speak with Jesús Prieto out of Spain. He has a background as a sound engineer and Translations. Check out his Spanish blog.

 

19) AutoHotkey User / Expert Interview: James Griffing

In this interview I speak with James Griffing out of Austin, TX. James has a varied background and has used AutoHotkey in different positions over the past years..

 

20) AutoHotkey User / Expert Interview: Michael Wilson

In this interview I speak with Michael Wilson out of Australia. Michael has worked with AutoHotkey for many years but recently has been diving deeper into using GUI and COM. You can check out his GITHUB respository here.

 

21) AutoHotkey User / Expert Interview: Joe Winograd

In this interview I speak with Joe Winograd out of Chicago, IL. Joe has worked with AutoHotkey for many years and has a huge background in programming. You can learn more about him on Experts Exchange Spotlight here.

 

22) SPSS User / Expert Interview: Jon Peck

In this interview I speak with Jon Peck out of Arizona. He has a background in: Programming, Econometrics, & Statistics and has been programming and using for longer than most of us have been alive!

Jon is a personal hero of mine and has saved me so much time coding in SPSS that it is impossible to quantify!

 

23) AutoHotkey User / Expert Interview: Jethrow

In this “interview” I read through Jethrow’s responses to my questions (he declined being interviewed). He has a background in: accounting but has migrated to being a programmer (at a 60% pay increase!)!   Among other posts, Jethrow is the author of this Web Scraping tutorial which is where I learned the vast amount of what I know now!

 

24) AutoHotkey User / Expert Interview: Gio Sperotto

In this interview I speak with Gio out of Brazil and has a background in Accounting & Law. He demonstrated a ton of amazing programs / scripts he’s written for work. Lots of great ideas here to peak your interest! BTW- Gio also lead our webinar back in March on Neural Networks.

25) AutoHotkey User / Expert Interview: Ernestas Ceciorka

In this interview I speak with Ernestas out of Lithuania. He’s new to AutoHotkey but is learning quickly and enjoying Web Scraping as well as using COM with Excel.

 

26) AutoHotkey User / Expert Interview: Sebastian

In this interview I speak with Sebastian from Germany.  He’s been programming since 2001 and wrote his first program when he was 13 and started with JavaScript, perl, mysql and doSqlWeb. We had a good discussion of using AutoHotkey and various IDE / Editors.

 

27) AutoHotkey User / Expert Interview: Mason George

In this interview I speak with Mason out of Colorado. He’s been programming in various languages since he was 13! He plans to go back to college and get a degree in Computer Science.

 

AutoHotkey Webinar- Parsing plain text with AutoHotkey

Video Hour 1: High-level overview:AutoHotkey Merchandise-White Stress ball

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:

  1. Create shortcuts to folders, programs, files, links, Snippets, special folders, etc.
  2. Easily create Hotkeys for above shortcuts
  3. Works with most Open/Save dialog boxes
  4. Integrated with most file managers (Windows Explorer, Directory Opus, Total Commander, etc.)
  5. The tool itself is highly customizable
  6. Have “shared” sections as well as individual ones
  7. Organize your menu into folders & sub-folders
  8. Customize Menu/GUI shortcut with an icon (that makes sense to you)
  9. Available in 10 languages

You can watch a short overview video here or get a deeper dive here.  Jean was kind enough to walk me through his tool in this video.

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:

  • Multi-row files
  • Relational files
  • XML and JSON files

We then shared some of the frequently used built-in commands and functions for parsing text in AutoHotkey.

AutoHotkey Bottle 3Then we got into various custom-built in libraries and functions

Then our guest speaker, Jean, took over walking us through some examples of common problems with AutoHotkey LoopParse command

The library is pretty cool and here are some of the main functions available:

  • CSV2Collection() – Transfer the content of a CSV file to a collection of objects.
  • Collection2CSV() – Transfer the selected fields from a collection of objects to a CSV file.
  • Collection2Fixed() – Transfer the selected fields from a collection of objects to a fixed-width file.
  • Collection2HTML() – Builds an HTML file based on a template where variables are replaced with content.
  • Collection2XML() – Builds an XML file from the content of the collection.
  • Collection2ListView() – Transfer the selected fields from a collection of objects to ListView.
  • ListView2Collection() – Transfer the selected lines of the selected columns of a ListView to a collection of objects.

ObjCSV Examples:  Here are the files Jean worked through.

  • SIMPLE CSV FILE – COMA DELIMITED (TheBeatles-coma.txt)
  • SIMPLE CSV FILE – TAB DELIMITED – ISSUE #1 (TheBeatles-tab.txt)
  • MULTI-LINE CSV FILE – COMA DELIMITED – ISSUE #2 (TheBeatles-Lyrics.txt)

Jean then gave us a review of how to use his ObjCSV library

  • Example using ObjCSV_CSV2Collection
  • SIMPLE CSV FILE – COMA DELIMITED (TheBeatles-coma.txt)
  • SIMPLE CSV FILE – TAB DELIMITED – ISSUE #1 SOLVED (TheBeatles-tab.txt)
  • MULTI-LINE CSV FILE – COMA DELIMITED – ISSUE #2 SOLVED (TheBeatles-Lyrics.txt)
  • PROGRESS BAR WITH LARGE CSV FILE – SEMI-COLON DELIMITED (LargeFile-semicolon.txt)
  • CUSTOM HEADER – SIMPLE CSV FILE – COMA DELIMITED (TheBeatles-coma.txt)
  • GUI Example using Collection2ListView
  • SAVING WITH DIFFERENT DELIMITER using ObjCSV_Collection2CSV
  • EXPORT HTML Example using ObjCSV_Collection2HTML

Wrapping up the first section we then saw a peak at CSVBuddy

CSVBuddy Examples

  • Reading large file with auto-detection
  • Editing field names, re-order or select fields
  • Saving options
  • Saving file with multi-line content converted to single-line (Excel-ready)
  • Reverting the single-line file to multi-line (for example, after manipulation in Excel)

Video Hour 2: Q&A:

In the second hour we discussed various issues working with text data as well as took a deeper look into Quick Access Popup.

Near the end of the time Capn Odin shared a Trie script he’s been working on.  You can check out the script on the forum

AutoHotkey Bottle 4