2020-03-10, 07:06 PM
Hello,
Something strange has happened with a recurring (keyword) recording that I have scheduled.
recording was done, transcoded, and my postprocessing.bat was executed to move the whole directory including this recording to another drive succesfully.
Also npvr.db3 update command was updated with new filename based on OID provided to the batchprocessing.bat (%3 parameter), using the below command (which was tested working in the past):
call "C:\Users\Public\NPVR-data\sqlite3.exe" "C:\Users\Public\NPVR-data\npvr.db3" "update `SCHEDULED_RECORDING` set `filename`='D:%~p1%~n1%~x1' where `oid`=%3;" ".exit" >> "C:\Users\Public\NPVR-data\logs\recordings.log"
However, filename field inside npvr.db3 was not updated and it still has the value: [Default]
I am wondering what may have happened (most likely %3 parameter was not correctly populated? but I was not echoing the parameter in the log, I have changed the .bat file now to echo the parameters as well to a log). If so, why?
Please note that this scheduled recording was a special one as the TV played two episodes at once, one after the other (the recording resulted 6GB file as I am also pre-padding and post-padding 1 hour).
From the filename and directory structure, I did not see any episode number created so could it be that %3 parameter was null? (and hence my SQL update failed to locate the record?)
Also, having the attached XML, I tried to change the drive letter and import it but it still was not imported. Any help to import it would be appreciated.
Thanks and regards
Argyrios
Something strange has happened with a recurring (keyword) recording that I have scheduled.
recording was done, transcoded, and my postprocessing.bat was executed to move the whole directory including this recording to another drive succesfully.
Also npvr.db3 update command was updated with new filename based on OID provided to the batchprocessing.bat (%3 parameter), using the below command (which was tested working in the past):
call "C:\Users\Public\NPVR-data\sqlite3.exe" "C:\Users\Public\NPVR-data\npvr.db3" "update `SCHEDULED_RECORDING` set `filename`='D:%~p1%~n1%~x1' where `oid`=%3;" ".exit" >> "C:\Users\Public\NPVR-data\logs\recordings.log"
However, filename field inside npvr.db3 was not updated and it still has the value: [Default]
I am wondering what may have happened (most likely %3 parameter was not correctly populated? but I was not echoing the parameter in the log, I have changed the .bat file now to echo the parameters as well to a log). If so, why?
Please note that this scheduled recording was a special one as the TV played two episodes at once, one after the other (the recording resulted 6GB file as I am also pre-padding and post-padding 1 hour).
From the filename and directory structure, I did not see any episode number created so could it be that %3 parameter was null? (and hence my SQL update failed to locate the record?)
Also, having the attached XML, I tried to change the drive letter and import it but it still was not imported. Any help to import it would be appreciated.
Thanks and regards
Argyrios