Video Library Archive addon beta

[pBS]

i recently made a batch to "archive" shows to a new location and adjust the database to reflect it, so all info is retained..

Code:

sqlite3.exe -separator "," "%db%" "UPDATE RECORDING_SCHEDULE SET filename = 'z:\newlocation\show1.mpg' where filename like 'show1.mpg';"

and added some batch file copy bits, and a profile to allow 'archiving' from the video library...
archive.bat:

Code:

@echo off echo starting from %cd% >archive.log echo %0 %1 %2 %3 %4 %5 %6 %7 %8 %9 >>archive.log set db=GBPVR.DB3 set oid= for /f "usebackq tokens=1,2 delims=," %%v in (`sqlite3 "%db%" "SELECT programme_oid FROM recording_schedule where filename like '%%%~nx1'; " `) do set oid=%%v echo oid = %oid% >>archive.log if "%oid%" EQU "" ( echo. >>archive.log echo ******** That file is not in GBPVR database! >>archive.log goto :eof ) echo. >>archive.log if not exist "%~dp2" md "%~dp2" copy "%~1" "%~2" echo copyerrors = %errorlevel% >>archive.log if not errorlevel 1 ( echo running sqlite >>archive.log sqlite3.exe -separator "," "%db%" "UPDATE RECORDING_SCHEDULE SET filename = '%~2%~nx1' where filename like '%~1';" del "%~f1" 2>NUL ) else ( echo Copy problem! >>archive.log ) echo Done. >>archive.log ECHO. >>archive.log ECHO. >>archive.log goto :eof

profile:

Code:

<Conversion name="Archive to k" exe="archive.bat" cmd=" {SOURCE_FILE} z:\newlocation\archive\ " targetExtension=".avi" />

place archive.bat in gbpvr\third party\ dir and adjust profile in config.xml to reflect your needs..
i'll probably make an installer soon..will make a nice n simple conflict-free archiving solution...
[so you can use multiple drives to store files and offload main rec drive seamlessly!]

Enjoy...

[Jeff]

The video archive plug-in includes an EXE that will do this too (and ccan be used without the video archive plug-in if desired). it will move all files older than N days old (where N is configurable) and can choose from a list of destinations, where it will either try to (i) move all that fit to the first destination in the list and, if more space is needed look in the next destination in the list and so on or (ii) it can be configured to move files to the destination with the most free space, in which case the drives will more or less fill up evenly over time.

Jeff

[pBS]

i noticed that....i just wanted one for one-offs and such...tho i did see how the automatic aspect is very usefull...
[plus this has the added 'advantage' of being user modifyable to some extent for customization..]

also played with ntfs mountings but quickly realized that although you can mount a drive as multiple dirs under your recording directory, you couldn't actually use it practically with GBPVR....