dogsheep / dogsheep/apple-notes-to-sqlite

UTF8 Encoding : Error with quoting

Open
#16 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
251
Forks
11
PR merge metrics
No merged PRs in 30d

Description

Hey Simon, thanks for this repo, it has been very helpful in me making data from notes

I Ran this at work since export to markdown via apple script was too involved 😢 . I Received the following error

```
Also delivered (uncommitted, in your working tree — you haven't asked for a commit):
- apple-notes-to-sqlite/apple_notes_to_sqlite/cli.py — mac_roman → utf-8; 124 of 396 notes had corrupted bodies. Worth upstreaming. One pre-existing test failure remains, from newer sqlite-utils quoting, untouched.
```

This is an AI using your tool to run your tool, so there is a chance it's done something wrong. (It wrote a python script to run this)

Contributor guide

No contributing guide indexed for this repository

Research direction

Read apple_notes_to_sqlite/cli.py first and reproduce the Apple Notes export with the reported UTF-8 and quoting failure. Check the mac_roman-to-UTF-8 conversion and the pre-existing sqlite-utils quoting test failure; done means the reported note-body corruption and quoting error are resolved without changing the unrelated failure.

Written by the indexing model from the issue text.

Assessment

Tech stack
python, sqlite
Domain
cli, databases
Issue type
Bug
Difficulty
3/5
Estimated time
1-2 days
Activity status
Active
Clarity
Needs clarification
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.