Custom recording rules

[mvallevand]

I understand, but I thought you might see a way, the select logic for date handling is nightmare. Could I have another version with the SQL logged before it is submitted, when it craps out, I just see the error trace. Also do you do something with singles quotes or can I use them ok?

Martin

[sub]

This one should log the SQL before it craps out.

[mvallevand]

Ok great thanks sub I've got it working now part of the date problem was not encoding < and > going into

Code:

2012-10-10 22:47:25.226    [DEBUG][1]    SQL: select * from EPG_EVENT where channel_oid = 6870 and
title = 'The Big Bang Theory'
and subtitle != ''
and time(start_time,'localtime')  > time("19:55")
and time(end_time,'localtime') < time("22:05")
and subtitle not in
(select XmlLookup(event_details,'/Event/SubTitle') as subtitle from scheduled_recording
  where name = 'The Big Bang Theory')
order by start_time
2012-10-10 22:47:25.243    [DEBUG][1]     - Potential episode at: 18/10/2012 8:00:00 PM
2012-10-10 22:47:25.251    [DEBUG][1]       ...check IsValid()
2012-10-10 22:47:25.252    [DEBUG][1]       ...this episode is on Thursday
2012-10-10 22:47:25.252    [DEBUG][1]       ...valid days are: SATURDAY
2012-10-10 22:47:25.252    [DEBUG][1]       ...doesnt match recurring rules

Martin

[sub]

Great.

[Jakesty]

Hello Martin. Are you doing this for inclusion into NPVR or as a separate application or module? Not that it matters, I'm just not sure of your role in the development.
As I looked over this thread it looks like you're on a subject which closely matches how I want to schedule programming. See this thread...http://forums.nextpvr.com/showthread.php...-Recording

I guess I'm just hopeful in at least having the ability to even set this up myself if all of the basic pieces were in place and I just had to modify or add the rules as needed. Does this flexibility exist or is this something totally ad-hoc you're working with?

regards, Jake

[mvallevand]

I am not writing a plugin, I am writing something that first will be an external wizard that eventually I hope to convert to a NEWA page. The goal is to utilize the advanced rules feature that sub provides to its fullest. I expect to provide more powerful control of avoiding duplicate recordings and provide more control over the channels that I record from. Sub has given me the first thing I needed, which is access to the history of recorded shows.

Martin

[Jakesty]

Ok. I guess I'll wait until the tutorial comes out and I can get some training on just what the heck you guys are doing. This system is very detailed, as it should be. But there is so much unknown to me I guess I just want to get involved. Unfortunately my programming skills are limited, I can do some minor stuff. Granted having examples, a support forum, etc really helps.

You're always doing youtubes, maybe some instructional ones would be cool? Wiki's go only so far. Oh well just wishful thinking. I'm sure like SUB you have no time either.

Jake

[Graham]

The goal is to utilize the advanced rules feature that sub provides to its fullest.

The attached is an extract from epg-event listing 160 Big Bang Theories showing in two weeks in the UK. I have never recorded any of TBBT and I am now quite insane after trying to record episodes without duplicates and without missing any episodes.

It may be that what we need is a two panel display with the left panel showing selection criteria and the right panel having two tabs with one tab listing shows caught by the selection criteria and the other tab listing shows (with the same name) not caught by the selection criteria. It goes without saying that we will need to be able to sort the lists by start date/time and by subtitle and by wotnot.

Get this right and there could be a Nobel Prize in it.

Thanks.

[mvallevand]

Could you send my a db3 file instead, you have one channel with zero chance for success but overall it looks good. I probably will need to normalize the databae though.

Martin

[Graham]

Could you send my a db3 file instead

Ere tis ...

http://dl.dropbox.com/u/63058072/npvr.zip

Thank you.