Allowing only one genre per movie (1 Viewer)

BlackdogZA

Portal Pro
April 22, 2007
76
1
Home Country
United Kingdom United Kingdom
Hi

I appreciate that a movie fits into multiple genres but I find it quite annoying that IMDB allows a movie to have so many genres that it renders a view by genre almost useless for large movie collections.

Is there a way to limit the update from IMDB to say just the first genre?

Editing each movie to change the genre is incredibly time consuming. I guess the other way is a single SQL update statement. Hmm, I might ask the Mrs for help with that.

Other ideas ?
 

Gup

Portal Pro
May 29, 2007
87
13
Home Country
Netherlands Netherlands
Hi,

I understand your problem. The only way i found a solution is to store all movies by genre on disk. Then adding catagories based on full path. This way i decide the genre for the movie and not the crap imdb tag.
 

RoChess

Extension Developer
  • Premium Supporter
  • March 10, 2006
    4,434
    1,897
    You can also work around the limitations of the existing system that you forsee.

    I personally like the multiple-genres done by IMDb, because a movie like 'Scream' is more a comedy to me then a 'Horror', but my wife would look under Horror/Thriller to find it.

    But you can just create your own genre folders, and then add complex exceptions for it, or combinations. For example I got a genre 'Romatic Comedy' that looks for movies that have genre 'Comedy' and 'Romance'. And then exclude those movies from the custom 'Comedy' genre. It can get complex and I got some custom categories with like 30 rules, but only had to set it up once and enjoy it forever (praying that IMDb doesn't decide to change genre naming).

    The problem with only using one genre from IMDb is that the genres are shown in alphabetical order. So eventhough it is easy to adjust the scraper to only grab one genre, the results will not be pretty. Avatar for example will be put under 'Action' and while technically correct, I have it under the Sci-Fi genre myself.
     

    Octagon

    Portal Member
    February 24, 2010
    7
    2
    Home Country
    United States of America United States of America
    On a somewhat related note - is there a (preferably free, of course;) GUI based SQL editor available anywhere?

    Manually editing a large collection is pretty tedious but if I could say select multiple records from a list in one pane and then apply the same change(s) to all of them at once I might be willing to put that time in.

    It would also be useful for managing music collections.

    I've played around with SQLite and can manage basic queries but something a little more user-friendly would definitely be worth a look.
     

    Octagon

    Portal Member
    February 24, 2010
    7
    2
    Home Country
    United States of America United States of America
    Thanks for the link. I don't know how it will help my limited query abilities but the data browser alone was worth the download.

    Very cool.
     

    Users who are viewing this thread

    Top Bottom