[bunter fisch]

Hi,

sometimes i set bookmark when i watch a movie to correct some error, e.g. errors in text subs. how can i exprt the bookmark, especially the timecodes to my windows pc? the pictures of the bookmarks are saved in .kodi-folder in home directory, but not the timecodes.

bunter fisch

[nickr]

They'll be in the databases somewhere.

[Ned Scott]

If you export (wiki) NFO files, it will contain bookmark timestamps.

[bunter fisch]

this is not a file i've imported to the library. i've selected the file with the video button, not the film button. so there is no nfo.

but kodi must save the bookmark somewhere, even if the file wasn't imported to the library.

[Ned Scott]

The video DB, as nickr said. However, it won't be in an easily accessible format.

[bunter fisch]

They'll be in the databases somewhere.

The video DB, as nickr said. However, it won't be in an easily accessible format.

Now i have this problem again. i've set some bookmarks but renamed the file (and i can't remember the former file name). now i don't see the bookmarks anymore.

so, where in the database can i search for the bookmarks?

[scott967]

so, where in the database can i search for the bookmarks?

The bookmark table?

scott s.
.

[bunter fisch]

you mean the *.db-files in userdata/Database? what of that files? the biggest is "MyVideos93.db". if opened the file with notepadqq (on linux) but the most isn't readable. i can find some file name, but no bookmarks.

[scott967]

Sorry, from your posts I assumed you were looking into the database. You need a program which can open and read sqlite3 databases such as MyVideos93.db. I use a Firefox browser extension but there are also installable programs to do this (such as SQLiteSpy on windows). I suppose it depends on what you intend to do with the bookmarks you export.

scott s.
.

[pipal]

Hi, is it possible to manually specify TV Episode bookmarks through a nfo file?

If I set-up TV Episode bookmarks through the GUI are they exported to .nfo files? This post suggests they aren't. Thank you.

[Pantsenu]

lo

http://kodi.wiki/view/NFO_files/tvepisodes

<epbookmark>

[virtual__]

how can i exprt the bookmark, especially the timecodes to my windows pc?

For everyone like the OP and me that are still looking for a way to see the time code of the bookmarks saved in Kodi, just look for the database as Scott said.
It's located in .kodi/userdata/Database (on Android, the folder is Android/data/org.xbmc.kodi/files/.kodi/userdata/Database) and copy the MyVideos*.db (that one with the higher number) into your PC.

Then, with a sqlite client, run this query:

sql:
.mode box



SELECT (strPath || strFilename) AS LastPlayedFile,

time(timeInSeconds, 'unixepoch') AS BookmarkPosition,

timeInSeconds AS BookmarkPositionSeconds,

lastPlayed AS LastPlayedDate

FROM files

INNER JOIN bookmark ON files.idFile = bookmark.idFile

INNER JOIN path ON files.idPath = path.idPath

WHERE bookmark.type = 0

ORDER BY lastPlayed DESC

LIMIT 100;

... and you'll get a list of your recently played stuff with the bookmarks positions (also in HH:MM:SS format).
Hope this helps someone!

[scott967]

Thanks for that.  For anyone interested, I wrote a little python3 script that will export the bookmarks for movies (only) that are watched (no resume bookmark in the database) to text files that are placed in the movie's folder.  The text file is formatted as a chapter file that can be muxed into an mkv file using mkvmerge.  Due to what seems to be a Kodi issue with chapters, it creates a chapter always at time 00:00:00.  (Kodi can then read the chapters and skin can display some chapter info).

Note that the path to the database is hard-coded into the variable "database"

I can't provide support for this script, but feel free to use it as a starting point if interested.  Note that this is for the default sqlite database, not Mariadb or other centralized database.

https://pastebin.com/7WRKJdCC

scott s.
.