Recording a specific episode based on season and episode number

[cbgifford]

Greetings all,

I'm writing a utility that will run from the postupdateepg.bat script that will add an entry to the recurring recording table based on a season and episode number or alternatively title and subtitle. I figure I shouldn't need any custom rules as I will be searching the EPG for the show details. I was wondering if there is anything else that needs to be done after adding the show to the recurring recordings table? One thing I can think of off the top of my head is how to get NPVR to rerun the scheduling so any thing I added would be scheduled to record instead of having to wait 24 hours for it to run again.

Any ideas or pointers would be appreciated. If there were anyone wanting a specific feature added to it, I'd be open to taking doing it.

[sub]

I figure I shouldn't need any custom rules as I will be searching the EPG for the show details

I'm not quite sure how you're wanting it to work, but if you've already found the show you want recorded in the EPG data, then you can call something like the following to schedule a recording of that specific episode:

ScheduleHelperFactory.GetScheduleHelper().ScheduleRecording(epgEvent);

[cbgifford]

I'm not quite sure how you're wanting it to work, but if you've already found the show you want recorded in the EPG data, then you can call something like the following to schedule a recording of that specific episode:

ScheduleHelperFactory.GetScheduleHelper().ScheduleRecording(epgEvent);

I am using visual studio 2013 Community but using VB instead of C#. Haven't looked at C any about 20 years or there about. What reference do I need to add to access these types of calls? Or if you point me in teh direction of a thread that has a list of the functions and where they're located that would be awesome.

[sub]

I'd assumed you were doing it form a plugin, but re-reading your post, I see it was form a standalone utility. You should be able to do it though, including from VB.NET. I can't help you with the exact syntax though - it's been a long time since I did any VB. You'd need to add a reference to NShared.dll and NUtility.dll though. If you're already looking at the data in the database, you can probably use EPGEvent.LoadByOID(x) to get the EPGEvent object to pass into the ScheduleRecording() call.

[cbgifford]

You should be able to do it though, including from VB.NET. I can't help you with the exact syntax though - it's been a long time since I did any VB. You'd need to add a reference to NShared.dll and NUtility.dll though. If you're already looking at the data in the database, you can probably use EPGEvent.LoadByOID(x) to get the EPGEvent object to pass into the ScheduleRecording() call.

Just added the references, that gets me headed in the right direction, appreciate it. Syntax is on me, I've been a BASIC programmer before there was VB with MS Basic PDS and Quick Basic

[mvallevand]

Just added the references, that gets me headed in the right direction, appreciate it. Syntax is on me, I've been a BASIC programmer before there was VB with MS Basic PDS and Quick Basic

I have a command line utility I use myself for recording by unique id here is the recording logic I use after I get the event oids. I don't record to the default folder,

Code:

if (ScheduleHelperFactory.GetScheduleHelper() == null)
                {
                    RecordingServiceProxy.ForceRemote();
                    ScheduleHelperFactory.SetScheduleHelper(RecordingServiceProxy.GetInstance());
                    PluginRegistry.GetInstance().LoadPlugins();
                }
                IScheduleHelper helper = ScheduleHelperFactory.GetScheduleHelper();

                foreach (int oid in oids)
                {
                    evt = EPGEvent.LoadByOID(oid);
                    if (evt != null)
                    {
                        ScheduledRecording myRecording = new ScheduledRecording();
                        {
                            myRecording = helper.ScheduleRecording(evt, 1, 0, RecordingQuality.QUALITY_BEST, "[TV Shows]");
                            if (myRecording != null)
                            {
                                Logger.Debug(myRecording.OID.ToString() + " Schedule " + evt.StartTime.ToLocalTime().ToString("yyyy-MM-dd HH:mm") + " " + evt.Subtitle);
                            }
                            else
                            {
                                Logger.Debug(evt.OID.ToString() + " Failed   " + evt.StartTime.ToLocalTime().ToString("yyyy-MM-dd HH:mm") + " " + evt.Subtitle);

                            }
                        }

                    }
                }

Martin

[cbgifford]

You should be able to do it though, including from VB.NET. I can't help you with the exact syntax though - it's been a long time since I did any VB. You'd need to add a reference to NShared.dll and NUtility.dll though. If you're already looking at the data in the database, you can probably use EPGEvent.LoadByOID(x) to get the EPGEvent object to pass into the ScheduleRecording() call.

Code:

If My.Settings.NConnection = "" Or Command() = "/C" Then
            frmInteractive.ShowDialog()
        End If
        Dim t As DataTable
        t = LoadEPG("SELECT * FROM EPG_EVENT WHERE season = 1 and episode=1 AND first_run='Y'")
        For X As Integer = 0 To t.Rows.Count - 1
            NUtility.ScheduleHelperFactory.GetScheduleHelper.ScheduleRecording(NUtility.EPGEvent.LoadByOID(t.Rows(X).Item("OID"), RecordingQuality.QUALITY_DEFAULT)
        Next
        MsgBox("Total Rows = " & t.Rows.Count)

You've made me slightly dangerous with a little knowledge, thank you SIR!

[sub]

Martin's code reminds me, since this is an external utility, not a plugin, you'll probably need something like he has at the top of his code:

Code:

if (ScheduleHelperFactory.GetScheduleHelper() == null)
                {
                    RecordingServiceProxy.ForceRemote();
                    ScheduleHelperFactory.SetScheduleHelper(RecordingServiceProxy.GetInstance());
                    PluginRegistry.GetInstance().LoadPlugins();
                }

[cbgifford]

I got the below error when I tried to execute the code, the inner exception is file not found. I am running the development system on a client and added the references via a UNC path. I am assuming that I need to install NPVR on the client and run multiple configs when I am either watching TV or developing or is there a way around that?

System.TypeInitializationException was unhandled
HResult=-2146233036
Message=The type initializer for 'NUtility.DatabaseHelper' threw an exception.
Source=NUtility
TypeName=NUtility.DatabaseHelper
StackTrace:
at NUtility.DatabaseHelper.GetInstance()
at NUtility.EPGEvent.LoadByOID(Int32 oid)
at NScheduler.modMain.Main() in C:\Users\Chris\Documents\Visual Studio 2013\Projects\NScheduler\modMain.vb:line 108
at System.AppDomain._nExecuteAssembly(RuntimeAssembly assembly, String[] args)
at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly()
at System.Threading.ThreadHelper.ThreadStart_Context(Object state)
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading.ThreadHelper.ThreadStart()
InnerException: System.IO.FileNotFoundException
FileName=System.Data.SQLite, Version=1.0.85.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139
FusionLog==== Pre-bind state information ===
LOG: DisplayName = System.Data.SQLite, Version=1.0.85.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139
(Fully-specified)
LOG: Appbase = file:///C:/Users/Chris/Documents/Visual Studio 2013/Projects/NScheduler/bin/Debug/
LOG: Initial PrivatePath = NULL
Calling assembly : NUtility, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null.
===
LOG: This bind starts in default load context.
LOG: Using application configuration file: C:\Users\Chris\Documents\Visual Studio 2013\Projects\NScheduler\bin\Debug\NScheduler.vshost.exe.config
LOG: Using host configuration file:
LOG: Using machine configuration file from C:\Windows\Microsoft.NET\Framework\v4.0.30319\config\machine.config.
LOG: Post-policy reference: System.Data.SQLite, Version=1.0.85.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139
LOG: The same bind was seen before, and was failed with hr = 0x80070002.

HResult=-2147024894
Message=Could not load file or assembly 'System.Data.SQLite, Version=1.0.85.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. The system cannot find the file specified.
Source=NUtility
StackTrace:
at NUtility.DatabaseHelper..ctor()
at NUtility.DatabaseHelper..cctor()
InnerException:

[sub]

You'll need to make your executable as x86, since it references DLLs that depend on some 32 bit components.