[zebraitis]

Hi folks,

My system:  A bunch of endpoints running Kodi 21.1 in Win11, pulling content from a Win11 NAS running DB instances in MySQL.  And, I am still rocking confluence as my skin.

What's changed:  I want to allow my neighbor to access my library of Films, TV and Movies.  So, in their endpoint I have the advancedsettings.xml point to a separate DN.

Since I export all my info (artwork, *.nfo's) to my NAS, I was able to scan in all the media easily.  

So, what's the issue:  That initial scan pulled in the NFO saved info (saving a TON of scraping time, where I did not have to revalidate if it was correct or not), HOWEVER it also pulled in the watched state of all the media.  Which I don't want. and clicking on W 7000+ times is jkust not an option that I wish to pursue.

MY ASK:  How & where can I go in Confluence to toggle ALL content to watched/unwatched?   Keep ALL the content as it is, just change watched state in their new DB instance.   (Again, WITHOUT toggling the "W" key 700+ times)

I have looked at various searched answers and most suggest that there was that functionality a while ago...  but not now. 

I would appreciate any insight.  Thanks!

[zebraitis]

OK...  so sometimes the answer is there, but the knowledge to use it isn't.

I found this thread:  https://forum.kodi.tv/showthread.php?tid=371556 where @Klojum provided an SQL command that would mark things unwatched.

And, since I use the MySQL process (actually Maria DB) to manage my DB's, I also have HeidiSQL which can give me a view into the DB's

So, once I found out how to execute an SQL Command in HeidiSQL (because I am NOT a programmer), then I was able to mark everything unwatched.

Except for the items that had been started already.  because that SQL command only deals with changing watched to unwatched.

So, 99% of teh way there... good enough.

[Hitcher]

Same place as any skin - context menu on the source folder/s.

[jbinkley60]

OK...  so sometimes the answer is there, but the knowledge to use it isn't.

I found this thread:  371556 (thread) where @Klojum provided an SQL command that would mark things unwatched.

And, since I use the MySQL process (actually Maria DB) to manage my DB's, I also have HeidiSQL which can give me a view into the DB's

So, once I found out how to execute an SQL Command in HeidiSQL (because I am NOT a programmer), then I was able to mark everything unwatched.

Except for the items that had been started already.  because that SQL command only deals with changing watched to unwatched.

So, 99% of teh way there... good enough.

You need to delete the bookmarks table to get rid of those in progress.  This MySQL command will do it.

delete from bookmarks

and remove the where clause from your original MySQL command.  This will restart everything fresh:

UPDATE files SET playCount = NULL, lastPlayed = NULL



Thanks,

Jeff

[zebraitis]

@Hitcher said:  "Same place as any skin - context menu on the source folder/s."

I saw that comment in a few other places, but in my install, that is NOT an option in the context menu.

Is your data local to your instance of Kodi?  Because with my data being on an SMB share and using MySQL, that "mark as unwatched" choice is not there.

Which, by the way, is the reply that I also saw from many folks, when they were told that it is on the context menu.  (Because for me, it is not.)


So, for some folks it is, and for other folks it is not.  Which kind of sound like it is a bug.

[zebraitis]

@jbinkley60 - thanks Jeff, but considering the few number of "in progress' videos (even considering that I use 7 profiles), I was still able to knock 'em out pretty quickly.

My main profile with the majority of films, I just flipped over to Estuary which showed those in progress and used the context menu to reset the bookmark.

The other profiles had far fewer, so I just skimmed the lists and changed it.

[Hitcher]

Or you could have used the advancedsettings.xml to ignore the watched state and resume points.

https://kodi.wiki/index.php?title=Advanc...deolibrary

xml:
<importwatchedstate>false</importwatchedstate>  <!-- import previously exported playdate and playcount from .nfo files. Defaults to false -->

<importresumepoint>false</importresumepoint>  <!-- import previously exported resume point from .nfo files. Defaults to false -->

[jbinkley60]

@jbinkley60 - thanks Jeff, but considering the few number of "in progress' videos (even considering that I use 7 profiles), I was still able to knock 'em out pretty quickly.

My main profile with the majority of films, I just flipped over to Estuary which showed those in progress and used the context menu to reset the bookmark.

The other profiles had far fewer, so I just skimmed the lists and changed it.

Sorry.  I thought you were running separate profiles with separate copies of the database.


Thanks,

Jeff

[jdig4240]

You could just delete "\Kodi\userdata\Database\MyVideos131.db". This will erase all watched statuses. You would just have to reenter your media sources paths though.

[LivingInthepast]

Wouldn't the paths remain since they are held in an XML file ?

[jdig4240]

Wouldn't the paths remain since they are held in an XML file ?

Yes, sorry, I mean you will just have to set the content again for the paths..

[Hitcher]

Yes, sorry, I mean you will just have to set the content again for the paths..

And then they'll read the watched states from the NFO's again.