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 automate aggregating the logs and parsing tracebacks start a feedback loop of fixing the tracebacks until 0 tracebacks remain re-run the aggregator and confirm tracebacks disappeared […]
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 […]
