I ended up just writing an AppleScript that called my Python script ('match_attachments.py') from within it, using the following AS code:
Code: Select all
if pubAttachments is not "" then
set pythonScriptPath to "(Local user path would go here)_match_attachments.py"
set firstAttachmentPath to pubAttachments
set pythonCommand to "python3 " & quoted form of pythonScriptPath & " " & quoted form of firstAttachmentPath
For the Python script itself, see below. Here's the version I used to automatically replace the attachment path in Bookends for missing attachments (Can't find file...), so long as the filename in my Bookends folder was sufficiently similar. On a 'similarity scale' between 0 and 1, I found about 0.8 to be a good enough matching balance (but of course, one is free to change this at will, which offers flexibility), without being too restrictive but also not letting in too many false positives (though a few did creep in - always a good idea to verify - but I would say it worked with 95% accuracy).
It uses Python's built-in 'difflib' to do the matching (using SequenceMatcher).
I first made it with the ability to ask the user to approve filenames if they fell below the automatic threshold of 0.8 (which were automatically accepted) but above a prompt threshold of 0.55 or so. But I ended up not using this, which is why the comment below reads 'DID NOT IMPLEMENT'. But it worked, when I was trying it out.
Finally, it uses the command line string value that the AppleScript sends to it (if len(sys.argv) > 1:
search_query = sys.argv[1]) as the search query for the matching. And it prints the matching attachment path back to the console which is picked up as 'matchResult' by the AppleScript:
Code: Select all
try
set matchResult to do shell script pythonCommand
if matchResult is not "None" and matchResult does not start with "Error" then
set attachments of aPub to matchResult
-- Add the successfully updated attachment path to the success list
set end of successList to matchResult
-JW
___
Code: Select all
# Import statements (if any)
import sys
from difflib import SequenceMatcher
import os
import time
# Function and class definitions (if any)
def absolute_similarity(search_query, candidate):
"""
Calculate the absolute similarity score between two strings.
:param search_query: The query string.
:param candidate: The candidate string for comparison.
:return: Similarity score as a float between 0 and 1.
"""
return SequenceMatcher(None, search_query, candidate).ratio()
# Assuming 'attachment_folder_path' is the path to your Bookends attachment folder
attachment_folder_path = '.../Library/Mobile Documents/iCloud~com~sonnysoftware~bot/Documents' # USE YOUR OWN local Bookends attachment folder path
attachment_files = [f for f in os.listdir(attachment_folder_path) if
os.path.isfile(os.path.join(attachment_folder_path, f))]
# Define your absolute similarity threshold for automatic acceptance
auto_accept_threshold = 0.80 # Adjust as needed
# DID NOT IMPLEMENT: Lower threshold for showing a prompt - you might still consider scores above a certain lower limit
prompt_threshold = 0.55 # Adjust as needed
if __name__ == "__main__":
# Accept the search query filename from command-line arguments
if len(sys.argv) > 1:
search_query = sys.argv[1]
highest_score = 0
best_match = None
for candidate in attachment_files:
score = absolute_similarity(search_query, candidate)
if score > highest_score:
highest_score = score
best_match = candidate
# Check if the highest score is above the threshold
if highest_score >= auto_accept_threshold:
correct_path = best_match # Save the relative path of the matching file
else:
correct_path = "None" # No match found
print(correct_path) # Print the correct path value (either correct path or 'None') to the console for further processing in the main AppleScript
else:
print("Error: No search query provided.")