Posts: 9
Joined: Dec 2023
Reputation:
0
2023-12-22, 20:35
Good Day
Experienced SQL developer here but not with Kodi. Windows 11 running on MINIX box.
I have problems losing bookmarks when migrating bookmarked content to new external hard drive because Kodi uses the entire filename and path to store the bookmarks.
I would like to use free personal form of SQL server to go in and edit bookmark records in the appropriate DB file so I can re-associate files with entries in the bookmarks table.
Is this possible and does anybody have any tips?
Thanks very much.
Posts: 20,430
Joined: Apr 2017
Reputation:
1,371
Out of curiousity, what do you use the bookmarks for?
Wouldn't it be easier and more permanent to create chapter files once and then add those to the video file? Then there is no risk of losing bookmarks each time you rebuild your library. If you are using mkv files, it is pretty simple to do.
Posts: 9
Joined: Dec 2023
Reputation:
0
Not familiar with Chapter Files. How does that work?
Posts: 9
Joined: Dec 2023
Reputation:
0
OK looked it up and it talks about episodes. My videos are GoPro camera stuff I took myself. There are no episodes.
Posts: 9
Joined: Dec 2023
Reputation:
0
Also, the procedure you are showing is too complex. The bookmarks are great since I can add them while reviewing a video. - I'd like to keep using them. I'm only looking to solve a once in a blue moon problem.
Posts: 9
Joined: Dec 2023
Reputation:
0
It's a matter of loading the table up to see what the columns are then issuing UPDATE ... WHERE ... SET... statements, as required. Lots of possibilities.
Thanks for the info. Is that table also in the android version? I upgraded to the Windows version (much more responsive!) but lost all my book marks. If I had access to those I could copy the bookmarks.
Grateful for the info!
Posts: 9
Joined: Dec 2023
Reputation:
0
Actually, even easier might be to use a SQL utility to export the table to a CSV file, then use a text editor to change <this> to <that>, re-import the table and away you go.
Posts: 9
Joined: Dec 2023
Reputation:
0
Will do. Seasonal Cheers!
Posts: 5,285
Joined: Jul 2012
Reputation:
343
In Kodi you have resume point, bookmark, episode bookmark, and chapter. All as seconds from start of the file. These are all related to the file, not directly the media type.
Chapter files are a way to add chapters as metadata to AV files. I use mkv format but I suppose it can be done in other formats. Mkvtoolnix program can take chapter info as text / xml file and mux it into the mkv. Check out mkvmerge on the web for file format info.
I have many video files without chapters. I wrote a little python script to extract the bookmarks and write them to a file that I can mux into mkv with Mkvtoolnix. One issue with the bookmarks is that Kodi takes a frame grab when you set a bookmark and saves it into Thumbnails/Video/Bookmarks. Typically when you do something to your library the link to the thumb gets broken and you don't see the frame. A bigger problem is usability in that bookmarks and chapters are only available while a file is playing. (Except for episode bookmarks but these are special purpose only available for "episode" media type.) However, you do have the option of treating your video as a "tv show" with a single, multi-episode file, but then you are constrained by episode filename requirements. Also when you play the file you can select the "episode" and start playback there, but there is no episode "endpoint" and the file will continue play until EOF.
I haven't had luck in updating bookmarks in Kodi db after redoing a library, but it's been a few years, maybe could take another crack at it.
I also had problems with chapter navigating "chapter back" to the beginning of the file so I always add a chapter at time 0. That might be fixed now (since I have chapter 0 at time 0 in all my files I don't care).
Finally I also see that after adding the chapters and refreshing the file in the UI, I can delete the bookmarks (one-by-one) but there's always one that won't delete.
scott s.
.
Posts: 9
Joined: Dec 2023
Reputation:
0
Thanks again. It's always more complicated than you think!