evernote-to-sqlite icon indicating copy to clipboard operation
evernote-to-sqlite copied to clipboard

include note tags in the export

Open d-rep opened this issue 4 years ago • 0 comments

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.

d-rep avatar Nov 02 '21 20:11 d-rep