Scan and clean the video database, purge removed vidoes

[scoob]

imho, the two features are essential for good movie watching:

1. delete files off hd/share; either through imdb access or browsing the file name. often i'll see a movie or see the bad imdb and won't want to keep the file in storage and would rather just drop it all together
2. purge the imdb database; my imdb database is fill of orphaned records after i have deleted the actual movie file; similar to "scan" there should be a purge and deletion of records where the movie file has gone

i imagine these would be fairly simple to implement programmatically, provided there weren't security issues with #1. if we can't have #1 then #2 would be great and i'll take care of deletions myself. hey, i'll do the design for you...

for each movie in imdb
if file does not exist then delete db record
next movie

so i used to be a vb programmer...bite me :)

[jmarshall]

1. is possible via the filemanager at the moment.
2. is possible by pressing black?? during title view.

obviously, all that's required is to automate it (like the bit of code you suggested).

should be reasonably easy to do as you say - the music database has just this cleanup procedure of it's database.

i'm sure that when the context menu is added to my videos we can add an option for number 1 from the video screens.

cheers,
jonathan

[scoob]

hi jonathan,

i'm wondering if #2 is any closer to development? i think the conext menu for videos is there now. every time i switch to genre/title views i get a lot of records showing which either don't match the actual file they're attached to or the file has since been deleted and the record is an orphan. to keep my video db up-to-date there's a lot of work involved in manually deleting the file and then manually deleting the db record. there's also no way to be sure you're deleting corresponding file/db records with a large collection. next to impossible if i'm using my pc to bulk delete files from my shared hd.

appreciate the efforts anyway. xbmc absolutely rocks. i have seen the source so at some point i might make the changes myself and send in for review. but i probably couldn't manage that for several months away.

[scoob]

could we please, please have the option to scan and remove entries from the video db if the associated file is no longer available (deleted).

and can we please, please have the context menu option to delete the video file when in files view (and the associated db entry) and delete the file when deleting the db entry from the genre/actor/etc db views. maybe then an option in the system prefs to turn file deletion on/off (default off) for those that don't want this.

this would save me massive amounts of time with current manual deletions and a video db full of orphaned (and duplicate) records.

[Livin]

this would tie in perfectly with something i suggested a long while ago... a scheduled scan.

so every so-often (user sets timeframe, say every 10 hours) the system scans the folders and deletes entries in the db that no longer exists and adds new files.

i cannot be the only one that wants this but no one else said anything at the time.