How do I "bulk" export all Voice Memos from app on OS X? - Ventura Update

they moved the cloud recording DB on sonoma so here's an update:

(also I had to go into security setting, full disk access, and allow my terminal program access urgh)

#!/bin/bash

# Define the base directory for the voice memo recordings

db="$HOME/Library/Group Containers/group.com.apple.VoiceMemos.shared/Recordings/"

# Create a directory for all voice memos

mkdir -p "AllVoiceMemos"

cd "AllVoiceMemos" || exit

# Save the original IFS and set a new one

OIFS="$IFS"

IFS='|'

# Query the SQLite database and process each line

sqlite3 "${db}CloudRecordings.db" "SELECT ZPATH, ZCUSTOMLABEL, ZDATE, ZENCRYPTEDTITLE FROM ZCLOUDRECORDING" | while read -r line; do

# Split the line into an array

read -ra thisline <<< "$line"

relative_location="${thisline[0]}"

name="${thisline[3]}"

date="${thisline[2]}"

offset="978307200"

# Calculate the new date

newdate=$(bc <<< "$date+$offset")

trimdate=${newdate%.*}

formatteddate=$(date -r "$trimdate" +%y%m%d%H%M.%S)

# Construct the full path to the file

full_location="${db}${relative_location}"

# Print the details (optional, for verification)

echo "Full Location: $full_location. Name: $name. Date: $date. New Date: $newdate. Trimdate: $trimdate. Formatted: $formatteddate"

# Copy the file to the new location and rename it

if [ -f "$full_location" ]; then

cp "$full_location" "./$name.m4a"

# Update the access and modification times

touch -a -m -t "$formatteddate" "./$name.m4a"

else

echo "File not found: $full_location"

fi

done

# Restore the original IFS

IFS="$OIFS"

Hi, thanks a lot for the update! However, I found that the file name was not the original name after the export. It became the date-related format like "2022-11-05T10:01:16Z.m4a". Do you know how to retrieve the original name property from the database? Thank you!