As a New Year’s resolution, not mine, they wanted to make sure their online store, reseller site, inventory was up to date. They wanted to make sure their inventory was cleaned up and make sure that what’s listed on the site matches their own inventory. They had been...
Python
Save posts to a WordPress Database – Working Notes
This is notes/overview of a project I started on to add several posts to WordPress (WP) from HTML files without having to copy and paste each file. These are just notes from that dropped project and the basic Python script to do this (github). Make sure you fully test...
Using Databases in Python
For my next project I wanted to work with a database in Python. Since databases are used in about every major coding situation I wanted to a project that would be close to a real world project. Spent time in January doing basic exercises/classes with Python with...
Update to Excel file in Python
I went back to create a way to make the script into a stand-alone app that the client can use on their own using PyInstaller. I’ve used PyInstaller before for the calculator program: https://www.lynnamacher.com/gui-python-calculator-stand-alone-app-with-pyinstaller/...
Updating an Excel file in Python
Client received a few Excel files of subscribers that needed to be sorted. They’re needing to pull the last name out and put it in its own column, so they can easily look up the subscribers. The issue with the Excel files is they want to sort the subscribers by last...
Stand-alone app with PyInstaller
Last post I’ve build a GUI calculator from an online class and added some extra functions to it. This post I’ll be creating the app as a stand-alone app for Mac and one for Windows. I’m using PyInstaller to do this, this is a stand-alone app you use in the command...
GUI Python Calculator with Tkinter
This project started with me wanting to learn a way to make an app in Python with a Graphic User Interface (GUI). GUI is what people are used to seeing when working with a computer. The previous scripts I have done in Python have all been command line interface where...
Archive Project part 2 – The Program
The second part of the archive project See Post 1 about the Mac OS side of the fixes here and for the purpose of this project. What the program needs to do: The program is to add extensions to the files that need them and clean out the files that don’t need to be...
Archive Project part 1
The issue that came up was when I went back to an old CD archive to pull an old Business card I worked for somebody, they needed some updates. I noticed that the Mac wouldn’t read the disc or the next 2 I tried. In research found that the current Mac OS doesn’t...
Python pull email addresses to CSV file
Another practicing Python project the original idea for this project came when I heard somebody talk about their email program got updated and all their contacts disappeared. First thought they would need to go through and add their contacts back. Then thought how...
Random name picker
The idea of this Python project comes from who gets to go first or what order do a group of people go in. Think of kids getting ready to play a game and need to decide who goes first and what order they go in. They might do something like pull a card from a deck or...
Python updating a large number of files
While trying to get more practice with Python I look for projects or find things and think how could I do this as a program. They might not be the most exciting or useful but they help in learning more elements to Python. They also help me build up a coding library so...