Robocopy, short for “Robust File Copy”, is an indispensable command-line utility included in Windows Server that facilitates the efficient copying of files. Given the critical importance of data in business operations, having a reliable tool that ensures the accurate and timely backup of files is paramount. This blog post explores how to use Robocopy to …
Save Outlook Emails as Text Files effortlessly using PowerShell to automate the archiving process. In the vast digital workspace, managing an overflowing inbox can be a daunting task for professionals across all sectors. The need to efficiently archive important emails for compliance, reference, or decluttering purposes is more pressing than ever. Automation, specifically through PowerShell, …
Have you ever faced the challenge of managing hundreds of Power BI reports and found yourself unsure about the data sources they connect to? I offer a straightforward solution which is tested in the real world – extracting data from Power BI reports with Python and Power Automate. Essentially, we are going to build a …
Automate folder renaming with Python and Excel to make managing data and keeping your files organized more efficient in today’s digital age. Handling vast amounts of data as a professional or simply maintaining personal files in order can be time-consuming and complex. To address this challenge, I’ve developed a comprehensive step-by-step guide that demonstrates how …
In today’s data-driven world, the ability to combine Excel files using Python and Pandas is essential for handling large amounts of data from various sources. We often find ourselves working with multiple Excel files that need to be merged into a single file for further analysis. In this blog post, we’ll delve into a straightforward …
In different environments we as IT professionals have to approach matters in various ways. Data comes in many forms, shapes, and sizes. One of the issues I recently had was how to insert data from a .xlsx file into a MySQL database with Python. I will dive into it and share the code, as well …
I had an annoying task that I had to do every week. It was tedious and repetitive. It basically entailed saving a bunch of attachments from different emails to my local drive. After a few weeks, I thought, I wonder if I can automate saving attachments from Outlook with PowerShell? I even considered hiring a …