How to Upload Images to a Wordpress site with REST API Integration, Python and Excel
Streamlined WordPress Media Uploads with REST API Integration
"Hello everyone, and welcome to this tutorial where we’ll break down a Python script that automates image processing and uploads images to a WordPress site.
Here you see each section of the code explaining what it does and why it matters.
"Files in folder worpress_media_upload :
1. upload_images_4.py and
2. excel_upload_images.xlsm
"Let’s start by looking at our imports. This script uses several libraries:• os and base64 for file handling and encoding.• mimetypes to guess file types.• PIL from the Pillow library to manipulate images.• requests to handle HTTP requests.• pandas for data management and openpyxl to create Excel files.• dotenv to load environment variables.These libraries provide the functionality for file processing, communication with WordPress, and logging upload details in an Excel file."
________________________________________"Next, we have a section dedicated to loading our environment variables. Here, the script checks for the existence of a .env file at a specified path. This file holds our sensitive WordPress credentials – the URL, username, and application password. If any of these variables are missing, the script exits, ensuring that we don’t accidentally run without proper configuration."
________________________________________"We then define a few configuration parameters:• STANDARD_SIZE sets the dimensions for resized images.• THUMBNAIL_SIZE sets the dimensions for the thumbnails that will later be embedded into our Excel report.• FOLDER_PATH points to the directory containing our images. This modular setup makes it easy to change settings without altering the logic of our code."
________________________________________"The script defines several helper functions:• create_auth_header: This function takes a username and password, encodes them in base64, and returns the HTTP authorization header needed for WordPress API requests.• resize_image: Opens an image, resizes it using a high-quality resampling filter, and saves the resized image.• create_thumbnail: Similar to resize_image, but it creates a smaller version, ideal for visual logs in Excel.Each of these functions modularizes common tasks, making the code easier to manage and reuse."
________________________________________"Let’s move to the core functionality: uploading images to WordPress. The upload_image_to_wordpress function constructs the API endpoint using our WordPress URL, creates the authentication headers, and then posts the image file. It also derives a friendly 'alt text' from the file name. After posting, it checks the response status. A successful upload returns the URL of the uploaded image, which is then logged; any errors are printed for debugging."
________________________________________"This function orchestrates the overall workflow. It:1. Creates subfolders for resized images and thumbnails.2. Iterates through the images in the specified folder, filtering by common image extensions.3. For each image, it resizes it, creates a thumbnail, and then uploads the resized image to WordPress.4. It collects details such as the local file path, uploaded URL, and thumbnail path in a list called upload_details.These details are later used to generate a comprehensive Excel report."
________________________________________"After processing and uploading images, the script creates an Excel file to log the details. In the save_details_to_excel function, an Excel workbook is created with headers for the local file path, uploaded file URL, and thumbnail. The headers are styled for better readability, and the columns are adjusted for width and alignment.The function then adds each image’s thumbnail to the Excel sheet, ensuring that each row provides a visual reference along with the upload details. Finally, the workbook is saved in the folder, making it easy to review the upload history."
________________________________________"At the bottom of our script, we have a typical Python entry point. This line calls the process_and_upload_images function with our folder path and standard image size. When you run the script, this is what kicks off the entire process."
________________________________________"In summary, this Python script automates the task of resizing images, generating thumbnails, and uploading them to a WordPress site. It also logs every upload in an Excel file, complete with images, so you have a complete record of all processed files.Thank you for watching! If you have any questions or need further clarification, please leave a comment below. Don’t forget to subscribe for more programming tutorials!"
Post link: https://mindstorm.gr/streamlined-word...
