Some programs I have created and use.
This program is more of a scanner to search a server and find all the older files. I set it up to scan for older files that are over 7 years old and compile them into an excel file so they can be reviewed before deletion. This is a good program for users for file retention policies. Also to find those information hoarders.
Now the program will ask you for a file path, then ask where you want to store the excel folder.
import os
import datetime
from openpyxl import Workbook
from tkinter import filedialog
import tkinter as tk
def get_file_creation_time(file_path):
"""
Get the creation time of a file.
"""
print("File path:", file_path) #Debug Print
try:
return datetime.datetime.fromtimestamp(os.path.getctime(file_path))
except OSError as e:
print("Error:", e) #debug print
return None
def get_file_size(file_path):
"""
Get the size of a file.
"""
return os.path.getsize(file_path)
def list_old_files(folder_path, output_directory):
"""
List files older than 7 years in a folder and store their information in an Excel file.
"""
# Initialize Excel workbook
wb = Workbook()
ws = wb.active
ws.append(["File Name", "File Path", "Creation Date", "Size (bytes)"])
# Get current date
current_date = datetime.datetime.now()
# Traverse through files in the folder
for root, dirs, files in os.walk(folder_path):
for file in files:
file_path = os.path.join(root, file)
creation_time = get_file_creation_time(file_path)
if creation_time is None:
continue #Skip files that could not be retrived
file_age = current_date - creation_time
if file_age.days > 7 * 365: # Check if file is older than 7 years
file_size = get_file_size(file_path)
ws.append([file, file_path, creation_time.strftime('%Y-%m-%d %H:%M:%S'), file_size])
# Save Excel file to the specified directory
output_excel = os.path.join(output_directory, "old_files.xlsx")
wb.save(output_excel)
print("Old files listed and saved to", output_excel)
if __name__ == "__main__":
# Initialize Tkinter
root = tk.Tk()
root.withdraw() # Hide the main window
# Ask for folder path
folder_path = filedialog.askdirectory(title="Select Folder")
# Ask for output directory
output_directory = filedialog.askdirectory(title="Select Output Directory")
list_old_files(folder_path, output_directory)
------------------------------------------------------------------------------
Older file Scanner and Delete
Working in the IT field, you will find that the users will fill up the space on the servers with older files.
Especially if you work within an industry that needs to have document retention policies where you can not keep some documents longer than a certain amount of time or you just have hoarders on your network. You will know those people who do not delete anything and save everything.
So I wrote up a program that will search through a selected server and find all empty files, older files, and delete them.
import os
import datetime
import tkinter as tk
from tkinter import filedialog
def list_files_and_empty_folders_to_delete(folder_path):
# Get the current date
current_date = datetime.datetime.now()
# Calculate the date seven years ago
seven_years_ago = current_date - datetime.timedelta(days=7*365)
files_to_delete = []
empty_folders_to_delete = []
# Iterate over files and folders recursively
for root, dirs, files in os.walk(folder_path, topdown=False):
# Collect files older than seven years
for file_name in files:
file_path = os.path.join(root, file_name)
# Get the modification time of the file
file_modified_time = datetime.datetime.fromtimestamp(os.path.getmtime(file_path))
# Check if the file is older than seven years
if file_modified_time < seven_years_ago:
files_to_delete.append(file_path)
# Collect empty folders
for dir_name in dirs:
dir_path = os.path.join(root, dir_name)
if not os.listdir(dir_path): # Check if directory is empty
empty_folders_to_delete.append(dir_path)
return files_to_delete, empty_folders_to_delete
def delete_files_and_empty_folders(files_to_delete, empty_folders_to_delete):
# Print files to be deleted
print("Files to be deleted:")
for file_path in files_to_delete:
print(file_path)
# Print empty folders to be deleted
print("\nEmpty folders to be deleted:")
for folder_path in empty_folders_to_delete:
print(folder_path)
# Confirmation before deletion
confirmation = input("\nDo you want to proceed with the deletion? (yes/no): ")
if confirmation.lower() == "yes":
# Delete files
for file_path in files_to_delete:
os.remove(file_path)
print(f"Deleted file: {file_path}")
# Delete empty folders
for folder_path in empty_folders_to_delete:
os.rmdir(folder_path)
print(f"Deleted empty folder: {folder_path}")
else:
print("Deletion canceled.")
def get_folder_path():
root = tk.Tk()
root.withdraw() # Hide the main window
folder_path = filedialog.askdirectory(title="Select Folder")
return folder_path
# Ask for the folder path using a dialog box
folder_path = get_folder_path()
# Check if the folder path is provided
if folder_path:
# List files and empty folders to be deleted
files_to_delete, empty_folders_to_delete = list_files_and_empty_folders_to_delete(folder_path)
# Delete files and empty folders if confirmed
delete_files_and_empty_folders(files_to_delete, empty_folders_to_delete)
else:
print("No folder path provided.")
______________________________________________________________
This program is used for when you need to mod Batch files. Any person in IT that has had to manage Batch files for a large company can think how annoying it would be to go through each one and make a single line change.
Well this program is made to search through all the batch files and you can write in a line, and it will replace it with another line you choose.
def find_files_with_text(directory_path, text_to_find):
files_with_text = []
for root, _, files in os.walk(directory_path):
for file_name in files:
if file_name.endswith('.bat'):
file_path = os.path.join(root, file_name)
with open(file_path, 'r') as file:
if any(text_to_find in line for line in file):
files_with_text.append(file_path)
return files_with_text
def remove_line_from_file(file_path, text_to_remove):
try:
with open(file_path, 'r') as file:
lines = file.readlines()
with open(file_path, 'w') as file:
for line in lines:
if text_to_remove not in line:
file.write(line)
print(f"Removed lines containing '{text_to_remove}' from {file_path}.")
except FileNotFoundError:
print(f"Error: The file {file_path} does not exist.")
except Exception as e:
print(f"An error occurred: {e}")
def process_directory(directory_path, text_to_remove):
files_with_text = find_files_with_text(directory_path, text_to_remove)
if not files_with_text:
print(f"No files found containing the text '{text_to_remove}'.")
return
for file_path in files_with_text:
print(f"Found '{text_to_remove}' in {file_path}")
user_input = input(
f"Do you want to remove the line containing '{text_to_remove}' from {file_path}? (yes/no): ").strip().lower()
if user_input == 'yes':
remove_line_from_file(file_path, text_to_remove)
else:
print(f"Skipped {file_path}.")
if __name__ == "__main__":
directory_path = input("Enter the path to the directory containing batch files: ")
text_to_remove = input("Enter the text to remove: ")
process_directory(directory_path, text_to_remove)
areudirty
turnnoffyourmind
stormborns
titsay
ellievsbear
andulkaphoto
discoholicmusic