[mythtv-users] New/Bugfix Version: Bulk Updater for Videometa(imdb) data

Ryan Pisani mythtv at frouse3.homelinux.com
Mon Sep 24 04:55:57 UTC 2007


There is yet another new version of the imdb-bulk-update.pl tool available.

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 the
> 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
> switch.
> The download URL is the same for now. Eventually it'll get moved to atrpms
> with the rest of mythdora utilities.
> http://www.4shared.com/file/23145905/548ed5c2/imdbupdatertar.html
> Feedback is appreciated.
> Ryan
>> List --
>> I've taken the liberty of creating an imdb.pl wrapper to use with
>> mythvideo. This is a commandline tool similar to the imdbbatchgrabber.pl
>> 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 imdb.pl
>> is out of date the batchgrabber is instantly, and tends to stay that way
>> for a long time.
>> Anyhow, long story short. I've created a simple, but reliable bulk
>> wrapper
>> 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 seems
>> 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
>> second
>> to load download link). But have at it for those that are interested.
>> http://www.4shared.com/file/23145905/548ed5c2/imdbupdatertar.html
>> The usage is pretty self explanatory. Please send me feedback as
>> necessary.
>> Ryan
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users

More information about the mythtv-users mailing list