I moved the notes from Local notes to Exchange, and then my Notes crashed. When i reopen the Notes, i dont see them in Exchange and neither in local Notes I dont see these are present in Recently deleted either. I tried reading NotesV6.storedata.html as well, but didnt work. Please help.
Using mac_apt, i connected to database command below on terminal ./mac_apt_singleplugin.app/Contents/MacOS/mac_apt_singleplugin -i ~/Library/Group\ Containers/group.com.apple.notes/NoteStore.sqlite -o ~/Desktop/Note/mactool/ NOTES
This will create a Notes.csv in our output folder provided. It will have all the notes present.
Open the CSV, You will see your note text in the column 'Data'. For me, the 'Data' didn't had complete text present, but was partial. To get entire note file i filtered on the 'Folder' (as i lost one specific folder data) and got 'ID' column.
I connected to NoteStore.sqlite database using DB browser for sqlite
- Open the NoteStore.sqlite in SQLite Browser and
run query as
SELECT * from ZICNOTEDATA where ZNOTE='ID';
Click on each ZDATA entry and on the right side click 'Export'
- Save the blob as whatever_filename.gz
- Unzip the file using your preferred tool (i have used gunzip on Mac OS X)
- You will get your plaintext at the beginning of the file ( there is more than just plain text ).