|
If you'd like an HTML export, here it is (Windows .bat file requiring sqlite3.exe, which is free, and you need to adjust the paths, of course):
C:\Programs\sqlite3.exe "G:\.kobo\KoboReader.sqlite" "select (case when datecreated=maxdate then (' <b><i><u>' || replace(replace(volumeid,'file:///mnt/onboard/',''),'.epub','') || '</u></i></b><br>' || char(10)) else '' end), ''''||substr(cast(datecreated as text),4,16), text, annotation, '<br>' from ( select *, (select max(datecreated) from bookmark where volumeid=bm.volumeid and (text<>'' or annotation<>'')) maxdate from bookmark bm where (text<>'' or annotation<>'') order by maxdate desc, volumeid, datecreated desc )" > "C:\Documents and settings\user\Desktop\annot.html"
pause
Last edited by pakoe; 09-19-2015 at 04:58 AM.
|