My single greatest Photos.app frustration (I have many) is the inability to search the folder hierarchy. Mine contains hundreds semantically important folder names where the hierarchy is also meaningful. Meaning lost in the catastrophic Aperture to Photos migraiton.
This morning I had an hour free so I asked an ai about available utilities and workarounds. It said there are really no good options, but the Python osxphotos module might be able to traverse the folder hierarchy.
I have dabbled in minor Python coding and I have a half-baked Visual Studio Code environment. So I asked Claude 4.5 in Perplexity (this is not a formal supported coding environment) to write me a script that would use osxphotos to build a text file representation of the hierarchy. I ran whatever it generated.
It took 4-5 tries. I never edited the code myself. The first time there were copious errors, I describe errors and requested a redo. The next two times there were fewer errors, but I only got the top level of the hierarchy. The ai added debug code. It took two more tries of running and reporting errors to get a script that generated the text file I wanted (example):
[Teams and Orgs / MN Special Hockey / MNSH 2006 pre-season] MNSpecialHockey_060317
[Teams and Orgs / MN Special Hockey / MNSH 2022-2023] MSH 2023 Printed
[Teams and Orgs / MN Special Hockey / MNSH Woodbury 2019-2020] MSH Portraits Jan 2020
[Teams and Orgs / MN Special Hockey / MNSH 2008-2009] Nov 2008 MN SH Section 108 Event
[Teams and Orgs / MN Special Hockey / MNSH 2021-2022] Portraits MNSH Woodbury 2022
This is most personally valuable code I have ever "produced" since my days of writing the "medtrans" C program to turn 1990s MEDLINE output into tab delimited importable text.
And I wrote none of it.
I'll be cleaning it up and refining it, but below is the code I have today. It also included album names within a containing folder - I didn't want that but now I find it useful so I'll leave it.
Code
#!/usr/bin/env python3
"""
Export Photos folder and album hierarchy to a text file with tab indentation.
Requires: pip install osxphotos
"""
import osxphotos
from pathlib import Path
def export_folder_hierarchy(output_file="photos_folders.txt"):
"""
Export Photos library folder/album structure to a text file.
Args:
output_file: Path to output text file (default: photos_folders.txt)
"""
# Initialize connection to Photos library
photosdb = osxphotos.PhotosDB()
# Get folders and albums
folders = photosdb.folder_info
albums = photosdb.album_info
print(f"Found {len(folders)} folders and {len(albums)} albums")
# Build maps for folders
folder_map = {f.uuid: {'obj': f, 'children': [], 'type': 'folder'} for f in folders}
# Add albums to the structure
for album in albums:
# Albums have folder_names property which is a list of folder names in the path
if hasattr(album, 'folder_names') and album.folder_names:
# Try to find the parent folder by matching folder names
# folder_names is a list like ['Top Folder', 'Sub Folder']
# We want to match the first (top-level) folder name
top_folder_name = album.folder_names[0] if album.folder_names else None
if top_folder_name:
# Find folder with matching title
parent_folder = None
for folder in folders:
if folder.title == top_folder_name:
parent_folder = folder
break
if parent_folder and parent_folder.uuid in folder_map:
folder_map[parent_folder.uuid]['children'].append({
'obj': album,
'type': 'album',
'title': album.title,
'folder_path': ' / '.join(album.folder_names) if album.folder_names else ''
})
# Recursive function to write hierarchy
def write_item(f, item_data, level=0):
"""Write item and its children with proper indentation."""
indent = '\t' * level
if item_data['type'] == 'folder':
folder = item_data['obj']
f.write(f"{indent}{folder.title}/\n")
# Sort children alphabetically
children = sorted(item_data['children'], key=lambda x: x.get('title', x.get('obj').title).lower())
for child in children:
if child['type'] == 'album':
# Write album with its folder path if nested
folder_path = child.get('folder_path', '')
if folder_path:
f.write(f"{indent}\t[{folder_path}] {child['title']}\n")
else:
f.write(f"{indent}\t{child['title']}\n")
else:
write_item(f, child, level + 1)
# Find root folders
root_folders = [folder_map[f.uuid] for f in folders if f.parent is None]
root_folders = sorted(root_folders, key=lambda x: x['obj'].title.lower())
# Write to output file
with open(output_file, 'w', encoding='utf-8') as f:
f.write("Photos Library Folder Hierarchy\n")
f.write("=" * 50 + "\n\n")
for root in root_folders:
write_item(f, root)
print(f"Folder hierarchy exported to: {Path(output_file).absolute()}")
print(f"Total top-level folders: {len(root_folders)}")
if __name__ == "__main__":
export_folder_hierarchy()
No comments:
Post a Comment