honorkell 0 Posted September 1, 2019 Share Posted September 1, 2019 (edited) Hi, I have a bunch of channels in LiveTV (via IPTV m3u) that I don't want showing up in the guide. The only way I've found to remove them is to change their parental rating to X and then put in parental access controls per user. I'd like to do this en masse, so I want to write a script that will manually change the metadata stored on my server. But I can;t seem to find where the parental rating data is stored. Does anyone know where that is? Thank you. Edit: Nevermind I forgot about medatadata manager. Edit2: Wait medatamanager can't do multiple selections at once? Edit3: Fix figured out below: So if anyone wants to mass block channels, first shutdown Emby then: 1) download DB browser for SQLite, 2) open the library.db file C:\users\YOURUSERNAME\AppData\Roaming\Emby-Server\programdata\data, 3) browse data, 4) select mediaItems, 5) filter by channel name, 6) change one channel's official rating to XXX and it's inheritedparentalratingvalue to 15 7) Copy and paste these to each entry (you can do multiple at once with shift+click) 8) Write changes, close DB browser, run Emby Make sure your user's parental access blocks XXX. Edited September 2, 2019 by honorkell Link to comment Share on other sites More sharing options...
Luke 36997 Posted September 1, 2019 Share Posted September 1, 2019 Hi, no we currently don't have bulk editing features but it's something we're interested in for the future. Thanks. Link to comment Share on other sites More sharing options...
honorkell 0 Posted September 2, 2019 Author Share Posted September 2, 2019 Well then I'll try writing a script. Where is the parental data stored? Link to comment Share on other sites More sharing options...
Luke 36997 Posted September 2, 2019 Share Posted September 2, 2019 In the library.db database. I would suggest using the API. Or if you have nfo metadata files, you could use a bulk text editor to edit them, then run a library scan. Link to comment Share on other sites More sharing options...
honorkell 0 Posted September 2, 2019 Author Share Posted September 2, 2019 (edited) Ah ok thank you. Edit: Okay, I can easily edit library.db and add a tag en masse to the channels I want to hide (using parental access controls), and the changes to the db stick. However, they aren't reflected in the channel's metadata when browsing the LiveTV channels. I restarted the server with the edited library.db, but Emby is ignoring library.db's "tags": the changes don't show up in use, but do in the library.db. Any idea what that could be? Oh also - when i edit the tags from Emby and reinspect the db, the changes show up in the db editor. So I'm a little confused why this seems to be a one way street. Thank you. Edit2: parental ratings stick in the db too - and show up in the Emby metadata! I marked the unwanted channels as XXX. But Emby only hides the channel if I set it as XXX from Emby; it ignores the db again, even though the metadata rating shows up as XXX. Edit3: Got it. I had to change the inherited parental rating to 15 as well. Woot! So if anyone wants to mass block channels, first shutdown Emby then: 1) download DB browser for SQLite, 2) open the library.db file C:\users\YOURUSERNAME\AppData\Roaming\Emby-Server\programdata\data, 3) browse data, 4) select mediaItems, 5) filter by channel name, 6) change one channel's official rating to XXX and it's inheritedparentalratingvalue to 15 7) Copy and paste these to each entry (you can do multiple at once with shift+click) 8) Write changes, close DB browser, run Emby Make sure your user's parental access blocks XXX. Edited September 2, 2019 by honorkell Link to comment Share on other sites More sharing options...
Luke 36997 Posted September 2, 2019 Share Posted September 2, 2019 Well, doing it that way is a hack but i guess it will work. Thanks for the feedback. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now