Many thanks @CalebJohn! This is very helpful to know. I’m still pretty unfamiliar with Joplin and have still a lot to learn. Now though, I’ve got some feedback. If only I understood what it means!
In trying to debug my python script I’m comparing an enex file,
star.enex, which is an xml export file generated by EverNote.
willietest.enex is generated by my script. Joplin imports the former successfully and fails on the latter with the error included below.
willietest.enex validates against EN enex dtd, the base64 strings decode to the images I expect; nevertheless, something there is that doesn’t love this file.
(I don’t know what the protocol of this forum is with respect to uploaded files. The two I’ve mentioned are small (less than 500kb each), contain no sensitive information, and can be provided in the unlikely event that someone is interested in my little problem.)
Note that the import mechanism correctly parses the CData section of the incoming html, and correctly generates the equivalent MD. But the end result is that the sqlite db gags on what it’s given, but I haven’t yet figured out what it is that tastes bad.
Any hints or observations would be welcome.
/tmp/.mount_JoplinwuJ1E9/resources/app/lib/import-enex.js:260 Error: Error: SQLITE_CONSTRAINT: NOT NULL constraint failed: notes.updated_time: INSERT INTO `notes` (`id`, `parent_id`, `title`, `body`, `updated_time`, `source`, `source_application`, `created_time`, `user_created_time`, `user_updated_time`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?): 38a88c203f7b4f499eff0a32f7f641fd,39e3219b3dd64ad18b02342ad04d3a5b,
Here awa Willie
,Music > Tunes > Here awa Willie - Dec 23, 2015, Dec 23, 10:24:35 AM
[Here awa Willie - The Traditional Tune Archive](http://tunearch.org/wiki/Here_awa_Willie)
Found in Google Books:
**The World's Best Music: Famous Songs and Those who Made Them, Volume 4 **
By Helen Kendrick Johnson, Frederic Dean, Reginald De Koven, Gerrit Smith
at DatabaseDriverNode.sqliteErrorToJsError (/tmp/.mount_JoplinwuJ1E9/resources/app/lib/database-driver-node.js:22)
at JoplinDatabase.sqliteErrorToJsError (/tmp/.mount_JoplinwuJ1E9/resources/app/lib/database.js:26)
at JoplinDatabase.tryCall (/tmp/.mount_JoplinwuJ1E9/resources/app/lib/database.js:89)
at process._tickCallback (internal/process/next_tick.js:68)
processNotes @ /tmp/.mount_JoplinwuJ1E9/resources/app/lib/import-enex.js:260
_tickCallback @ internal/process/next_tick.js:68
async function (async)
processNotes @ /tmp/.mount_JoplinwuJ1E9/resources/app/lib/import-enex.js:230
setInterval @ /tmp/.mount_JoplinwuJ1E9/resources/app/lib/import-enex.js:435
(anonymous) @ /tmp/.mount_JoplinwuJ1E9/resources/app/lib/import-enex.js:434
emit @ events.js:182
SAXStream._parser.onend @ /tmp/.mount_JoplinwuJ1E9/resources/app/node_modules/sax/lib/sax.js:190
emit @ /tmp/.mount_JoplinwuJ1E9/resources/app/node_modules/sax/lib/sax.js:624
end @ /tmp/.mount_JoplinwuJ1E9/resources/app/node_modules/sax/lib/sax.js:667
end @ /tmp/.mount_JoplinwuJ1E9/resources/app/node_modules/sax/lib/sax.js:154
SAXStream.end @ /tmp/.mount_JoplinwuJ1E9/resources/app/node_modules/sax/lib/sax.js:248
onend @ _stream_readable.js:628
onceWrapper @ events.js:273
emit @ events.js:187
endReadableNT @ _stream_readable.js:1092
_tickCallback @ internal/process/next_tick.js:63