sqlite database modifications

[skippy_nz]

Hey sub - just checking up to see if the following is possible - ive got an autoit script that moves my recordings from the recordings folder to the my videos library but i want to keep my descriptions etc so what do i need to change in the database ie table / data wise etc ?

i want to see if its possible by using autoit first and if not i might need to delve a little deeper into what you and others are using for those edits.

cheers
Skip

[sub]

The recording's filename is stored in the RECORDING_SCHEDULE table, in the 'filename' column. Be careful dicking around with the database though - its easy to break things. Make sure you back up your database first...

[skippy_nz]

thanks for the advise - will make sure i have at least 2 or 3 backups just in case

[LouCypher]

I recently used SQLite Database Browser to edit my gbpvr.db3 file. It worked great.

[skippy_nz]

ok - ive got my little util to do the following

* moves the files from the source folder (recording dir) to the destination folder (anywhere you specify)
* if the file being moved has a .mpg extn it updates the database to the new location
* when the source folder is empty its then deleted.

thats all fine but i think ive just created something i didnt mean to create - haha stupid me - so if anyone wants a util to move recorded programs around the place at the click of a button just let me know...

but what i wanted to achieve was to be able to keep the show descriptions and info that was showing up against a tv program to be available in the video library - sub is this possible or am i dreaming ?

cheers
Skip

[sub]

but what i wanted to achieve was to be able to keep the show descriptions and info that was showing up against a tv program to be available in the video library - sub is this possible or am i dreaming ?

There is no popup screens in the Video Library that show this type of info, so no matter what you fiddle around with in the database you're not going to get this. You'd have to access the recording through the Recording screen to see this type of info.

[pBS]

yea, that won't show up in vid library, but they'll still show up in 'recordings' if you update the 'file' part of the db...i wrote a batch file to do same thing using sqlite3.exe and batch file.. copies comskip .txt and extras too..
http://forums.nextpvr.com/showthread.php?t=26775
now even deletes original dir if no shows left in it...

in mine,i copy show plus extras, adjust db, then delete original...[safest way]
[it takes a good while to copy several gigs] so you don't need to edit the <autodeletemissingrecordings> settings...this way works fine without it..


works like a charm.. looks like nothing's happened in Recordings screen, but the drive sure has lots more space!
sometimes i put my HD stuff on another drive from postprocessing.bat cuz it takes up so much space...

[skippy_nz]

There is no popup screens in the Video Library that show this type of info, so no matter what you fiddle around with in the database you're not going to get this. You'd have to access the recording through the Recording screen to see this type of info.

oh right - bugger - is there any chance that this can be added for archiving purposes ?

[skippy_nz]

yea, that won't show up in vid library, but they'll still show up in 'recordings' if you update the 'file' part of the db...i wrote a batch file to do same thing using sqlite3.exe and batch file.. copies comskip .txt and extras too..
http://forums.nextpvr.com/showthread.php?t=26775
now even deletes original dir if no shows left in it...

in mine,i copy show plus extras, adjust db, then delete original...[safest way]
[it takes a good while to copy several gigs] so you don't need to edit the <autodeletemissingrecordings> settings...this way works fine without it..


works like a charm.. looks like nothing's happened in Recordings screen, but the drive sure has lots more space!
sometimes i put my HD stuff on another drive from postprocessing.bat cuz it takes up so much space...

i should have searched to see if anyone else had done something similar - but i guess it helped my sql skills learning the commands to read in a column and then modifying the data....

my script moves the all the data from one folder to another folder - if its on a different drive autoit automatically copies the data then deletes the original when done- and yeah it deletes the original folder once the files have been moved.

cheers
Skip

[sub]

oh right - bugger - is there any chance that this can be added for archiving purposes ?

Sorry, probably not. That was what the Recordings screen is intended to be for - viewing the details about a recording/show prior to playing it. Is there a specific reason you dont want it in the recording screen? It shows the details that it sounds like you want to see.