Is there a way to auto rename recorded files?

[GSpanFan]

Does anyone have a way to rename a recorded file name to include other program information such as the episode name or number? I used to use the addepisode or renamerecording utilities in GBPVR and this is the one item of functionality that I miss after migrating to NPVR, since I often stream recordings to my PS3. The default file naming scheme with the recorded dates and times is not always helpful when browsing through the recordings.

I've tinkered a bit with SQL to see if I could pull this information from the NPVR database, rename the file, and then update the database to point to the new file name. However, I am not the greatest programmer (I was trying to create a batch file to do this in post-processing) and don't want to reinvent the wheel if someone else has already developed a way to do this.

Any ideas?

[mvallevand]

NPVR no longer uses traditional database practice and instead embeds XML so this kind of operation is not trivial. If sub puts the series and episode number back in the XML I would like to create a utility to do this.

Martin

[pBS]

huh?
i was seeing some odd things in db too...trying to edit an entry..
any info on the new db architecture?
where is stuff stored now?

[pBS]

nm...i now see where the embedded data is, and the epg event stuff...
kinda cumbersome in a db editor cuz of multilines, but i understand why it's needed..

[JimF]

I hope sub can support you on this, since I need automatic renaming in order to include sub-titles too. Otherwise, NPVR is not of much use to me.

[martint123]

I guess XML has been out for quite a time now, are there any simple tools for querying/update embedded XML within a database?
Wouldn't it be handy to have an extension to SQL to make XML appear as pseudo fields ??

[Northpole]

I put together a batchfile that I have setup to run everynight that renames the files with title (date recorded) sub-title. Also renames the folder.jpg artwork and creates a show information xml file that npvr can read. It moves the files up one directory tree and deletes the subdirectory that NPVR created.

Can't take any credit for the sql queries which came from http://forums.gbpvr.com//showthread.php?...n-NPVR.db3

This batchfile requires ssed.exe from the above link (Post #3) and sqlite3.exe. Also credit goes to pBS for the registry query. Put the batchfile, ssed and sqlite3 together in any subdirectory.

heres the batchfile:

Code:

@echo off
title Automatic TS File Rename

set progdir=%~dp0
for /f "usebackq skip=4 tokens=1,2,*" %%i in (`reg query hklm\SOFTWARE\npvr /v "DataDirectory"`) do set db=%%~k\npvr.db3
"%progdir%\sqlite3.exe" "%db%" "SELECT filename from SCHEDULED_RECORDING where status = '2';" > "%progdir%\fname.txt"

:checkfname
if not exist "%progdir%fname.txt" ping 1.1.1.1 -n 1 -w 2000 >NUL & goto :checkfname
for /f "usebackq tokens=*" %%i in ("%progdir%fname.txt") do call :Convert "%%i"

"C:\Program Files\NPVR\NextPVR.exe" -updateepgonly
goto :eof

:Convert

set sdrive=""
set spath=""
set sname=""
set sdate=""
set smonth=""
set sday=""
set syear=""
set npvrname=""
set npvrsub=""
set tmpname=%random%

for /f %%i in ("%~t1") do set sdate=%%i
for /f "tokens=1,2,3 delims=/" %%i in ("%sdate%") do set smonth=%%i& set sday=%%j& set syear=%%k
for /f "tokens=1,2,3 delims=\" %%i in ("%~1") do set sdrive=%%i& set spath=%%j& set sname=%%k

"%progdir%sqlite3.exe" "%db%" "SELECT event_details from SCHEDULED_RECORDING where status = '2' and filename = '%~1';" | "%progdir%ssed.exe" "s/'//g" > "%progdir%details1.txt"

:checkdetails1
if not exist "%progdir%details1.txt" ping 1.1.1.1 -n 1 -w 2000 >NUL & goto :checkdetails1
"%progdir%ssed.exe" "s/://g" < "%progdir%details1.txt" > "%progdir%details2.txt"

:checkdetails2
if not exist "%progdir%details2.txt" ping 1.1.1.1 -n 1 -w 2000 >NUL & goto :checkdetails2
"%progdir%ssed.exe" "s/?//g" < "%progdir%details2.txt" > "%progdir%details3.txt"

:checkdetails3
if not exist "%progdir%details3.txt" ping 1.1.1.1 -n 1 -w 2000 >NUL & goto :checkdetails3
"%progdir%ssed.exe" "s/*//g" < "%progdir%details3.txt" > "%progdir%details.txt"

:checkdetails
if not exist "%progdir%details.txt" ping 1.1.1.1 -n 1 -w 2000 >NUL & goto :checkdetails
"%progdir%ssed.exe" -n -e "s/.*<Title>\(.*\)<\/Title>.*/\1/p" < "%progdir%details.txt" > "%progdir%title.txt"
"%progdir%ssed.exe" -n -e "s/.*<SubTitle>\(.*\)<\/SubTitle>.*/\1/p" < "%progdir%details.txt" > "%progdir%subtitle.txt"

:checktitle
if not exist "%progdir%title.txt" ping 1.1.1.1 -n 1 -w 2000 >NUL & goto :checktitle
for /f "usebackq tokens=*" %%i in ("%progdir%title.txt") do set npvrname=%%i

set fname=%sname%

echo ^<Title^> > "%~dpn1.xml"
echo ^<FullTitle^> >> "%~dpn1.xml"
"%progdir%\sqlite3.exe" "%db%" "SELECT name from SCHEDULED_RECORDING where status = '2' and filename = '%~1';" >> "%~dpn1.xml"
echo ^</FullTitle^> >> "%~dpn1.xml"

if "%fname%" NEQ "%npvrname%" goto :blank

:checksub
if not exist "%progdir%\subtitle.txt" ping 1.1.1.1 -n 1 -w 2000 >NUL & goto :checksub
for /f "usebackq tokens=*" %%i in ("%progdir%\subtitle.txt") do set npvrsub=%%i

if ""==%npvrsub% goto :nosub

set fname=%sname% (%syear%-%smonth%-%sday%) %npvrsub%

echo ^<SubTitle^> >> "%~dpn1.xml"
"%progdir%sqlite3.exe" "%db%" "SELECT event_details from SCHEDULED_RECORDING where status = '2' and filename = '%~1';" | "%progdir%ssed.exe" -n -e "s/.*<SubTitle>\(.*\)<\/SubTitle>.*/\1/p" >> "%~dpn1.xml"
echo ^</SubTitle^> >> "%~dpn1.xml"
goto :desc

:nosub
echo ^<SubTitle^>^</SubTitle^> >> "%~dpn1.xml"

:desc
echo ^<Description^> >> "%~dpn1.xml"
"%progdir%sqlite3.exe" "%db%" "SELECT event_details from SCHEDULED_RECORDING where status = '2' and filename = '%~1';" | "%progdir%ssed.exe" -n -e "s/.*<Description>\(.*\)<\/Description>.*/\1/p" >> "%~dpn1.xml"
echo ^</Description^> >> "%~dpn1.xml"
goto :finish

:blank
echo ^<SubTitle^>^</SubTitle^> >> "%~dpn1.xml"
echo ^<Description^>^</Description^> >> "%~dpn1.xml"

:finish
echo ^</Title^> >> "%~dpn1.xml"

if exist "%sdrive%\%spath%\%fname%.ts" rename "%sdrive%\%spath%\%fname%.ts" "%fname%-%tmpname%.ts"
if exist "%sdrive%\%spath%\%fname%.jpg" rename "%sdrive%\%spath%\%fname%.jpg" "%fname%-%tmpname%.jpg"
if exist "%sdrive%\%spath%\%fname%.xml" rename "%sdrive%\%spath%\%fname%.xml" "%fname%-%tmpname%.xml"

move %1 "%sdrive%\%spath%"
rename "%sdrive%\%spath%\%~n1.ts" "%fname%.ts"

move "%~dpn1.xml" "%sdrive%\%spath%"
rename "%sdrive%\%spath%\%~n1.xml" "%fname%.xml"

if exist "%~dp1folder.jpg" move "%~dp1folder.jpg" "%sdrive%\%spath%"
if exist "%sdrive%\%spath%\folder.jpg" rename "%sdrive%\%spath%\folder.jpg" "%fname%.jpg"

rd "%sdrive%\%spath%\%sname%

if exist "%progdir%fname.txt" del "%progdir%fname.txt"
if exist "%progdir%details.txt" del "%progdir%details.txt"
if exist "%progdir%details1.txt" del "%progdir%details1.txt"
if exist "%progdir%details2.txt" del "%progdir%details2.txt"
if exist "%progdir%details3.txt" del "%progdir%details3.txt"
if exist "%progdir%title.txt" del "%progdir%title.txt"
if exist "%progdir%subtitle.txt" del "%progdir%subtitle.txt"

goto :eof

Works for WinXP MCE. Hope this help.

Haven't got around to looking into updating the npvr sql database after the file is moved.

[carpeVideo]

guidePlus will do it on a nightly basis for either gbpvr on npvr including season and episode depending on your epg source. For npvr it does require an additional table and trigger(which it will create for you) in the database and an epg delete / refresh to get the currently scheduled recordings renamed. With gbpvr it will rename existing recordings but for npvr it will not rename recordings finished before you add the trigger.

http://gbpvr.com/pmwiki/pmwiki.php/Utility/GuidePlus

If you don't want the guide part then you could always just ignore the generated XML file and use it as a rename / mover only

[Northpole]

guidePlus will do it on a nightly basis for either gbpvr on npvr including season and episode depending on your epg source. For npvr it does require an additional table and trigger(which it will create for you) in the database and an epg delete / refresh to get the currently scheduled recordings renamed. With gbpvr it will rename existing recordings but for npvr it will not rename recordings finished before you add the trigger.

http://gbpvr.com/pmwiki/pmwiki.php/Utility/GuidePlus

If you don't want the guide part then you could always just ignore the generated XML file and use it as a rename / mover only

Thanks, I'll check that out.

[Lastchoice]

I've been looking for this exact same capability and guidePlus looks like what I need, however it throws a SQLite exception on my 64-bit Windows 7 instance.

I can get the app to run on seperate 32-bit PC, however it fails to find the nPVR database on the remote HTPC.

Does guidePlus work on 64-bit machines? If not is there a way to run it on a PC seperate from the nPVR installation?

Thanks!