Current program details, from batch file!

[Jim_]

i'm going to try to save and import recordings info from a remote database!..
as long as it opens it from a unc path it should be fine..
so even looking stuff up should be possible if it works..

SUCCESS!!!
now that is going to be usefull..lol
i have 2 machines with gbpvr installed, and now i can share the recordings info automatically...
plus i'm going to work on a reoccuring recordings import/export..
too cool...hehe

Please share!

Keeping with the multiple computer line of thought, here are a couple of ideas I’m thinking about.
I have two GBPVR computers with a single tuner each, my parents have a laptop without a tuner.

It would be very cool to offload the conflict recordings from both gbpvr systems to a single file on the network, so the other computer could pick up the conflict and record it.

Another idea would be to have my parents use GBPVR on their laptop to schedule programs they want to watch.
Their schedule could then be automatically offloaded and emailed (or synced to my ftp) and my first available (non-conflict) computer could record it for them!
I use the EWA, but they’re not computer literate. Recording conflicts and the ability to delete things makes the EWA a no-go for them.

Jim

[dark_half]

I tried what you suggested but it errors out with

Code:

SQL error: unrecognized token: ":"

Here is a sample of the batch. Also if I follow what it being done correctly shoudn't "SELECT oid" be "SELECT programme_oid". Then again I may just be wrong and shouldn't be poking around the db. Anyway if you can point me in the right direction to resolve my token error I would appreciate it.

Code:

@echo off
set file_oid=
for /f "usebackq tokens=1,2 delims=, " %%v in (`sqlite3 -separator "," "C:\Program Files\DEVNZ\Gbpvr\GBPVR.DB3" " SELECT oid FROM RECORDING_SCHEDULE where filename=%1; " `) do @set file_oid=%%v
sqlite3 -separator ": " "C:\Program Files\DEVNZ\Gbpvr\GBPVR.DB3" " SELECT description FROM PROGRAMME where oid = '%file_oid%' ; "
pause

[pBS]

yep...my mistake...they are similar up till about 100 for me..
also may want to enclose %1 in single quotes...
i think that may do it...

[pBS]

here goes...
EDIT: now uses 'LIKE' for case insensitivity!

Code:

@echo off
set file_oid=
for /f "usebackq tokens=1,2 delims=," %%v in (`sqlite3 "\\Pvr\os\program files\devnz\gbpvr\gbpvr.db3" "SELECT programme_oid FROM RECORDING_SCHEDULE where filename LIKE '%~1';"`) do set file_oid=%%~v
sqlite3 "\\Pvr\os\program files\devnz\gbpvr\gbpvr.db3" " SELECT description FROM PROGRAMME where oid='%file_oid%'; "
pause

adjust the database string for yours and it's good to go..
enjoy!
[notice how mine is grabbing from remote data? ]
and be very carefull with the quotes...sqlite likes singles, and windows gives out doubles..so i use the %~1 to remove quotes so i can add singles..

[dark_half]

Thank you that did it. All I had to do was change the location of the database.

[pBS]

added LIKE to last post so won't need exact case for matches...
lots of goodies still left to explore..
weeee!

[pBS]

oh and i meant recording_type, not the status, tho i needed that too..
[trying to save re-occurings..]
i combined the previous 2 lines into one single one...hehe
[both sql statements on one line]
makes cross referencing neater...first gets the programme-oid, the second looks up info based on that... so only one line statement to return info...neater..

Code:

for /f "usebackq tokens=1,2 delims=," %%v in (`sqlite3 "%db%" "SELECT programme_oid FROM RECORDING_SCHEDULE where status= '4' and recording_type='5'; " `) do sqlite3 "%db%" " SELECT name, sub_title FROM PROGRAMME where oid='%%v'; "

currently i can backup the re-occurings, and restore, but only overwriting whatever's there...
can't figure out how to use the last_insert_rowid thingy..
i see that lots of times in the logs..

is there any way to get the 'next' row insert number??
i figured i could list the rows and take highest plus 1...
any quicker [or built-in] ways?

also, i found that adding % around a search term is like a wildcard*,eg: a [where description like '%word%' ] would find all descriptions with the word 'word' in it..

[Mister Slimm]

GBPVRcli allows access to recordings information in the GB-PVR database and allows you to output the information formatted in any way you can think of. The output can be redirected to another batch file which can then be executed in order to accomplish any task. At this time, it does not allow you to change information in the database.

[pBS]

just use an insert command and leave out the oid column, [replace with NULL]
or the hard way, list all oid's and take highest one, and add 1...

i have re-occuring recordings able to be exported, and re-imported finally..

now just have to tie it up with the reoccurring_extras and figure out what to do about capture source settings...[and if anything else is tied to them and needed to be backed up or changed..any ideas Sub?]
it's the one thing that is a real pain to rebuild if you want to do a fresh install...

[KingArgyle]

pBS, you might be able to use CDK Scheduler's PriorityRecording.xml file to handle your show exports, and then use it to re-import. It should work for all your Re-Occuring recordings, and it already defines information for Capture Source, start times, end times, etc.

There is an XML Schema on the CDK Scheduler page that shows the layout, as well as some documentation on the elements.