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....