Follow these steps to maintain more reliable scripts and catch more of your traceback errors: automate your scripts to run daily, weekly, monthly, etc. Log all your traceback errors with the logging module. I like dumping all of my logs into a single folder. automate aggregating the logs and parsing tracebacks start a feedback loop […]
I recently automated the loading of data into a Microsoft Access database with pyodbc, a Python library for connecting to databases. ODBC stands for Open Database Connectivity. It can be used for a variety of Database Management Systems outside of Access also. First, install libraries with pip. Enter in terminal or command prompt: python -m […]
So you want to run your Python scripts automatically, but how? I had heard of several popular scheduling libraries in Python like celery, Invoke, and schedule. One of my requirements is to run the python file “in the background”, not in command prompt or an open window. Enter Windows Task Scheduler, the de facto scheduler on […]
