Tag: automating tasks

Coding, Python

Beginner Automating with Python | Converting MYSQL database tables into single CSV files

Things you might need before coding Install python here Since this solution is realised by using the programming language called python,  you should probably install it as instructed in the website linked above. Additionally, you may need to understand the programming principles independent of programming language and also learn the code syntax in python. An […]

Coding

Python Learning: Automate Boring Stuff with Python | Chapter 15: Scheduled Web Comic Downloader

Book The world is indeed comic, but the joke is on mankind. H. P. Lovecraft true.. true.. 6:23:15 PM I made different functions to handle a specific (one) task; Division of labor [sourcecode language=”python”]</p> <p>#usage python download_lefthand_comic.py<br> import logging, os, requests, bs4,time, re</p> <p>logging.basicConfig(level=logging.DEBUG, format="%(asctime)s – %(levelname)s – %(message)s")</p> <p>comic_directory = os.path.join("c:\\", "comicbooks", "lefthandedtoons")<br> comic_directory = […]

Coding

Python Learning: Automate Boring Stuff with Python | Chapter 15: Prettified Stopwatch

I want to turn the clock back to when people lived in small villages and took care of each other. Pete Seeger And more coffee.. 4:05:04 PM     [sourcecode language=”python”] #usage Prettified_Stopwatch.py import time , pyperclip #TODO: start by enter #TODO: store start time #TODO: create lapNum #TODO: loop until user ctrl c input() startTime […]

Coding

Python Learning: Automate Boring Stuff with Python | Chapter 14: Excel-to-CSV Converter

And where I excel is ridiculous, sickening, work ethic. You know, while the other guy’s sleeping? I’m working. Will Smith I like will smith!! 12:50:11 AM   This task was unexpectedly difficult for me, so I am not sure if it is correct [sourcecode language=”python”] #USAGE python excel_2_csv.py import openpyxl, os, sys, logging, csv logging.basicConfig(level=logging.DEBUG, format="%(asctime)s […]

Coding

Python Learning: Automate Boring Stuff with Python | Chapter 13: Brute-Force PDF Password Breaker

“I can stand brute force, but brute reason is quite unbearable. There is something unfair about it’s use. It is hitting below the intellect.” ― Oscar Wilde, The Picture of Dorian Gray I don’t get it.. 11:20:21 PM   [sourcecode language=”python”] #USAGE python brute_force.py <pdfFile> import PyPDF2, os, sys, logging logging.basicConfig(level=logging.DEBUG, format="%(asctime)s – %(levelname)s – %(message)s") […]

Coding

Python Learning: Automate Boring Stuff with Python | Chapter 13: Custom Invitations as Word Documents

“Nothing annoys people so much as not receiving invitations.” ― Oscar Wilde, The Importance of Being Earnest I know that feeling…humph.. 10:36:20 PM   [sourcecode language=”python”] #usage python invitation.py <textFile> import docx, os, sys, logging from docx.enum.text import WD_ALIGN_PARAGRAPH logging.basicConfig(level=logging.DEBUG, format="%(asctime)s – %(levelname)s – %(message)s") if len( sys.argv ) == 2: #TODO: GET TEXT FILE textFileName […]