My Videos - Future version/update feature request.

[A_Brass]

Reven, the next time you decide to update or revise the My Videos plugin, I wondered if you could add a little feature.

A while back I asked you how My Videos picked up its database info from recorded TV. As I understand it, when you activate My Videos after a recording has been made the database info is copied from the gbpvr.mdb to the mydatabase.mdb.

I was wondering if you could introduce a postprocessing.bat command that would cause the info to be coppied from one data base to the other without having to activate the actual plugin.

My reason for this request is due to gbpvr.mdb database couruption or loss. I have finally been able to get my wife to accept the PVR in the living room and My Videos is her goto plugin for any video playback. If the gbpvr.mdb data base gets compromised (because I sometimes run another GBPVR install as a client). Her show appears in MyVideos, but not the description.

This little thing would help me with the WAF. Belive it or not she actually was able to find a show, watch it and skip commericals without my intervention. SUCCESS!!

[reven]

hmmmmmmmmmmmm, the only problem here is well, to ensure the db doesnt grow huge (one recording doesnt take up alot of space anyway, but it could grow huge of decades of use), you would have to delete the recordings from the "my videos" plugin (otherwise they would stay in the db forever, or unless you manually remove them using access).

i would consider writing a little app that you could add to the postprocessing.bat file, but not part of my videos its self. anyone else who wants to do this they can, it might take me a couple of weeks to get around to it (and knowing me ill probably forget....)

anyway its a simple task, that if i remember and get free time ill do.

[A_Brass]

hmmmmmmmmmmmm, the only problem here is well, to ensure the db doesnt grow huge (one recording doesnt take up alot of space anyway, but it could grow huge of decades of use), you would have to delete the recordings from the "my videos" plugin (otherwise they would stay in the db forever, or unless you manually remove them using access).

So if I understand you correctly, show info grabbed from the gbpvr.mdb is placed in mydatabase.mdb but is not removed when I delete the recording? Unless I delete the recording from within My Videos. Is this correct?

If that's the case I would have to ask for two app's one to perform the requested function and another (down the road) to purge my old photos videos and music from mydatabease.mdb.

i would consider writing a little app that you could add to the postprocessing.bat file, but not part of my videos its self. anyone else who wants to do this they can, it might take me a couple of weeks to get around to it (and knowing me ill probably forget....)

anyway its a simple task, that if i remember and get free time ill do.

I can wait. And if you want I can remind you. Another option would be to read and/or import the info file exported by xrecord. Sort of like the details.txt (I think that's right) feature.

The xrecord exported file looks like this: filename.mpg.dat
This is the content of the dat file.

title=Thomas & Friends
description=Cleanliness competition; Christmas puddings; Edward races Spencer.
fullfilename=Z:\MyTV\Thomas & Friends\Thomas & Friends_20050723_07300800.mpg
filename=Thomas & Friends_20050723_07300800.mpg
starttime=7/23/2005 7:30:00 AM
endtime=7/23/2005 8:00:00 AM
uniqueid=89880
channel=6 WETK
subtitle=Determination
recordedtime=7/23/2005 7:30 AM - 8:00 AM
channelnumber=6
starttimeticks=632577006000000000
endtimeticks=632577024000000000
quality=1
chainfile=

I"m guessing you would only need the first four lines of data the rest is recording info. Not really needed for My Videos.

Let me know what you think.

Oh yeah if you didn't already figure it out. I'm a HUGE fan of all your My series work. And I'm looking forward the offical release of the new My Pictures.

Thanks.

[reven]

So if I understand you correctly, show info grabbed from the gbpvr.mdb is placed in mydatabase.mdb but is not removed when I delete the recording? Unless I delete the recording from within My Videos. Is this correct?

yup

If that's the case I would have to ask for two app's one to perform the requested function and another (down the road) to purge my old photos videos and music from mydatabease.mdb.

the probelm here is that the files are stored by relative names in the database, eg "Enterprise - 2x02 - Carbon Creek.avi" and not the full filename, so theres no way to tell where the file is, and if its been deleted. and the reason i used relative names was to avoid the problem sub has with the gbpvr database, where if the file is found in the exact location, its deleted.


the .dat file importer.... im not sure if ill import it to the database or just show it along with the file, otherwise whenever you enter the directory it will see the .dat file, read it and update the database (and every time you enter it, the db will be updated). the only way to fix this is to delete the file after reading (which i suppose is not what you want).

[A_Brass]

the probelm here is that the files are stored by relative names in the database, eg "Enterprise - 2x02 - Carbon Creek.avi" and not the full filename, so theres no way to tell where the file is, and if its been deleted. and the reason i used relative names was to avoid the problem sub has with the gbpvr database, where if the file is found in the exact location, its deleted.).

Hum, So (just poking fun) Your a huge fan of proper file structure, which would indicate a very organized person. But when you constructed your database structure you didn't take into account that files might be removed or otherwise deleted? So you created the ever increasing "mydatabase" the unshrinkable database that will grow to huge sizes causing longer and longer access times? Jeeze!

Seriously, what you have indicated is that the database should be deleted every once and a while or opened in access and cleaned. The only problem I can see is recorded TV. Most of my pics, and music will stay. My movie collection will change occasionaly. But TV changes weekly.

the .dat file importer.... im not sure if ill import it to the database or just show it along with the file, otherwise whenever you enter the directory it will see the .dat file, read it and update the database (and every time you enter it, the db will be updated). the only way to fix this is to delete the file after reading (which i suppose is not what you want).

I would be fine with a dat file read. That's what Xrecord does. But if you created a seperate import utility that can be run in the postprocessing.bat, couldn't it just import the dat file that was just created? This would require no changes to the My Videos Plugin.

Your thoughts?

[jksmurf]

Just thought I'd drop a note here re. the WIKI link to

http://mkisofs.sourceforge.net/ being dead. Googled on the name and got a few versions http://www.andante.org/mkisofs.html has old files,
http://www.dlhoffman.com/publiclibrary/RPM/mkisofs.html Linux rpms?

Do you have a recommendation on which to use?

k.

[A_Brass]

Just thought I'd drop a note here re. the WIKI link to

http://mkisofs.sourceforge.net/ being dead. Googled on the name and got a few versions http://www.andante.org/mkisofs.html has old files,
http://www.dlhoffman.com/publiclibrary/RPM/mkisofs.html Linux rpms?

Do you have a recommendation on which to use?

k.

I dont follow you. What does this have to do with this thread?

[reven]

Hum, So (just poking fun) Your a huge fan of proper file structure, which would indicate a very organized person. But when you constructed your database structure you didn't take into account that files might be removed or otherwise deleted? So you created the ever increasing "mydatabase" the unshrinkable database that will grow to huge sizes causing longer and longer access times? Jeeze!

only my videos stores the info by relative name, everything else is absolute. the reason everything is by relative name, is i have many shows on dvds (as avi files etc), and well sometime i put that dvd into drive e: and sometimes drive f:. and if they were stored by relative names i would have to have 2 entries for each video. and if they were automatically deleted if not found, every single video file i have on a removable medium would be gone (and what if the network went down aswell....)

if you think about it, it makes sense. ive been running it this way for ages, and my db is only about 80megs (well if you dont include the my pictures thumbnails, they can be large). the db isnt going to grow to extremes, so dont worry.

I would be fine with a dat file read. That's what Xrecord does. But if you created a seperate import utility that can be run in the postprocessing.bat, couldn't it just import the dat file that was just created? This would require no changes to the My Videos Plugin.

yeah but then you would have to run that once a day, im not a big fan of lots extra utils, some are needed, but some are just silly.

[jksmurf]

I dont follow you. What does this have to do with this thread?

Look, it has nothing to do with it, and I'd be the first to admit it. I was looking for a download required for this plugin (according to the WIKI) and I just didn't think it merited a whole new thread, so I found an old one that seemed appropriate, as it started off talking about updates to the plugin, and popped it in here, considering that if updates were being made anwyay, the WIKI instructions//links would/could be updated at the same time. My apologies if this is against protocol.
k.

[reven]

jksmurf: got here http://www.sbox.tugraz.at/home/t/tplank/ and download the cdrtools win32 binaries, cdrtools should come with mkisofs, also once you get that, tell me if it does infact work, and then ill update the wiki.

ps dont be afraid to start a new thread, it just keeps order.