[mythtv-users] New/Bugfix Version: Bulk Updater for Videometa(imdb) data
seven at seven.dorksville.net
Mon Sep 24 07:01:39 UTC 2007
> There is yet another new version of the imdb-bulk-update.pl tool
> Download link:
> This version has major bugfix for something I inadvertently introduced in
> 1.4. So for anyone on 1.4, please move to this new version. I had a bug
> that was adding multiple entries into the DB when using the -Fileup
> switch. You may have only experienced it once, and the tool should have
> exited with an error when it was exhibited. But if you re-ran the script
> or ran out of cron, it's possible your DB has a few to many entries in it.
> The good news is, if you didn't run the -exclude on any of the new ones
> you may be able to quickly remove the duplicates with:
> This will dump all new and non-excluded entries from the DB. The new
> version will re-enter them with -Fileup cleanly..
> echo delete from videometadata where inetref=00000000\; | mysql -umythtv
> -pmythtv mythconverg
> If you have duplicate exlcudes this would work (however, it would also
> remove anything that -Exclude flagged before. so -Exclude would need to be
> run with the new version.
> echo delete from videometadata where inetref=99999999\; | mysql -umythtv
> -pmythtv mythconverg
> To remove those entries with actual titles & data matching will be
> trickier and may need some more careful processing. But to see if you have
> any duplicates you can do this:
> echo select intID, filename from videometadata order by filename\; | mysql
> -umythtv -pmythtv mythconverg
> This will sort the filenames and you should be able to easily spot those
> duplicates. Then you'd want to delete from videometadata where
> intID="offending intID for duplicate";
> Outside of the bugfix, another option -Folder was added so that you can
> manually override the folder setting to search for new videos. This way
> you could run multiple cron jobs and completely ignore those temporary or
> garbage folders you'd rather not have in the db.
> Sorry for any hassle the bug introduced.
>> There is a new version of the imdb-bulk-update.pl tool available.
>> In this version I included a -Fileup switch to find all new files(of
>> allowable & predefined default file extensions), and compare them with
>> DB information. It'll remove all entries for files that no longer exist,
>> and add all new files that have no information in the DB.
>> I also added a -Manual switch to force a manual entry of IMDBID. This is
>> quite handy when searching for a specific stubborn title with -Title
>> The download URL is the same for now. Eventually it'll get moved to
>> with the rest of mythdora utilities.
>> Feedback is appreciated.
>>> List --
>>> I've taken the liberty of creating an imdb.pl wrapper to use with
>>> mythvideo. This is a commandline tool similar to the
>>> tool that is included with knoppmyth. However that tool is out of date,
>>> and it heavily relies on the production copy of imdb.pl. So when
>>> is out of date the batchgrabber is instantly, and tends to stay that
>>> for a long time.
>>> Anyhow, long story short. I've created a simple, but reliable bulk
>>> for imdb.pl to do batch updates of multiple types against your
>>> videometadata table.
>>> The script still has a dependency on imdb.pl, but in the past this
>>> to be maintained regularly and my tool only depends on a working copy.
>>> Anyhow, I have it out on a freebie file share site for now (takes a
>>> to load download link). But have at it for those that are interested.
>>> The usage is pretty self explanatory. Please send me feedback as
Thanks Ryan, its working great I'll test it further tonight.
More information about the mythtv-users