England
Hi
Can anyone help me with a small development type question?
I use TVServer to record a lot of DVB radio shows which I convert to MP3 so that I can listen to them in the car.
I have written a few quick and dirty batch files that scan the recordings folder for new radio recordings, extract the MP2 audio streams and then transcode MP2=>MP3.
Once I've sucessfully transcoded the audio files I remove the .TS files from the recordings folder and clean up any redundant .XML files and empty folders.
What I am looking for is a suitable SQL statement that will remove the converted recordings from the SQL Express database. I appreciate that I'll probably need to use VBScript or similar to check recordings folder and I'm comfortable with that but I'm not clear which tables within the database I'll need to look at and update.
At the moment, I'm able to do the cleanup manually through the TVServer Setup UI but I'd like to make this part of my script.
Any help greatly appreciated.
Cheers
Mark
Can anyone help me with a small development type question?
I use TVServer to record a lot of DVB radio shows which I convert to MP3 so that I can listen to them in the car.
I have written a few quick and dirty batch files that scan the recordings folder for new radio recordings, extract the MP2 audio streams and then transcode MP2=>MP3.
Once I've sucessfully transcoded the audio files I remove the .TS files from the recordings folder and clean up any redundant .XML files and empty folders.
What I am looking for is a suitable SQL statement that will remove the converted recordings from the SQL Express database. I appreciate that I'll probably need to use VBScript or similar to check recordings folder and I'm comfortable with that but I'm not clear which tables within the database I'll need to look at and update.
At the moment, I'm able to do the cleanup manually through the TVServer Setup UI but I'd like to make this part of my script.
Any help greatly appreciated.
Cheers
Mark