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

[Ryan Pisani]

List --
There is a new version of the imdb-bulk-update.pl tool. In version 1.7
there are a few new features.

1) Better handling of DVD directories. Previously all .vob would have been
entered into the videometadata table, now the -Fileup function will
recognize DVD structures if they exist and enter a single entered in the
DB for the title.

2) I've added the ability to handle files that have changed directories
under the main video path. So users have incoming directories and may file
videos away under other directories later.

Download link is unchanged:
http://www.4shared.com/file/23145905/548ed5c2/imdbupdatertar.html

Feedback is welcome.

Ryan



>>List --
>
> There is another bugfix version available for the imdb-bulk-update.pl
> tool.
> I found a bug in -Title lookups where the title was populated blank.
>
> http://www.4shared.com/file/23145905/548ed5c2/imdbupdatertar.html
>
> Ryan
>
>  List-
>>
>> There is yet another new version of the imdb-bulk-update.pl tool
>> available.
>>
>> Download link:
>> http://www.4shared.com/file/23145905/548ed5c2/imdbupdatertar.html
>>
>> 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.
>>
>> Ryan
>>>
>>
>>  List-
>>>
>>> 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
>>>
>>
>>
>
>