Recurring recordings

[tomx]

Hello, I've been new to NextPVR and would like to setup recurring recording for one team:

I can run this querry inside DB and gives me results...
select * from epg_event where title like '%Liverpool%' and channel_oid in (select * from channel where name like '%SG%')


How can i add this sql to recurring scheduler...
i add this: 
title like '%Liverpool%' and channel_oid in (select * from channel where name like '%SG%')
It gives me 0 results.


Thx for support.

[mvallevand]

You shouldn't be returning all the channel fields, try

Code:

title like '%Liverpool%' and channel_oid in (select channel_oid from channel where name like '%SG%')

Martin

[tomx]

title like '%Liverpool%' and channel_oid in (select oid from channel where name like '%SG%')

This got me working.

One question when will this recurring rule run again to check if there is any new match in EPG?

[mvallevand]

Sorry right oid. It runs every time there is an EPG update scheduled or manual.

Martin

[tomx]

What is the best way, that only one show will be scheduled and will skip next if same name is found? Is there a way?

What is the best way to add only weekdays in expresion:
title like '%Liverpool%' and channel_oid in (select oid from channel where name like '%SG%')

[sub]

Unfortunately I don't think there is any way you can do that with the information you have available, other than maybe adding a time clause into your query, so that you only record shows that for example start between 7am and 9am.

NextPVR will automatically avoid re-recording the same episode as long as they're uniquely identfied in the standard ways, which include season/episode numbers, or crid identfiers, or schedules direct style identifiers. Unfortunately, it looks like your EPG doesn't have these. NextPVR doesn't avoid rerecording shows because the have the same title or description because it's very common for TV guide data just just use the same generic title and description on every episode of a show.

[mvallevand]

Sub, I don't think advanced recordings have a filter on the unique id or if it is already recorded. It would make them much better.

Martin

[tomx]

How can i remove spaces in naming of folder and recordings:

"file": "/recordings/Manual Recordings/Sport 1_20230605_11151117.ts",

I got checked:
Replace spaces with period character

Using docker on rhel7.

[mvallevand]

I think the space replacement is only for episodic series and movies. It's not clear how you created that recording since manual recordings should allow you to type Sport.1 as the name if you must.

Not sure if you also want Manual.Recordings and other parent folders to have spaces replaced that would be a wishlist item for sub.

Martin