Manipulating "recording-backup.xml"

[SANGER_A2]

I want to be able to rename my recorded files based on the episode subtitle eg "American Chopper_20110530_20002100.mp4" (after processing) becomes "American Chopper - Fire Bike (Part 1)".

Of course, I'll also need to update the db3 and xml file afterwards. I played around with the db3 file and realised that the episode information for recordings is not stored in there, but in the "recording-backup.xml" file (Sub correct me if I'm wrong here) using the Subtitle tag for the episode title.

So basically, after my postprocessing.bat has finished encoding with handbrake I want it to:-

Code:

search in npvr.db3 for %~f1 & replace it with %~dpn1.mp4
[COLOR="blue"]search in recording-backup.xml for %~f1 & replace it with %~dpn1.mp4
search in recording-backup.xml for %~dpn1.mp4 and output [showname] to a txt file
search in recording-backup.xml for %~dpn1.mp4 and output [subtitle] it to a txt file[/COLOR]
check if the subtitle txt file is empty and if it is end the bat file
get the showname from the txt file and into %showname% variable
get the subtitle from the txt file and into %subtitle% variable
Put "%~dp1%showname% - %subtitle%.mp4" into %newfilename% variable
Check if %newfilename% already exists, if so, put (2) after it
rename recording to %newfilename%

search in npvr.db3 for  %~dpn1.mp4 & replace it with %newfilename%
[color=blue]search in recording-backup.xml for  %~dpn1.mp4 & replace it with %newfilename%[/color]

The commands in blue are the ones I'm not sure how to do! Any help would be awesome.

I've had a look into "XMLStarlet", but I wanted to know if there was anything easier to use or that's recommended. I've used sqlite3.exe with no issues, but not tried to manipulate XML files before.

[sub]

NPVR never looks at recordings-backup.xml. It is effectively a back up of what is in the database, and only used for reimporting you recordings if (for example) you database became corrupt and you had to start again from an empty database.

[SANGER_A2]

NPVR never looks at recordings-backup.xml. It is effectively a back up of what is in the database, and only used for reimporting you recordings if (for example) you database became corrupt and you had to start again from an empty database.

Thanks a lot Sub. That makes it easier! I just had a look in "event_details" and saw all the data in there. Pity it's in XML format, but I'm sure there is some clever XML that can get just the data I want depending on the tags.

Sub, I'm assuming you're an SQL guru as well as coding guru! Do you already do something like this and you can drop a few hints to get me started? Or should I start googling? I'm not new to SQL so I'm sure there is a way, even if I have to do a search for title> and file the char position and use mid etc etc!

[sub]

Sorry, I'm no SQL guru. Pretty much all my stuff is done from code, and only uses simple SQL queries.

[SANGER_A2]

Sorry, I'm no SQL guru. Pretty much all my stuff is done from code, and only uses simple SQL queries.

Unfortunately I'm used to MS-SQL and SQLite doesn't have as many functions as that. It doesn't even have an Instr. I'll have to output the event_details to a text file, use a VBS to edit it and get out data as I wish and then edit the text file to have SQLite update the database. Annoying really but not majorly hard to do! I want it all to be pretty transparent as to what is being done in case anyone else want to use it and also so I can make changes easily myself later on.

I know this is totally off-topic, but I'm totally chuffed about it. I just won my replacement NPVR machine for £30 and will be picking it up soon. Once I've pinched some RAM from work and slotted in an old SATA HDD it will run much better than my current P4 with DDR1 RAM!

[sub]

Here is a utility that might help you.

Get the title of recording from a filename:
NScriptHelper.exe -title <filename>

Get the subtitle of recording from a filename:
NScriptHelper.exe -subtitle <filename>

Get the description of recording from a filename:
NScriptHelper.exe -description <filename>

Change the filename of a recording the database:
NScriptHelper.exe -rename <original_filename> <new_filename>

This last one only updates the filename in database. Its up to you to rename the file on the filesystem. Probably best to rename the file before calling this.

[SANGER_A2]

Here is a utility that might help you.

Get the title of recording from a filename:
NScriptHelper.exe -title <filename>

Get the subtitle of recording from a filename:
NScriptHelper.exe -subtitle <filename>

Get the description of recording from a filename:
NScriptHelper.exe -description <filename>

Change the filename of a recording the database:
NScriptHelper.exe -rename <original_filename> <new_filename>

This last one only updates the filename in database. Its up to you to rename the file on the filesystem. Probably best to rename the file before calling this.

Wow! You just saved me hours of messing around there! Assuming it works okay on my system anyway! Thanks alot Sub.

[JimF]

Wow! You just saved me hours of messing around there! Assuming it works okay on my system anyway! Thanks alot Sub.

Will you make that available for download? That would be very interesting for a lot of people in the U.S.

[gEd]

make sure to check out this batch file

http://forums.nextpvr.com/showthread.php...recordings

[SANGER_A2]

make sure to check out this batch file

http://forums.nextpvr.com/showthread.php...recordings

Nice. Thanks very much. That's pretty much what I would have been doing if Sub hadn't posted that app!

Whatever I end up using I'll post here. I've gotta spend the next day or two moving over to my new machine and then I can start experimenting.

Cheers.