Advanced recording rules with weekday

[johschmi]

Hi, I am new to NextPVR (just installed it yesterday), so please excuse me if I am asking something that should be relatively clear. I really searched for an answer, though...

First of all, is there any documentation for the advanced recording rules, except this (rather basic) one? https://www.nextpvr.com/nwiki/pmwiki.php...ancedRules - like available functions and fields?


I am trying to record a show on a channel that is airing every sunday at 7 pm (and is having multiple re-runs on other week days and on other times on sunday). Is there a function to check the week day (e.g. sunday) for a given start_time?


For the time, I adapted the example of the documentation as follows:
title LIKE '%name%' AND time(start_time,'localtime') > time('18:50:00') AND time(start_time,'localtime') < time('19:10:10')



Bonus question: Is there any way to change an existing recording rule?


Many thanks in advance!

[Graham]

I am trying to record a show on a channel that is airing every sunday at 7 pm (and is having multiple re-runs on other week days and on other times on sunday). Is there a function to check the week day (e.g. sunday) for a given start_time?

Do you want ...

Record Season (Weekly, this timeslot) ... Record all episodes on this day each week on this channel that start in the one hour windows before and after the start time for this episode.

https://github.com/sub3/NextPVR/wiki/web...recordings

There is also ... Avoid duplicate recordings ... at ... https://github.com/sub3/NextPVR/wiki/Add...g-defaults

[BrettB]

Welcome to NextPVR.

For your example, I believe that you are making it more complicated than it needs to be. But you didn't provide us with full information.

What client are you using? From your post, I'm guessing you are using the web client.
What is your EPG (guide) source? I'm guessing you are using over-the-air DVB data.
What is your reason for trying to limit the recordings to Sundays at 7pm? I'm guessing it's because you only want an given episode recorded once.

In the NextPVR General Settings, if "Avoid Duplicate Recordings if Possible" is checked (which I believe is the default) and if your guide data provides enough information for a unique identifier (which I think from what sub has said DVB OTA data in Germany normally would), then NextPVR should only record each matching episode once (the first time that it airs and it is able to record it successfully). Therefore, you wouldn't need to limit your rule to Sundays at 7pm just to get only a single copy.

From the Web client, you can use the Advanced button to schedule a recording of the selected show and limit it to "Record Series (Weekends, this time slot)". That description doesn't explicitly say it, but I'm pretty sure that all of the options except the "Record Series (all times, all channels)" also limits the matching to episodes on the same channel. Now, there are a couple of caveats to this setting: 1) obviously it would match that show on both Saturday and Sunday, and 2) sub had a +/- 90 minute window for "time slot" recordings. That window would mean that episodes starting between 5:30pm and 8:30pm would match.

You can't change the type of an existing recording rule (i.e. change from "Record Series (All epsiodes)" to "Record Series (Weekends, this time slot)". But you can change things like the Pre-padding, Post-padding, and directory.

[mvallevand]

It varies by client, Kodi lets you pick and choose the day of the week so you can do Sunday only. As Brett says that doesn't really looks like an advanced query, that is a timeslot recording.

Martin

[johschmi]

Thanks for all your quick replies.

Yes, I'm using the web client. And my EPG data source is DVB OTA.

And yes, I found the "Avoid Duplicate Recordings" option (it is enabled b default). But this would record also old episodes NextPVR has never seen so far (but I have and I don't want to record them again, there's a lot of them). In addition to that, in Germany public broadcasters are sometimes fighting for so-called "newly aired minutes". This is why their metadata is unreliable in this case. They deliberately change the metadata (even the title) of videos to make them "new" again (sometimes only cutting only a few seconds to justify the new metadata).

Unfortunately, clicking on one episode in the TV Guide and then selecting "Record Series (weekly, this timeslot)" does not work either, as it won't find the other slot the following week. I assume that's because the title contains the episode name and then NextPVR seems to be limiting the search with the episode name of the episode I clicked on.

So, in other words: I think I need my "advanced rule". And I'm pretty confident it will work if someone can tell me how the syntax is for limiting the day of the week.

[Graham]

Unfortunately, clicking on one episode in the TV Guide and then selecting "Record Series (weekly, this timeslot)" does not work either, as it won't find the other slot the following week. I assume that's because the title contains the episode name and then NextPVR seems to be limiting the search with the episode name of the episode I clicked on.

I'm sorry but I don't understand what you are trying to do.

Do you want to record the same episode of a show twice with one broadcast being recorded on Sunday and another broadcast of the same episode on another day?

Or

Do you want to record a show that broadcasts different episodes on two days e.g. Episode 1 is on Sunday, Episode 2 is on Tuesday, Episode 3 is on Sunday, Episode 4is on Tuesday and so on?

You can do broadcasts of different episodes on two days in each week by creating two recurring recordings using "Record Series (weekly, this timeslot)".

[BrettB]

Unfortunately, clicking on one episode in the TV Guide and then selecting "Record Series (weekly, this timeslot)" does not work either, as it won't find the other slot the following week. I assume that's because the title contains the episode name and then NextPVR seems to be limiting the search with the episode name of the episode I clicked on.

I'm sorry but I don't understand what you are trying to do.

I think that what he is saying is that his EPG listing is including the episode name as part of the show name/title. So when using the "Record Series" (with any of the options), it isn't matching the following recordings since the episode name portion of the show name is different and NextPVR sees it as a totally different show.

In this case, I would strongly suggest that the OP look into a different guide source. SchedulesDirect supports Germany, so would be the best choice. It will provide good quality, consistent data including series identifiers and artwork, season/epispode information, "New"/"Premiere"/"Finale" series/episode information, etc.

[mvallevand]

So, in other words: I think I need my "advanced rule". And I'm pretty confident it will work if someone can tell me how the syntax is for limiting the day of the week.

For advanced queries you test the query with sqlite3 or a sqlite3 GUI utility and if if filters the shows you like then it should work.  If it fails, you can confirm the SQL call in NextPVR by turning on verbose logging to see the SQL call that is made.  Typically this is using the wrong quote character.

Personally I don't plan on reviewing custom queries it is advanced use for advanced users who want to follow this process.


Martin

[johschmi]

Yeah, that's what I way saying to say: My EPG listing is including the episode name as part of the show name/title. So when using the "Record Series" (with any of the options), it isn't matching the following recordings since the episode name portion of the show name is different and NextPVR sees it as a totally different show.

But knowing that the database is sqlite3, I found my "advanced" rule. Just in case someone is finding this thread, I am leaving the solution here for everyone else to find:

title LIKE '%name%' AND time(start_time,'localtime') > time('18:50:00') AND time(start_time,'localtime') < time('19:10:10') AND strftime('%w',start_time,'localtime')='0'

'0' = Sunday
'1' = Monday
'2' = Tuesday
'3' = Wednesday
'4' = Thursday
'5' = Friday
'6' = Saturday

You can even do multiple days using: strftime('%w',start_time,'localtime') IN ('0', '1')
(which means Sundays and Mondays)