Show HN: Apple Notes Liberator – Extract Notes.app Data and Save It as JSON

563 点作者 kello大约 2 年前

Hey there!I just released the first version of a project I’ve been working on solves a very specific problem that perhaps only I have. I welcome any and all feedback, even if you just want to drop in to say that this is a hot piece of garbage!

32 条评论

oneearedrabbit大约 2 年前

I am excited to see more solutions that work with Apple Notes database directly. This is my go-to application to capture unstructured memos while researching various topics. Last year I got carried away and built a simple site generator for Notes [0]. As a fun exercise I implemented ORM models to query Sqlite database in Ruby:<pre><code> User::Account.server(database: "tmp/test.sqlite").first. folders_dataset.offset(1).first notes. map(&:attachments).flatten. find { |el| el.is_a?(User::ObjectTypes::EmbeddedPublicJpeg) && el.height > 700 && el.summary[/animal/i] }. media_filepath => "Accounts/<uuid>/Media/F669B83A-0C47-408E-9645-015737F3B11F/Pasted Graphic.jpg" </code></pre> Apple Notes' database structure is a fascinating product story. Notes started as a simple note-taking application that stored its content as raw HTML in a few simple tables. However, as the product grew and needed more features like collaboration, they had to make changes and add new columns and tables. They also implemented two flavors of CRDT-like algorithms that evolved over time: one for plaintext chunks and the other one for embedded objects like tables. On top of that, every change that Apple makes must be backward compatible to support legacy devices and systems; but backward-compatibility was not always possible and users had to go through “Migrate your Notes” steps, but it is again a product story.I wish that one day, someone from the development team would write an article about it.[0] <a href="https://devlog.notespub.com/2022/08/site-generator-for-apple-notes/" rel="nofollow">https://devlog.notespub.com/2022/08/site-generator-for-apple...</a>

评论 #35320620 未加载

评论 #35324195 未加载

评论 #35320943 未加载

评论 #35320559 未加载

评论 #35335540 未加载

评论 #35319636 未加载

simonw大约 2 年前

I wrote a similar tool in Python a few weeks ago, which uses AppleScript to liberate the data and saves it to a SQLite database: <a href="https://datasette.io/tools/apple-notes-to-sqlite" rel="nofollow">https://datasette.io/tools/apple-notes-to-sqlite</a>I didn't actually know AppleScript before writing this tool... but it turned out ChatGPT knew it well enough to unblock me and provide me with exactly the code I needed to build the rest of the project! <a href="https://til.simonwillison.net/gpt3/chatgpt-applescript" rel="nofollow">https://til.simonwillison.net/gpt3/chatgpt-applescript</a>Apple Notes Liberator creates a copy of the SQLite database and then runs queries against that directly to extract the data.I chose not to do that (despite being all-in on SQLite for everything) because I worry about future changes to the software baking my script - I figured the AppleScript interface was less likely to have breaking changes in the future.

评论 #35319618 未加载

评论 #35319880 未加载

评论 #35318992 未加载

评论 #35321362 未加载

评论 #35319630 未加载

评论 #35326636 未加载

评论 #35319553 未加载

ecliptik大约 2 年前

A feature that a lot of Apple apps have that doesn't seem talked about much is they can use standard protocols and not require iCloud.Mail.app/Reminders.app/Notes.app can use IMAP, Cal.app with CalDAV, and Contacts.app with CardDAV [1].It doesn't offer a lot of the features iCloud has like advanced formatting or collaboration, but is a useful for simple standards based syncing and portability.I've done this with my iPhone/Macs and Fastmail for the last few years and it works great [2].1. <a href="https://support.apple.com/guide/iphone/set-up-mail-contacts-and-calendar-accounts-ipha0d932e96/ios" rel="nofollow">https://support.apple.com/guide/iphone/set-up-mail-contacts-...</a>2. <a href="https://www.fastmail.help/hc/en-us/articles/1500000279941" rel="nofollow">https://www.fastmail.help/hc/en-us/articles/1500000279941</a>

评论 #35321713 未加载

评论 #35324109 未加载

评论 #35324984 未加载

评论 #35323346 未加载

samwillis大约 2 年前

Super interesting, particularly the link through to the blog with all the research into how Notes works.A particularly interesting thing that I don't see mentioned anywhere is that Apple Notes uses CRDTs (conflict free replicated data types) to enable both shared notes and multiple concurrent edits. With the CRDTs resolving the conflicts.It looks like the info on the page may be a good place to start looking to how that works: <a href="https://www.ciofecaforensics.com/2020/10/20/apple-notes-cloudkit-data/" rel="nofollow">https://www.ciofecaforensics.com/2020/10/20/apple-notes-clou...</a>

评论 #35318314 未加载

评论 #35326520 未加载

ChintanGhate大约 2 年前

I have published an app [Exporter](<a href="https://apps.apple.com/us/app/exporter/id1099120373?mt=12" rel="nofollow">https://apps.apple.com/us/app/exporter/id1099120373?mt=12</a>) that does something similar - exports Apple Notes to HTML and markdown with the attachments. Give it a try, let me know if it solves your issue.Also, why did you select JSON as the output format?

评论 #35319217 未加载

评论 #35323359 未加载

评论 #35322068 未加载

dangoor大约 2 年前

Cool! Thanks for sharing. Also worth noting that there's a Mac app in the app store to export to markdown or html:<a href="https://apps.apple.com/us/app/exporter/id1099120373?mt=12" rel="nofollow">https://apps.apple.com/us/app/exporter/id1099120373?mt=12</a>(I haven't had a need yet, so I haven't tried it)

评论 #35318761 未加载

css大约 2 年前

If anyone ever wanted to do something similar for iMessage data, I built a similar tool for that: <a href="https://github.com/ReagentX/imessage-exporter">https://github.com/ReagentX/imessage-exporter</a>

评论 #35320881 未加载

mkmk大约 2 年前

I consistently struggle with Notes and iMessage sync issues, and I suspect it’s due to being a customer for so many years and making my way through many devices over those years.The UX of the Apple ecosystem is so nice but when it goes sideways you’re kind of out of luck, even if you have applecare.I wish they had some sort of premium “fix my esoteric appleID account issues” service you could pay them for once a decade or so.

评论 #35317955 未加载

评论 #35323064 未加载

pjot大约 2 年前

This is great! How do you account for updates to a note?I’ve been building an archiver tool as well to convert notes into markdown and post to git using Apple Shortcuts.The interop between almost all iOS data formats (notes, safari, calendar, etc.) the content graph[0] provides is really impressive.[0]: <a href="https://support.apple.com/en-me/guide/shortcuts/apd4618db957/ios" rel="nofollow">https://support.apple.com/en-me/guide/shortcuts/apd4618db957...</a>

vszakats大约 2 年前

Here's a Python script that takes the JSON output from <a href="https://github.com/threeplanetssoftware/apple_cloud_notes_parser">https://github.com/threeplanetssoftware/apple_cloud_notes_pa...</a> (needs master), and rebuilds Notes in Markdown format (or HTML), with links, attachments, lists, etc.:<a href="https://gist.github.com/vszakats/5a3bd939721d1dde6142d9ea3b2d1b5f" rel="nofollow">https://gist.github.com/vszakats/5a3bd939721d1dde6142d9ea3b2...</a>And a short, standalone JXA script, that outputs HTML, but loses some data, such as links: <a href="https://gist.github.com/vszakats/f24e7700428c1e694e20cee0b1cc542b" rel="nofollow">https://gist.github.com/vszakats/f24e7700428c1e694e20cee0b1c...</a>

ericzawo大约 2 年前

Love this. I am an Apple Notes absolutist (see: <a href="https://pbs.twimg.com/media/FY1rZvNWIAAIRzs.jpg" rel="nofollow">https://pbs.twimg.com/media/FY1rZvNWIAAIRzs.jpg</a>). I have tried Evernote, Workflowy, Dynalist, Notion over the years for marrying personal / professional worlds but always (always!!) come back to Notes.I have dreamed of the ability to have a Notes web app with custom CSS for years and a few other features.Good luck with this project I'll be watching closely

评论 #35328683 未加载

评论 #35328003 未加载

评论 #35327752 未加载

dmd大约 2 年前

I don't understand what value this tool adds over the library it uses under the hood (which includes a command line tool for exporting your notes; I've been using it for years). What is it for?

评论 #35323322 未加载

divbzero大约 2 年前

Note that Notes.app can also sync with IMAP.IMAP syncing supports basic formatting (bold, italic, underline) but not all features supported by iCloud syncing (attachments, checklists, photos).

rco8786大约 2 年前

Oh neat. I’ve been using Notes extensively since the beginning of this year. Daily journaling. Personal TODO lists, grocery list (shared w my wife), and gym/workout tracking.It works really well and has way more features than people realize. If you’re looking for like a “Notion-lite”, the answer might already be on your phone/MacBook.

Alifatisk大约 2 年前

So now we know how to export data from the notes.app, messages.app & reminders.app.What’s next?

评论 #35318826 未加载

munk-a大约 2 年前

As a windows user, while we don't have an OS built-in equivalent, the standard for such tools (in the form of Sublime and the like) is just to operate with temporary buffers that get written out as files on user request. Sublime will write internal data to some persistent storage somewhere and be able to survive sudden crashes and restarts but when you'd like to save the data out to a fixed filepath it's pretty trivial to do so. I do find it quite weird that Apple has managed to cultivate a system where storage in separate files isn't taken as the default.

kepano大约 2 年前

I am excited to see more ways to export data out of Apple Notes. Long term it would be amazing to see a solution that allows more interoperability with other apps.Depending on what you are looking to achieve there are a few ways to export Apple Notes to Markdown files, but it's only a one-way out solution.From the Obsidian forum: <a href="https://forum.obsidian.md/t/import-from-apple-notes-to-obsidian/732" rel="nofollow">https://forum.obsidian.md/t/import-from-apple-notes-to-obsid...</a>

shanecleveland大约 2 年前

I have been adopting Apple Notes more after trying to use a lot of other note methods/apps. Always fall back to simple text in Notes. And I seem to be hearing of more people doing the same.I recently set up a shortcut that works on both my Mac and iPhone to create a new note each day with the date as the title. And then each time I trigger the shortcut that day, it enters the time, location and weather. Easy way to keep a running "diary."

joe8756438大约 2 年前

This is cool. I wanted to provide notes export for people using a note taking service I built and landed on a ios shortcut.I think you can accomplish something close or the same? using shortcuts.One obvious benefit is the interface is going to be more approachable than the jar to most people.Shortcuts are also cool because you can build one and package it for others and even define user specific parameters that get filled on install.

rhettbull大约 2 年前

Very nice reverse engineering work! I wrote a python library and CLI that does something similar but interacts with Notes via Scripting Bridge: <a href="https://github.com/RhetTbull/macnotesapp">https://github.com/RhetTbull/macnotesapp</a>

reaperducer大约 2 年前

I built something similar a while back.But instead of pulling the data out of Notes, I took it from SMTP mail.I don't know if it still works this way, but when I did it, if you used a non-iCloud email address to sync Notes, it saved the data as pain text in email messages that could be easily parsed.

评论 #35323333 未加载

podviaznikov大约 2 年前

instead of extracting notes data as JSON my simple tool allows you to liberate your notes by publishing them to the web.<a href="https://montaigne.io/" rel="nofollow">https://montaigne.io/</a>I use the same amazing library linked in the blog post.

评论 #35323336 未加载

akerr大约 2 年前

Why not just use the built-in Shortcuts to export to your preferred format?

评论 #35323319 未加载

solalf大约 2 年前

Awesome initiative! I wish Apple Notes would support Markdown. This is my go to app for so much of my life, à Notion style editor would be an absolute game changer.

评论 #35336436 未加载

mdmglr大约 2 年前

"Liberator" implies it was locked down. But notes content has always been easily accessible with AppleScript.

jamesu大约 2 年前

For a long while I just copied everything to an imap server and dumped the mailbox, but this looks like an even better solution.

kolinko大约 2 年前

Nice! It throws an error that it cannot find the notes folder though.Where is it located usually? Or what's the file name?

评论 #35331853 未加载

marcjensen大约 2 年前

Thanks for creating this. I must say that I don't find things written in Java on HN very often.

yosito大约 2 年前

It would be really cool to set this up to automatically sync notes to Obsidian.

frozencell大约 2 年前

This but for the Mac Library now please (the format transfer are a mess)

egeozcan大约 2 年前

I wish someone did this for Whatsapp without having to jailbreak my phone.

gudh大约 2 年前

I wish there's tool to extract Apple Books' notes too

评论 #35324034 未加载