Custom recording rules

[mvallevand]

The description field is really overloaded it can start with a movie year, subtitle, s/e + subtitle or just a description. Are you using a utility to do all that?

Martin

[Graham]

Are you using a utility to do all that?

The year is copied to the description by the xmltv grabber. The actors are copied by the good gadget from pbs that is at ...

http://forums.nextpvr.com/showthread.php...light=xslt

The subtitle is there intermittently in the original xmltv (usually in the +1 channels ... which could be ignored if there was a "exclude channels" list). Thanks.

Edit: For completeness, I suspect that an episode might be on Channel A at, say, 8 pm. The exact same episode would then be on Channel A + 1 at 9 pm with a different description and with null in the series and episode column and with a null subtitle. I also fear that something similar might happen if the exact same episode is on Channel A on Monday and on Channel B on Tuesday. So no problems there then.

[mvallevand]

OK thanks, your guide is too customized to try and work with. I prefer working with what a general user will see.

Martin

[mvallevand]

Sub, when regular ScheduledRecording records are created with an EPGEvent is the title case sensitive?

Martin

[sub]

From memory it's case insensitive.

[mvallevand]

From memory it's case insensitive.

From the SQL calling showing it is.

Next question: when using advanceRules do you still make sure that uniqueID's are respected when processing the returned list?

Martin

[sub]

Yes

[mvallevand]

Thanks sub, this seem to be working quite well now.

If any dev's are interesting testing this for their apps, I build I simple C# app (attached) that lets you test your SQL (hard coded to the Win7 default)

The code on the button click is

Code:

private void button1_Click(object sender, EventArgs e)
        {
            SQLiteConnection conn = new SQLiteConnection("URI=file:" + "C:/users/public/npvr/" + "npvr.db3");
            conn.Open();
            SQLiteCommand selectCommand = new SQLiteCommand();
            selectCommand.Connection = conn;
            string command = textBox1.Text;
            selectCommand.CommandText = command;
            Debug.WriteLine(selectCommand.CommandText);
            SQLiteDataAdapter da = new SQLiteDataAdapter(selectCommand);
            System.Data.DataTable ds = new System.Data.DataTable();
            da.Fill(ds);
            dataGridView1.DataSource = ds;
            conn.Close();
        }

and you also need this class in your project.

Code:

[SQLiteFunction(Name = "XmlLookup", Arguments = 2, FuncType = FunctionType.Scalar)]
    class MyRegEx2 : SQLiteFunction
    {
        public override object Invoke(object[] args)
        {
            try
            {
                string input = Convert.ToString(args[0]);
                if (input.Length > 0)
                {
                    XmlDocument doc = new XmlDocument();
                    doc.LoadXml(input);
                    XmlNode node = doc.SelectSingleNode(Convert.ToString(args[1]));
                    if (node != null)
                    {
                        return node.InnerText;
                    }
                }
            }
            catch (Exception e)
            {
                Debug.WriteLine(e.Message);
            }
            return "";
        }
    }

Martin

[mvallevand]

The subtitle is there intermittently in the original xmltv (usually in the +1 channels ... which could be ignored if there was a "exclude channels" list). Thanks.

Now that I have better control of sqlite, I am sure I can do something a bit better to stop duplicate even with your custom view, I can certainly avoid the duplicates of the recordings shown here as long as you keep your sam subtitle logic.

Martin

[Graham]

I can certainly avoid the duplicates of the recordings shown here as long as you keep your sam subtitle logic.

I am slightly embarrassed. After I sent you my database, I went back and looked at this again.

I remembered that I get EPG data from two sources. The channels that I am likely to record from get their EPG from xmltv (C4 & E4). The channels that I am not likely to record were getting EPG from the DVB-T broadcast (C4+1 & E4+1).

The unique-id filed in the epg-event table is populated for every show that had a series and episode number in the source EPG data. I assume that the unique-id field is populated by NPVR when it does an updateepg.

There is an "avoid duplicates" option in Settings that was ticked on.

I setup my recordings again. I set record one recurring record as all "TBBT" on Channel 4 and a second recurring record as all "TBBT" on E4. It appears that this is doing what I want and recording a single copy of every episode (i.e. no duplicates even though there are duplicates in the EPG).

I have now changed the EPG source for C4 +1 and E4 +1 to xmltv and they have now have EPG data in the same format as C4 and E4.

As an experiment, I deleted the two existing recurring recordings and created a single new recurring recording - all episodes all channels. This did not record duplicates within itself (i.e. all new recordings were unique) but it did record duplicates of shows that were already recorded and in the database.

In summary ...

• Apologies for my dodgy database and for forgetting to mention that I get EPG data from two sources.
  
• The built-in "don't record duplicates" appears to work to avoid duplicates within a set of recordings spawned by a single recurring recording.
  
• The built-in "don't record duplicates" appears not to avoid duplicates of shows that already recorded.
  
• For completeness, I should mention that I am doing all this using Alibert's jolly good TV Listings.
  

I'm grateful that you are looking at this. My "requirement" seems to be evolving (but requirements always do!). I am trying to "build a library" of every episode of TBBT without duplicates and that takes account of the already recorded episodes ... select distinct from future broadcasts where not in (select from existing recordings).

This was all kicked off by my daughter "obtaining" copies of every TBBT in series one and two. My daughter would be trying to build a library "where subtitle not include S1 or S2".

Just in case you thought this might be easy ... how to cope with watching and deleting some episodes while the "library" is still being accumulated ?

And finally, please don't do anything only and only on my account ... I can cope quite well with the recording functions that we already have. Thank you for listening.