Artwork for two programs with the same title

[FrogFan]

Hello,

Apologies if I've posted in the wrong forum.  I'm running NextPVR on a Windows 10 computer.

I record the game show program "Supermarket Sweep".  There is an "old" version of this program, c. 1990, that has "old" artwork, and a new version of the program with new, and different, artwork.  I want to record both versions, and that's working fine, I get both, but the artwork for both is showing as "old".  Is there any way to get "new" artwork assigned to the "new" version and "old" assigned to "old"?

I did a search on this topic and didn't find anything relevant. 

Thanks for any help.

[sub]

You can replace the artwork files in C:\Users\Public\NPVR-data\media\shows.

Ultimately if you're using an EPG that supplies artwork (aka Schedules Direct), then you should always get the right artwork for a show. For other EPG sources, NextPVR doesn't have a lot to go on, other than name (and somes it has year or country name to help it narrow down which it might be).

In furture I'll provide a way in the web app to choose from after artwork options.

[mvallevand]

Two shows with the same folder is the problem. If you use Schedules Direct, using this script https://forums.nextpvr.com/showthread.ph...#pid547345 NextPVR will treat them as different shows, storing them in different folders with different catalog and art files.

Martin

[FrogFan]

Two shows with the same folder is the problem.  If you use Schedules Direct,  using this script https://forums.nextpvr.com/showthread.ph...#pid547345 NextPVR will treat them as different shows, storing them in different folders with different catalog and art files.

Martin

I do use Schedules Direct.  I had a look at the thread you reference, and I understand the big idea of re-naming shows with different titles to point to different artwork and  to place them in different folders, but, beyond the big picture, I have no idea how to create the sqlite or where to put it if I ever did figure that out. 


I'll puzzle over it awhile and see what I come up with.  If there are other references I should consult, I would appreciate it if you pointed me to them.



Thanks for the help.

[sub]

Ah, wanting both. Yeah sorry it's not going to work for that currently.

[mvallevand]

First install sqlite it is just a command program. For each show you want renamed add a line in the rename.sql

Looking at zap2it the new Supermarket Sweep is either SH03416733 or SH03602598 so you need to see which one is coming up which is SH03416733

so your script line

Code:

update epg_event set title = 'Supermarket Sweep (2021)' where  substr(unique_id, 3, 8) = '03416733' and title = 'Supermarket Sweep';

Confirm it works with the web search like I showed in the video.

Martin

[FrogFan]

First install sqlite it is just a command program.  For each show you want renamed add a line in the rename.sql

Looking at zap2it the new Supermarket Sweep is either  SH03416733 or SH03602598  so you need to see which one is coming up which is SH03416733

so your script line

Code:

update epg_event set title = 'Supermarket Sweep (2021)' where  substr(unique_id, 3, 8) = '03416733' and title = 'Supermarket Sweep';

Confirm it works with the web search like I showed in the video.

Martin

Thanks Martin.

I'm still feeling a bit shaky about this and find myself seeking additional information before I do anything that might mess my system up.  In particular, I'm wondering where I might find some documentation on the layout of the database so I can get an understanding of what I'm updating.  Also, I'm wondering if I need to subscribe to zap2it in order to get the "show" information you found.  I don't see anything like that when I head over to zap2it.

Thanks for any additional help.

[mvallevand]

The database is not documented sorry. The show information in in the URL bar if you search for it and hit enter.

Because you are doing this in PostUpdateEPG in theory the database should not be in use and you are changings the row before recordings are created. Otherwise there is no way to do what you want. You can copy NPVR.db3 to a file and test this your self if you want to be more comfortable.

Martin

[sub]

I've made a change for the next release that should fix the issue. (for schedules direct users)

[FrogFan]

I've made a change for the next release that should fix the issue. (for schedules direct users)

Thanks sub.  I'll have a look when the next release comes out.  Given my tendency to mess things up, I've decided not to pursue Martin's workaround, but I do appreciate it!