evernote-to-sqlite
evernote-to-sqlite copied to clipboard
include note tags in the export
When parsing the Evernote <note> elements, the script will now also parse any nested <tag> elements, writing them out into a separate sqlite table.
Here is an example of how to query the data after the script has run:
select notes.*,
(select group_concat(tag) from notes_tags where notes_tags.note_id=notes.id) as tags
from notes;
My .enex source file is 3+ years old so I am assuming the structure hasn't changed. Interestingly, my notebook names show up in the tags list where the tag name is prefixed with notebook_, so this could maybe help work around the first limitation mentioned in the evernote-to-sqlite blog post.