Is there any way to use "Title (Year)" naming for a TV series?

[antenna]

This is unfortunately a Plex problem, but it made sense to start here.

This problem happens with a couple shows, but the easiest example is The Office: Plex automatically crawls the series as The Office UK, instead of US. You'd think their heuristics could make an educated guess based on my geographical location, or to check if the name of the episode matches the database, but they don't. 

I can manually "fix match" on the show in Plex, but the next time it records another Office episode, it goes back to the original assumption and uses Office UK again for that new recording. Lovely!

It's unlikely for them to fix this right now, especially as they are working on a new TV scanning agent. So, is there any way to add "(Year)" to the show title, preferably in both the folder and files? It's available for movies, but doesn't seem to be an option for TV.

(If anyone else has found a solution to this, I'm all ears!)

[mvallevand]

Yes. I use schedule direct and ran a pthon script the changed the show name for a recent set of recordings for the HBO version of Perry Mason before they were recorded and scheduled.

Martin

[mvallevand]

Correction it was just a sqlite script. Here is an example https://imgur.com/a/qdk748k using the following I find it is much nicer to get the real art and folders in NextPVR I don't have special handling for it for Kodi but I could if there is interest.

Code:

update epg_event set title = 'The Twilight Zone (2019)' where  substr(unique_id, 3, 8) = '03066091'

This can work with pretty much any movie or show on Schedules Direct.

Martin

[antenna]

Correction it was just a sqlite script.  Here is an example https://imgur.com/a/qdk748k using the following I find it is much nicer to get the real art and folders in NextPVR I don't have special handling for it for Kodi but I could if there is interest.

I am indeed using Schedules Direct, so that solution is great. My SQL knowledge is quite rusty, but I think I can handle this. One question that I don't understand: Once I create the script for the shows I need, how do I enter it into NextPVR?

[mvallevand]

You would create a file with as many of those update line as you need perhaps rename.sql

Then in PostLoadEPG.bat run this command

sqlite3 npvr.db3 < rename.sql

Thinking about this now if you want some extra safety during testing add a second condition.

Code:

update epg_event set title = 'The Twilight Zone (2019)' where  substr(unique_id, 3, 8) = '03066091' and title = 'The Twilight Zone';

You can use searches on the zap2it to help get the ID ie https://tvlistings.zap2it.com/overview.h...aid=gapzap

Martin