PostProcessing.bat problem

[BrettB]

Or I might try to create mine to update db recordings table via command line sqllite3...

You would be better off using NScriptHelper. As I recall there is an option for renaming the file in the database. I'm not sure it works with v5's NScriptHelper yet though. Sub will probably need to verify that.

[aderlopas]

Or I might try to create mine to update db recordings table via command line sqllite3...

You would be better off using NScriptHelper. As I recall there is an option for renaming the file in the database. I'm not sure it works with v5's NScriptHelper yet though. Sub will probably need to verify that.

Thanks, problem is I have no clue how NScriptHelper works...
I managed to found the recorded file table (scheduled_recording), but is the primary key (oid) being passed to the %1 parameter so that we can locate the record and update the filename once file has been moved? Can you help us @sub with a few internal information ? 

[sub]

Or I might try to create mine to update db recordings table via command line sqllite3...

You would be better off using NScriptHelper. As I recall there is an option for renaming the file in the database. I'm not sure it works with v5's NScriptHelper yet though. Sub will probably need to verify that.

Thanks, problem is I have no clue how NScriptHelper works...

Unfortunate NScriptHelper in v4 vs v5 have wildly different functionality, with only a little overlap. This is mostly due to the way v5 exposes NextPVR's http api to the user, rather than just set of small set of specific things that v4 did.

v4 had a rename. v5 doesn't at this stage (since the api doesn't have this). I'll look to add it though.

I managed to found the recorded file table (scheduled_recording), but is the primary key (oid) being passed to the %1 parameter so that we can locate the record and update the filename once file has been moved? Can you help us @sub with a few internal information ? 

Parameters passed in to PostProcessing.bat, in this order, are:

recording filename,
channel number,
recording oid,
capture source oid,
show title

[aderlopas]

Or I might try to create mine to update db recordings table via command line sqllite3...

You would be better off using NScriptHelper. As I recall there is an option for renaming the file in the database. I'm not sure it works with v5's NScriptHelper yet though. Sub will probably need to verify that.

Thanks, problem is I have no clue how NScriptHelper works...

Unfortunate NScriptHelper in v4 vs v5 have wildly different functionality, with only a little overlap. This is mostly due to the way v5 exposes NextPVR's http api to the user, rather than just set of small set of specific things that v4 did.

v4 had a rename. v5 doesn't at this stage (since the api doesn't have this). I'll look to add it though.

I managed to found the recorded file table (scheduled_recording), but is the primary key (oid) being passed to the %1 parameter so that we can locate the record and update the filename once file has been moved? Can you help us @sub with a few internal information ? 

Parameters passed in to PostProcessing.bat, in this order, are:

recording filename,
channel number,
recording oid,
capture source oid,
show title

Many thanks sub, is there a delimiter used? If so which one?

[sub]

It quotes the parameter passed into the script, so that they end up as %1, %2, %3,%4 and %5

[aderlopas]

It quotes the parameter passed into the script, so that they end up as %1, %2, %3,%4 and %5

Oh perfect, so we don't have to split the environment variable.

I'll try and build a bat file, once I have made it working, I'll post it here...

[aderlopas]

Finished it and it is working. I placed sqlite3.exe tool under the same directory as npvr.db3. Note I also used xcopy /J as it copies unbuffered and works better with large files.
I also just change drive (send them to my sdcard) and keep exactly the same directory structure.
Here are the bat file contents:

============= start postprocessing.bat ====================
@ECHO OFF
REM %1 = recording filename
REM %2 = channel number
REM %3 = recording oid
REM %4 = capture source oid
REM %5 = show title
@ECHO ON
ECHO Finished recording %1 at %time% on %date% >> "C:\Users\Public\NPVR-data\logs\recordings.log"
xcopy "%~d1%~p1*.*" "D:%~p1" /e /f /J /Y >> "C:\Users\Public\NPVR-data\logs\recordings.log"
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"
rmdir "%~d1%~p1" /s /q
ECHO Post Processing Completed at %time% on %date% >> "C:\Users\Public\NPVR-data\logs\recordings.log"
============= end postprocessing.bat ====================