schedule a manual recording with sqlite3.exe

[jd142]

Hi,

I'd like to be able to schedule a manual recording from the command line using sqlite3.exe. At first this seemed simpler than trying to right a c# app that accessed the api calls.

I thought that all I should have to do is this:

sqlite3 gbpvr.db3 "insert into recording_schedule values(15,'',2,2,'c:\testme1.mpg',0,0,'2007-05-30 08:00:00.0000000','2007-05-30 08:13:00.0000000',43,1,1,2,0,'')"

Note that those are double quotes surrounding the insert command and two single quotes for fields that are left blank. All I did was take the values from an existing, good scheduled recording and change the file name and the time.

It is correctly inserted into the database. I can see it when I do a select * from recording_schedule.

The problem is that when I open up the media center interface, there are no scheduled recordings listed.

Any ideas on what I might be missing?

Thanks,

Bob

[zehd]

After you have inserted the record you have to 'gbpvr -onlyupdateepg' so that GBPVR will look your recording up against the EPG and fill in the schedule...

[sub]

You've set the status column to '2' which is 'STATUS_COMPLETED'. You'd probably need '0' aka 'STATUS_PENDING'.

[jd142]

You've set the status column to '2' which is 'STATUS_COMPLETED'. You'd probably need '0' aka 'STATUS_PENDING'.

Thank you! I think that was it. The media center interface now shows a pending recording for this evening. If it doesn't go off, I'll try the gbpvr -onlyupdateepg fix suggested.

That was very quick recognition of the insert. Is there a trigger command somewhere or does loading the media center interface force it to update?

[sub]

The front end should always reflect the up to date state in the database. The recording service may not recognise the update has occurred for quite a while, which is why zehd recommened the '-onlyupdateepg' thing (it'll force the recording service to update itself).