Sample Header Ad - 728x90

Location of Voice Memos transcripts in the file system?

1 vote
2 answers
101 views
Where are the transcripts that are generated from recordings in the Voice Memos app stored in the file system? I did a:
grep -r PATTERN ~/Library`
for a known unique-ish pattern from one of the transcripts. It's been running for 45 minutes and hasn't found any matches yet. The audio recordings (*.m4a) and *.waveform files are stored here: ~/Library/Group\ Containers/group.com.apple.VoiceMemos.shared/Recordings/ I noticed a CloudRecordings.db sqlite database file (binary) in that directory, and none of the table names look obviously transcript-specific. I did the same grep command in this directory, and it completed and didn't find any matches.
$ sqlite3 -readonly ~/Library/Group\ Containers/group.com.apple.VoiceMemos.shared/Recordings/CloudRecordings.db .tables
ACHANGE                         ANSCKRECORDZONEMOVERECEIPT
ANSCKDATABASEMETADATA           ANSCKRECORDZONEQUERY
ANSCKEVENT                      ATRANSACTION
ANSCKEXPORTEDOBJECT             ATRANSACTIONSTRING
ANSCKEXPORTMETADATA             ZCLOUDRECORDING
ANSCKEXPORTOPERATION            ZDATABASEPROPERTY
ANSCKHISTORYANALYZERSTATE       ZENTITYREVISION
ANSCKIMPORTOPERATION            ZFOLDER
ANSCKIMPORTPENDINGRELATIONSHIP  ZMIGRATION
ANSCKMETADATAENTRY              ZRECORDING
ANSCKMIRROREDRELATIONSHIP       Z_METADATA
ANSCKRECORDMETADATA             Z_MODELCACHE
ANSCKRECORDZONEMETADATA         Z_PRIMARYKEY
I also did a: find ~/Library/ -iname '*transcript*' which returned 100 filenames/dirnames. One that looked maybe related was: /Users/robbednark/Library//Accessibility/com.apple.RTTTranscripts.sqlite Nothing obviously transcription-related in those table names either, and grep -r PATTERN ~/Library/Accessibility completed without any matches.
$ sqlite3 -readonly ~/Library/Accessibility/com.apple.RTTTranscripts.sqlite .tables
ACHANGE                         ANSCKRECORDMETADATA
ANSCKDATABASEMETADATA           ANSCKRECORDZONEMETADATA
ANSCKEVENT                      ANSCKRECORDZONEMOVERECEIPT
ANSCKEXPORTEDOBJECT             ANSCKRECORDZONEQUERY
ANSCKEXPORTMETADATA             ATRANSACTION
ANSCKEXPORTOPERATION            ATRANSACTIONSTRING
ANSCKHISTORYANALYZERSTATE       ZTTYCONTACTLIST
ANSCKIMPORTOPERATION            ZTTYHISTORY
ANSCKIMPORTPENDINGRELATIONSHIP  Z_METADATA
ANSCKMETADATAENTRY              Z_MODELCACHE
ANSCKMIRROREDRELATIONSHIP       Z_PRIMARYKEY
Asked by Rob Bednark (743 rep)
Jan 18, 2025, 12:20 AM
Last activity: Jun 1, 2025, 04:55 PM