2007-05-29, 05:29 PM
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
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